Install Percona Server (MySQL)

First we need to add Percona yum repo. This can be done by installing rpm provided by Percona.

cd /usr/local/src
wget http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
rpm -ivh percona-release-0.0-1.x86_64.rpm

To see all available Percona Server versions, use yum search

yum search Percona-Server-server

To install Percona Server 5.6 (latest version), run

yum install -y Percona-Server-server-56 Percona-Server-devel-56

After installing, run

/usr/bin/mysql_secure_installation

This command will set password for your Percona MySQL Server installation.

It is better to install percona-toolkit, as it is useful in optimizing MySQL server.

yum install percona-toolkit

Starting Percona MySQL Server

To start Percona Server, run

service mysql start

On CentOS, default MySQL service is “mysqld”, with Percona you just use “mysql”.

Stopping Percona MySQL Server

service mysql stop

Posted in MySQL