How To Install Percona Server on CentOS 7

In this tutorial, we will show you how to install Percona Server on CentOS 7. For those of you who didn’t know,  Percona Server is a drop-in replacement for the MySQL database which uses an enhanced version of the InnoDB Database engine called xtradb. According to the Percona Website, Percona xtradb is designed to provide superior performance, scalability, and instrumentation.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step install the Percona Server on CentOS 7 server.

Prerequisites

• A server running one of the following operating systems: CentOS 7.
• It’s recommended that you use a fresh OS install to prevent any potential issues
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install Percona Server on CentOS 7

Step 1. First, let’s start by ensuring your system is up-to-date.

sudo yum clean all
sudo yum -y update

Step 2. Installing Percona Server on CentOS 7.

First, we will add the repository package from Persona:

sudo yum install https://www.percona.com/redir/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm

Then run the yum repolist command to make sure that the repository is active:

sudo yum repolist
sudo yum search percona | grep server

Next, Install Percona Server using yum install command:

yum install Percona-Server-server-57

After the installation is finished, start the Percona Server:

sudo systemctl start mysqld
sudo systemctl enable mysqld

Note: During the installation, a temporary password is generated for the root user and you can find it in /var/log/mysqld.log file.

grep -i password /var/log/mysqld.log

Step 3. Securing Percona server after installation.

By default, Percona is not hardened. You can secure Percona using the mysql_secure_installation script. you should read and below each step carefully which will set a root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure Percona:

mysql_secure_installation

Congratulations! You have successfully installed Percona. Thanks for using this tutorial for installing Install Percona Server on CentOS 7 systems. For additional help or useful information, we recommend you check the official Install Percona website.