How to Install Percona Server for MySQL on CentOS 7

1. Download the packages of the desired series for your architecture from the download page. The easiest way is to download bundle which contains all the packages. Following example will download Percona Server for MySQL 8.0.13-4 release packages for CentOS 7:



# wget https://www.percona.com/downloads/Percona-Server-8.0/Percona-Server-8.0.13-4/binary/redhat/7/x86_64/Percona-Server-8.0.13-4-rf0a32b8-el7-x86_64-bundle.tar



2. You should then unpack the bundle to get the packages:



# tar xvf Percona-Server-8.0.13-4-rf0a32b8-el7-x86_64-bundle.tar


After you unpack the bundle you should see the following packages when running



# ls *.rpm percona-mysql-router-8.0.13-4.1.el7.x86_64.rpm percona-server-client-8.0.13-4.1.el7.x86_64.rpm percona-server-debuginfo-8.0.13-4.1.el7.x86_64.rpm percona-server-devel-8.0.13-4.1.el7.x86_64.rpm percona-server-rocksdb-8.0.13-4.1.el7.x86_64.rpm percona-server-server-8.0.13-4.1.el7.x86_64.rpm percona-server-shared-8.0.13-4.1.el7.x86_64.rpm percona-server-shared-compat-8.0.13-4.1.el7.x86_64.rpm percona-server-test-8.0.13-4.1.el7.x86_64.rpm percona-server-tokudb-8.0.13-4.1.el7.x86_64.rpm



3. Now you can install Percona Server for MySQL 8.0 by running :



# rpm -ivh percona-server-server-80-8.0.13-4-rf0a32b8.el7.x86_64.rpm \    percona-server-client-80-8.0.13-4.1.el7.x86_64.rpm \    percona-server-shared-80-8.0.13-4.1.el7.x86_64.rpm \    percona-server-shared-compat-80-8.0.13-4.1.el7.x86_64.rpm # systemctl start mysqld # systemctl enable mysqld

Harden MySQL Server

1. Run the mysql_secure_installation script to address several security concerns in a default MySQL installation.



# mysql_secure_installation


You will be given the choice to change the MySQL root password, remove anonymous user accounts, disable root logins outside of localhost, and remove test databases. It is recommended that you answer yes to these options.



NOTE  If MySQL 5.7 was installed, you will need the temporary password that was created during installation. This password is notated in the /var/log/mysql.log file, and can be quickly found using the following command. # grep 'temporary password' /var/log/mysqld.log