Install Percona in CentOS

This tutorial helps you install percona server in CentOS as a replacement for MySQL server. According to Percona, Their “MySQL service clients and open source software users achieve breakthrough results with MySQL: cost savings, faster time to market, higher system up-time, and long-term scalability. MySQL performance is a focus for all that we do”.

1. If we do have MySQL server installed on the server, it is better to install the same percona server version so that ALL data can be kept in tact.
2. Setup Percona yum Repository:

   $ rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

3. If we do have mysql installed with php-mysql extension before, just remove it:

   $ yum remove mysql-libs

4. Install Percona server and client software:

   $ yum install --nogpgcheck Percona-Server-client-55 Percona-Server-server-55

5. Re-install php-mysql library:

   $ yum install mysql-libs

   . If mysql and php is installed using remi repository, remember to use

   $ yum --enablerepo=remi install mysql-libs

   instead.

6. One important thing to remember: Percona use the service named mysql, not mysqld as MySQL server. So when starting the mysql service, remember to use

   $ service mysql start

That’s all. Happy performance tuning with Percona server 🙂