How to Install Percona DB Server

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.

Installing Percona

  1. SSH into your server as the root user.
  2. 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
  3. 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.

  4. Run the following command to install epel. This will allow you to install libev, which is required.
    yum install epel-release
  5. You will see the following message, type ‘y‘ for yes then click enter.
    Installed size: 22 k
    Is this ok [y/N]: y

  6. Run the following command to install libev.
    yum install libev
  7. 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
  8. Run the following command to install Percona XtraBackup. This will allow you to revert the changes if necessary.
    yum install percona-xtrabackup
  9. When you see the following message, type ‘y‘ for yes then click enter. You should see this message twice. Is this ok [y/N]:
  10. Create a backup by running this command:
    xtrabackup --target-dir=/backup/xtrabackup --backup

    Then, run this command:

    xtrabackup --target-dir=/backup/xtrabackup --prepare
  11. Stop and remove MySQL by running the following commands:
    service mysql stop

    Then, run this command:

    yum remove MySQL* mysql*
  12. Run the following command to install Percona Server:
    yum install Percona-Server-server-57 percona-toolkit percona-xtrabackup
  13. 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!

JB
John-Paul Briones Content Writer II

John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

More Articles by John-Paul

Comments

It looks like this article doesn't have any comments yet - you can be the first. If you have any comments or questions, start the conversation!

Was this article helpful? Let us know!