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:
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.