How to replace MySQL with Percona Server on RHEL or CentOS in Vesta Control Panel

Replace MySQL with Percona Server on RHEL or CentOS in Vesta Control Panel

You can safely replace MySQL with Percona Server without lossing any data. In order to do it, please follow the instructions bellow

1. Install Percona repository

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

2. Remove MySQL packages

yum remove mysql mysql-server mysql-libs

3. Install Percona packages

yum install Percona-Server-server-55

4. Start Percona Server

service mysql start

5. Set Percona Server to auto-start

chkconfig mysql on

Please note that you might also need to update php-mysqlnd package if you are using remi

yum install php-mysqlnd phpmyadmin –enablerepo=remi
mv /etc/httpd/conf.d/phpMyAdmin.conf.rpmsave /etc/httpd/conf.d
service httpd restart