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.