Skip to content
logo
Percona Product Documentation
Installing Percona Server for MySQL on Red Hat Enterprise Linux and CentOS
Initializing search
    percona/psmysql-docs
    percona/psmysql-docs
    • Home
      • The Percona XtraDB Storage Engine
      • List of features available in Percona Server for MySQL releases
      • Percona Server for MySQL Feature Comparison
      • Changed in Percona Server 8.0
      • Understand version numbers
      • Installing Percona Server for MySQL
      • Post-Installation
      • Percona Server for MySQL In-Place Upgrading Guide: From 5.7 to 8.0
      • Upgrading using the Percona repositories
      • Upgrading from Systems that Use the MyRocks or TokuDB Storage Engine and Partitioned Tables
      • Upgrading using Standalone Packages
      • Running Percona Server for MySQL in a Docker Container
      • Docker config
      • Improved InnoDB I/O Scalability
      • Adaptive Network Buffers
      • Multiple page asynchronous I/O requests
      • Thread Pool
      • XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
      • Prefix Index Queries Optimization
      • Limiting the Estimation of Records in a Query
      • Jemalloc Memory Allocation Profiling
      • The ProcFS plugin
      • Binlogging and replication improvements
      • Compressed columns with dictionaries
      • Extended SELECT INTO OUTFILE/DUMPFILE
      • Extended SET VAR Optimizer Hint
      • Improved MEMORY Storage Engine
      • Suppress Warning Messages
      • Limiting the disk space used by binary log files
      • Support for PROXY protocol
      • SEQUENCE_TABLE(n) Function
      • Slow Query Log Rotation and Expiration
      • Too Many Connections Warning
      • Handle Corrupted Tables
      • Percona Toolkit UDFs
      • Kill Idle Transactions
      • XtraDB changed page tracking
      • Enforcing Storage Engine
      • Expanded Fast Index Creation
      • Backup Locks
      • Audit Log Plugin
      • Start transaction with consistent snapshot
      • Extended SHOW GRANTS
      • Utility user
      • PAM Authentication Plugin
      • Using LDAP authentication plugins
      • LDAP authentication plugin system variables
      • Working with SELinux
      • Working with AppArmor
      • Data at Rest Encryption
      • Using the keyring component or keyring plugin
      • Using the Key Management Interoperability Protocol (KMIP)
      • Encryption functions
      • Using the Amazon Key Management Service (AWS KMS)
      • FIDO authentication plugin
      • Rotating the Master Key
      • Encrypting File-Per-Table Tablespace
      • Encrypting a Schema or a General Tablespace
      • Encrypting the System Tablespace
      • Encrypting Temporary Files
      • Encrypting Binary Log Files and Relay Log Files
      • Encrypting the Redo Log files
      • Encrypting the Undo Tablespace
      • Working with Advanced Encryption Key Rotation
      • Encrypting Doublewrite Buffers
      • Verifying the Encryption for Tables, Tablespaces, and Schemas
      • SSL Improvements
      • Data Masking
      • Server variables
      • User Statistics
      • Slow Query Log
      • Extended Show Engine InnoDB Status
      • Show Storage Engines
      • Process List
      • Misc. INFORMATION_SCHEMA Tables
      • Thread Based Profiling
      • InnoDB Page Fragmentation Counters
      • Stacktrace
      • Libcoredumper
      • Manage Group Replication flow control
      • Group replication system variables
      • Percona MyRocks Introduction
      • Percona MyRocks Installation Guide
      • Updated Supported Features
      • MyRocks Limitations
      • Differences between Percona MyRocks and Facebook MyRocks
      • MyRocks Information Schema Tables
      • MyRocks Server Variables
      • MyRocks Status Variables
      • Gap locks detection
      • Data Loading
      • Installing and configuring Percona Server for MySQL with ZenFS support
      • TokuDB Introduction
      • TokuDB Installation
      • Using TokuDB
      • Fast Updates with TokuDB
      • TokuDB files and file types
      • TokuDB file management
      • TokuDB Background ANALYZE TABLE
      • TokuDB Variables
      • TokuDB Status Variables
      • TokuDB Fractal Tree Indexing
      • TokuDB Troubleshooting
      • TokuDB Performance Schema Integration
      • Frequently Asked Questions
      • Migrating and Removing the TokuDB storage engine
      • Percona TokuBackup
      • Percona Server for MySQL 8.0 Release notes
      • Percona Server for MySQL 8.0.30-22 (2022-11-21)
      • Percona Server for MySQL 8.0.29-21 (2022-08-08)
      • Percona Server for MySQL 8.0.28-20 (2022-06-20)
      • Percona Server for MySQL 8.0.28-19 (2022-05-12)
      • Percona Server for MySQL 8.0.27-18 (2022-03-02)
      • Percona Server for MySQL 8.0.26-17 (2022-01-26)
      • Percona Server for MySQL 8.0.26-16 (2021-10-20)
      • Percona Server for MySQL 8.0.25-15 (2021-07-13)
      • Percona Server for MySQL 8.0.23-14 (2021-05-12)
      • Percona Server for MySQL 8.0.22-13 (2020-12-14)
      • Percona Server for MySQL 8.0.21-12 (2020-10-13)
      • Percona Server for MySQL 8.0.20-11 (2020-07-21)
      • Percona Server for MySQL 8.0.19-10 (2020-03-23)
      • Percona Server for MySQL 8.0.18-9
      • Percona Server for MySQL 8.0.17-8
      • Percona Server for MySQL 8.0.16-7
      • Percona Server for MySQL 8.0.15-6
      • Percona Server for MySQL 8.0.15-5
      • Percona Server for MySQL 8.0.14
      • Percona Server for MySQL 8.0.13-4
      • Percona Server for MySQL 8.0.13-3
      • Percona Server for MySQL 8.0.12-2rc1
      • List of upstream MySQL bugs fixed in Percona Server for MySQL 8.0
      • List of variables introduced in Percona Server for MySQL 8.0
      • Development of Percona Server for MySQL
      • Trademark policy
      • Index of INFORMATION_SCHEMA Tables
      • Frequently Asked Questions
      • Copyright and licensing information
      • Glossary
    • What’s in each RPM package?
    • Installing Percona Server for MySQL from Percona yum repository
      • Percona yum Testing repository
    • Installing Percona Server for MySQL using downloaded rpm packages
    • Running Percona Server for MySQL
    • SELinux and security considerations
    • Uninstalling Percona Server for MySQL

    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. 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.

    Percona Server for MySQL is certified for Red Hat Enterprise Linux 8. This certification is based on common and secure best practices and successful interoperability with the operating system. Percona Server is listed in the Red Hat Ecosystem Catalog.

    Note

    The RPM packages for Red Hat Enterprise Linux 7 and the compatible derivatives do not support TLSv1.3, as it requires OpenSSL 1.1.1, which is currently not available on this platform.

    What’s in each RPM package?¶

    Each of the Percona Server for MySQL RPM packages has a particular purpose.

    Package Contains
    percona-server-server Server itself (the mysqld binary)
    percona-server-debuginfo Debug symbols for the server
    percona-server-client Command line client
    percona-server-devel Header files needed to compile software using the client library.
    percona-server-shared Client shared library.
    percona-server-shared-compat Shared libraries for software compiled against old versions of the client library. The following libraries are included in this package: libmysqlclient.so.12, libmysqlclient.so.14, libmysqlclient.so.15, libmysqlclient.so.16, and libmysqlclient.so.18.
    percona-server-test Includes the test suite for Percona Server for MySQL.

    Installing Percona Server for MySQL from Percona yum repository¶

    You can install Percona yum repository by running the following commands as a root user or with sudo.

    1. Install the Percona repository

      $ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
      

      You should see an output that the files are being downloaded, like the following:

      percona-release-latest.noarch-rpm               36 kB/s | 19 kb 00:00
      =====================================================================
        Package         Architecture      Version    Repository    Size
      =====================================================================
      Installing:
         percona release noarch         1.0-25     @commandline  19k
      ...
      
    2. Enable the repository:

      $ sudo percona-release setup ps80
      

      The output could be like the following:

      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
      ...
      
    3. Install the packages

      $ sudo yum install percona-server-server
      

      Note

      Percona Server for MySQL 8.0 also provides the TokuDB storage engine and MyRocks storage engines which can be installed as plugins.

    Starting with Percona Server for MySQL 8.0.28-19 (2022-05-12), the TokuDB storage engine is no longer supported. We have removed the storage engine from the installation packages and disabled the storage engine in our binary builds. For more information, see TokuDB Introduction.

    For more information on how to install and enable the TokuDB storage review the TokuDB Installation document. For information on how to install and enable MyRocks review the section Percona MyRocks Installation Guide.

    Percona yum Testing repository¶

    Percona offers pre-release builds from our testing repository. To subscribe to the testing repository, you 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 three sections in this file: release, testing, and experimental - in this case, it is the second section that requires updating).

    Note

    You must install the Percona repository first if the installation has not been done already.

    Installing Percona Server for MySQL using downloaded rpm packages¶

    1. Download the packages of the desired series for your architecture from the download page. The easiest way is to download the bundle which contains all the packages. The following example downloads Percona Server for MySQL 8.0.21-12 release packages for RHEL 8.

      $ wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.29-21/binary/redhat/8/x86_64/Percona-Server-8.0.29-21-rc59f87d2854-el8-x86_64-bundle.tar
      
    2. Unpack the bundle to get the packages: tar xvf Percona-Server-8.0.29-21-rc59f87d2854-el8-x86_64-bundle.tar

    3. To view a list of packages, run the following command:

      $ ls *.rpm
      
      The output should look like the following:

      percona-icu-data-files-8.0.29-21.1.el8.x86_64.rpm
      percona-mysql-router-8.0.29-21.1.el8.x86_64.rpm
      percona-mysql-router-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-client-8.0.29-21.1.el8.x86_64.rpm
      percona-server-client-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-debugsource-8.0.29-21.1.el8.x86_64.rpm
      percona-server-devel-8.0.29-21.1.el8.x86_64.rpm
      percona-server-rocksdb-8.0.29-21.1.el8.x86_64.rpm
      percona-server-rocksdb-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-server-8.0.29-21.1.el8.x86_64.rpm
      percona-server-server-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-shared-8.0.29-21.1.el8.x86_64.rpm
      percona-server-shared-compat-8.0.29-21.1.el8.x86_64.rpm
      percona-server-shared-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      percona-server-test-8.0.29-21.1.el8.x86_64.rpm
      percona-server-test-debuginfo-8.0.29-21.1.el8.x86_64.rpm
      
    4. Install jemalloc with the following command, if needed:

      wget https://repo.percona.com/yum/release/8/RPMS/x86_64/jemalloc-3.6.0-1.el8.x86_64.rpm
      
    5. For an EL8-based RHEL distribution or derivatives package installation, the Percona Server for MySQL requires the mysql module to be disabled before installing the packages:

      sudo yum module disable mysql
      
    6. Install all the packages (for debugging, testing, etc.) with the following command:

      $ sudo rpm -ivh *.rpm
      

      Note

      When installing packages manually, you must make sure to resolve all dependencies and install any missing packages yourself.

    Running Percona Server for MySQL¶

    Percona Server for MySQL stores the data files in /var/lib/mysql/ by default. The configuration file used to manage Percona Server for MySQL is the /etc/my.cnf.

    The following commands start, provide the server status, stop the server, and restart the server.

    Note

    The RHEL distributions and derivatives come with systemd as the default system and service manager so you can invoke all of the commands with sytemctl instead of service. Currently, both options are supported.

    • Percona Server for MySQL is not started automatically on the RHEL distributions and derivatives after installation. Start the server with the following command:

      $ sudo service mysql start
      
    • Review the service status with the following command:

      $ sudo service mysql status
      
    • Stop the service with the following command:

      $ sudo service mysql stop
      
    • Restart the service with the following command:

      $ sudo service mysql restart
      

    SELinux and security considerations¶

    For information on working with SELinux, see Working with SELinux.

    The RHEL 8 distributions and derivatives have added system-wide cryptographic policies component. This component allows the configuration of cryptographic subsystems.

    Uninstalling Percona Server for MySQL¶

    To completely uninstall Percona Server for MySQL, remove all the installed packages and data files.

    1. Stop the Percona Server for MySQL service:

      $ sudo service mysql stop
      
    2. Remove the packages:

      $ sudo yum remove percona-server*
      
    3. Remove the data and configuration files:

      Warning

      This step removes all the packages and deletes all the data files (databases, tables, logs, etc.). Take a backup before doing this in case you need the data.

      $ rm -rf /var/lib/mysql
      $ rm -f /etc/my.cnf
      

    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 consulting services , contact Percona Sales.


    Last update: 2022-09-27
    Back to top
    Percona LLC, © 2022
    Made with Material for MkDocs