e Learning

How to 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 xtradb Server on CentOS 7. We will do the following steps to install Percona xtradb Server on CentOS 7.

  1. Add Percona repository for CentOS 7.
  2. Install Percona Server using yum install command.

Add Percona repository for CentOS 7

Add Percona repository for CentOS 7 by running the following command.

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

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

yum repolist

Install Percona Server using yum install command

First, run the yum search command to find available version of Percona XtraDB Server.

yum search percona | grep server

How to Install Percona Server on CentOS 7

As above screenshot shows, I have the latest version Percona server-57 which i can install using yum install command.

yum install Percona-Server-server-57

After the installation is finished, start the Percona Server using the systemctl command.

systemctl start mysqld

systemctl enable mysqld

Percona Server MySQL root Password in CentOS 7

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

Percona Server MySQL root Password in CentOS 7

You can run mysql_secure_installation command to change the mysql root password.

mysql_secure_installation

Percona xtradb Server works the same way as MySQL Server, So you can administrate the Percona Server same way you did on the MySQL Server. For example, to access the MySQL console type,

mysql -u root -p

So that is how we can install Percona xtradb Server on CentOS 7. For more information, you can read the documentation page of the Percona Server.