Installing Percona Server at cPanel/WHM
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