Installing Percona Server for MySQL on Red Hat Enterprise Linux and CentOS¶
Ready-to-use packages are available from the Percona Server for MySQL software repositories and the download page. The Percona yum repository supports popular RPM-based operating systems, including the Amazon Linux AMI.
The easiest way to install the Percona Yum repository is to install an RPM that configures yum and installs the Percona GPG key.
Specific information on the supported platforms, products, and versions are described in Percona Software and Platform Lifecycle.
What’s in each RPM package?¶
Each of the Percona Server for MySQL RPM packages have a particular purpose.
The Percona-Server-server-57
package contains the server itself (the mysqld
binary).
The Percona-Server-57-debuginfo
package contains debug symbols for the server.
The Percona-Server-client-57
package contains the command line client.
The Percona-Server-devel-57
package contains the header files needed to compile software using the client library.
The Percona-Server-shared-57
package includes the client shared library.
The Percona-Server-shared-compat
package includes shared libraries for software compiled against old versions of the client library. Following libraries are included in this package: libmysqlclient.so.12
, libmysqlclient.so.14
, libmysqlclient.so.15
, libmysqlclient.so.16
, and libmysqlclient.so.18
.
The Percona-Server-test-57
package includes the test suite for Percona Server for MySQL.
Installing Percona Server for MySQL from Percona yum
repository¶
Install the Percona repository
You can install Percona yum repository by running the following command as a
root
user or with sudo:
You can install Percona yum repository by running the following command as a
root
user or with sudo:
Output example
Retrieving https://repo.percona.com/yum/percona-release-latest.noarch.rpm Preparing... ########################################### [100%] 1:percona-release ########################################### [100%]To install Percona Server for MySQL with SELinux policies, you also need the Percona-Server-selinux-*.noarch.rpm package:
$ yum install http://repo.percona.com/centos/7/RPMS/x86_64/Percona-Server-selinux-57-5.7.31-rel84.2.el7.noarch.rpm
Testing the repository
Make sure packages are now available from the repository, by executing the following command:
yum list | grep percona
You should see output similar to the following:
... Percona-Server-57-debuginfo.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-client-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-devel-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-server-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-shared-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-shared-compat-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-test-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 Percona-Server-tokudb-57.x86_64 5.7.31-34.1.el7 @percona-release-x86_64 ... .. note:: For a RHEL 8 package installation, the mysql module must be disabled.
$ sudo dnf module disable mysql
Install the packages
You can now install Percona Server for MySQL by running:
yum install Percona-Server-server-57
Note
Percona Server for MySQL 5.7 comes with the TokuDB storage engine. You can find more information on how to install and enable the TokuDB storage in the TokuDB Installation guide.
Percona yum Testing repository¶
Percona offers pre-release builds from our testing repository. To subscribe to the testing repository, you’ll need to enable the testing repository in /etc/yum.repos.d/percona-release.repo
. To do so, set both percona-testing-$basearch
and percona-testing-noarch
to enabled = 1
(Note that there are 3 sections in this file: release, testing and experimental - in this case it is the second section that requires updating). NOTE: You’ll need to install the Percona repository first (ref above) if this hasn’t been done already.
Installing Percona Server for MySQL using downloaded rpm packages¶
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 5.7.31-34 release packages for CentOS 7:
$ wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.31-34/binary/redhat/7/x86_64/Percona-Server-5.7.31-34-r2e68637-el7-x86_64-bundle.tar
You should then unpack the bundle to get the packages:
$ tar xvf Percona-Server-5.7.31-34-r2e68637-el7-x86_64-bundle.tar
After you unpack the bundle you should see the following packages:
$ ls *.rpm Percona-Server-57-debuginfo-5.7.31-34.1.el7.x86_64.rpm Percona-Server-client-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-devel-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-rocksdb-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-server-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-shared-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-shared-compat-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-test-57-5.7.31-34.1.el7.x86_64.rpm Percona-Server-tokudb-57-5.7.31-34.1.el7.x86_64.rpm
Now you can install Percona Server for MySQL 5.7 by running:
rpm -ivh Percona-Server-server-57-5.7.31-34.1.el7.x86_64.rpm \ Percona-Server-client-57-5.7.31-34.1.el7.x86_64.rpm \ Percona-Server-shared-57-5.7.31-34.1.el7.x86_64.rpm
This will install only packages required to run the Percona Server for MySQL 5.7.
Optionally, you can install either the TokuDB storage engine, adding Percona-Server-tokudb-57-5.7.31-34.1.el7.x86_64.rpm
or the MyRocks storage engine, adding Percona-Server-rocksdb-57-5.7.31-34.1.el7.x86_64.rpm
to the install command.
You can find more information on how to install and enable the TokuDB storage in the TokuDB Installation guide.
You can find more information on how to install and enable the MyRocks storage engine in the Percona MyRocks Installation Guide guide.
To install all the packages (for debugging, testing, etc.) you should run:
$ rpm -ivh *.rpm
Note
When installing packages manually like this, you’ll need to make sure to resolve all the dependencies and install missing packages yourself.
The following table lists the default locations for files:
Files | Location |
---|---|
mysqld server | /usr/bin |
Configuration | /etc/my.cnf |
Data directory | /var/lib/mysql |
Logs | /var/log/mysqld.log |
You can use the following command to locate the Data directory:
grep datadir /etc/my.cnf
datadir=/var/lib/mysql
Running Percona Server for MySQL¶
Starting the service
Percona Server for MySQL does not start automatically on RHEL and CentOS after the installation. You should start the server by running:
service mysql start
Confirming that service is running
You can check the service status by running:
service mysql status
Stopping the service
You can stop the service by running:
service mysql stop
Restarting the service
You can restart the service by running:
service mysql restart
Note
RHEL 7 and CentOS 7 come with systemd as the default system and service manager so you can invoke all the above commands with sytemctl
instead of service
. Currently both are supported.
Uninstalling Percona Server for MySQL¶
To completely uninstall Percona Server for MySQL you’ll need to remove all the installed packages and data files.
Stop the Percona Server for MySQL service
service mysql stop
Remove the packages
yum remove Percona-Server*
Remove the data and configuration files
rm -rf /var/lib/mysql rm -f /etc/my.cnf
Warning
This will remove all the packages and delete all the data files (databases, tables, logs, etc.), you might want to take a backup before doing this in case you need the data.
Contact Us
For free technical help, visit the Percona Community Forum.To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.