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

Set root password

Make sure to start Percona

service mysqld start

Log into mysql and check the users

mysql -u root

SELECT User, Host, Password FROM mysql.user;

Now set the root passwords

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('briansnelson');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('briansnelson');
SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('briansnelson');

Additional Articles:

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