(2024.2) Percona Installation

Note: This page contains instructions for installing Percona with MySQL 8, or MySQL 5.7. Both Databases are supported by PCR-360, so please make sure to follow the instructions related to the version you are installing. MySQL 8 is the preferred installation option, as support for MySQL 5.7 will start to be replaced by MySQL 8.

Installing Percona MySQL 8 on Centos/Red Hat (Recommended for new installs)

#become root
sudo su
 
# remove any previous installs
service mysql stop
yum remove mysql-dev mysql-server mysql-libs Percona-Server*
 
#enable the repository
sudo percona-release setup ps80
On RedHat 8 systems it is needed to disable dnf mysql module to install Percona-Server
Do you want to disable it? [y/N] y
...

# remove an residual db info
rm -rf /var/lib/mysql
rm -f /etc/my.cnf
 
# install Percona repos
sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
 
# install percona server (and client)
sudo yum install percona-server-server
 
# start the server
service mysql start
 
# get the temp root password
grep -o "temporary password is generated for root@localhost.*" /var/log/mysqld.log | cut -f2- -d: | tail -1 | sed -e 's/^[[:space:]]*//'
 
# secure the installation
mysql_secure_installation -p
 
# restart the server
service mysql restart

Installing Percona MySQL 5.7

#become root
sudo su
 
# remove any previous installs
service mysql stop
yum remove mysql-dev mysql-server mysql-libs Percona-Server*
 
# remove an residual db info
rm -rf /var/lib/mysql
rm -f /etc/my.cnf
 
# install Percona repos
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
 
# install percona server (and client)
yum install Percona-Server-server-57
 
# start the server
service mysql start
 
# get the temp root password
grep -o "temporary password is generated for root@localhost.*" /var/log/mysqld.log | cut -f2- -d: | tail -1 | sed -e 's/^[[:space:]]*//'
 
# secure the installation
mysql_secure_installation -p
 
# restart the server
service mysql restart

Setting up the database

Log In to the Database as root

mysql -u root -p

PCR-360 Wiki

(2024.2) Percona Installation

Installing Percona MySQL 8 on Centos/Red Hat (Recommended for new installs)

Installing Percona MySQL 5.7

Setting up the database

Log In to the Database as root

Run the Create Script MySQL 8

Run the Create Script MySQL 5.7

Create stored functions and procedures

Update the MySQL Configuration file Mysql 8

Update the MySQL Configuration file Mysql 5.7