How To Install Percona Server on CentOS 7 Step by Step

Install Percona Server on CentOS 7

Percona Server is a drop-in replacement for the MySQL database which use an enhanced version of InnoDB Database engine called xtradb. According to the Percona Website Percona xtradb is designed to provide superior performance, scalability and instrumentation. In this tutorial we will learn how to Install Percona Server on CentOS 7 Step by Step.

Prerequisites

This tutorial 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.

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 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 steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure Percona:

mysql_secure_installation

Congratulation’s! You have successfully installed 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 to check the official Install Percona web site.