How To Install Percona Server on CentOS 7

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 through the step-by-step install Percona Server on CentOS 7 server.

Install Percona Server on CentOS 7

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

yum clean all
yum -y update

Step 2. Installing Percona Server on CentOS 7.

First, we will add the repository package from Persona:

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:

yum repolist
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:

systemctl start mysqld
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 install 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.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get the best deal!