In this tutorial we will show you how to install Percona DB server via SSH. This will allow you to replace MySQL with Percona DB Server.
Percona DB Server is not officially supported by cPanel and InMotion at this time. You will need Root Access to complete this guide.
Installing Percona
- SSH into your server as the root user.
- Run the following command to download the Percona package:
yum install https://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
You will see the following message, type ‘y’ for yes then click the enter key. Total size: 5.8 k
Installed size: 5.8 k
Is this ok [y/N]:You should then see a “Complete!” message.
- Run the following command to install epel. This will allow you to install libev, which is required.
yum install epel-release
You will see the following message, type ‘y‘ for yes then click enter.
Installed size: 22 k
Is this ok [y/N]: y- Run the following command to install libev.
yum install libev
- You will see the following message, type ‘y‘ for yes then click enter.
Total download size: 113 k
Installed size: 151 k
Is this ok [y/N]: y - Run the following command to install Percona XtraBackup. This will allow you to revert the changes if necessary.
yum install percona-xtrabackup
When you see the following message, type ‘y‘ for yes then click enter. You should see this message twice. Is this ok [y/N]:
- Create a backup by running this command:
xtrabackup --target-dir=/backup/xtrabackup --backup
Then, run this command:
xtrabackup --target-dir=/backup/xtrabackup --prepare
- Stop and remove MySQL by running the following commands:
service mysql stop
Then, run this command:
yum remove MySQL* mysql*
- Run the following command to install Percona Server:
yum install Percona-Server-server-57 percona-toolkit percona-xtrabackup
At this point Percona DB Server has been installed. You can verify this by logging into cPanel, clicking phpMyAdmin, then viewing the Database Type in the Database server section.
Congratulations, now you know how to install Percona DB Server on your server!