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. database percona is this okYou 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]:

    database percona complete

    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. database percona install epelYou 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. database percona installWhen 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. database percona percona db server type phpmyadminAt 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

Was this article helpful? Let us know!