Installing Percona Server at cPanel/WHM

From vpsget wiki
Jump to: navigation, search

1. Backup database.

# mysqldump --all-databases --routines --triggers > /home/db_dump/alldb.sql
# service mysql stop
# cp -r /var/lib/mysql/mysql /home/db_dump/
# service mysql start
# mv /etc/my.cnf /etc/my.cnf.bak

2. Disable MySQL in WHM.

# /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
# /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55

3. Add percona repository. Create the file:

# nano /etc/yum.repos.d/percona.repo

Paste the following lines and save:

[percona]
name = CentOS $releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
enabled = 1
gpgkey = http://www.percona.com/redir/downloads/percona-release/RPM-GPG-KEY-percona
gpgcheck = 1

4. Unlock php in /etc/yum.conf file and install Percona:

# yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55 percona-toolkit perl-DBD-MySQL
# /etc/init.d/mysql start
# mysql_upgrade
# /etc/init.d/mysql restart

For 32 bit systems:

#ln -s /usr/lib/libperconaserverclient.so /usr/lib/libmysqlclient.so

For 64 bit systems:

#ln -s /usr/lib64/libperconaserverclient.so /usr/lib64/libmysqlclient.so

Lock back php in /etc/yum.conf file and rebuild Apache:

# /scripts/easyapache --build