How to install Percona Database Server

How to install Percona Database Server

You have heard of all the performace increases by using Percona over normal MySQL.

Now you want to install Percona on your Centos system.

From http://www.percona.com

First you will want to install the repo

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

Now you can run

yum install Percona-Server-server-56 Percona-Server-client-56

This will install Percona's Server 5.6 package.

Testing the Percona Repo

Make sure the packages are downloadable from the Repo

yum list | grep percona

You will see something like:

Percona-Server-server-51.x86_64         5.1.72-rel14.10.597.rhel6      percona
Percona-Server-server-55.x86_64         5.5.34-rel32.0.591.rhel6       percona
Percona-Server-server-56.x86_64         5.6.14-rel62.0.483.rhel6       percona
Percona-Server-shared-51.x86_64         5.1.72-rel14.10.597.rhel6      percona
Percona-Server-shared-55.x86_64         5.5.34-rel32.0.591.rhel6       percona

Additional Articles:

• MySQL - Check Which Query is Consuming Resources
• Rest your MySQL Admin Password
• How to Convert Table to InnoDB