docs.percona.com Open in urlscan Pro
74.121.199.231  Public Scan

Form analysis
3 forms found in the DOM

<form class="md-header__option" data-md-component="palette">
  <input class="md-option" data-md-color-media="(prefers-color-scheme: light)" data-md-color-scheme="percona-light" data-md-color-primary="" data-md-color-accent="" aria-label="Switch to dark mode" type="radio" name="__palette" id="__palette_1">
  <label class="md-header__button md-icon" title="Switch to dark mode" for="__palette_2">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M17 6H7c-3.31 0-6 2.69-6 6s2.69 6 6 6h10c3.31 0 6-2.69 6-6s-2.69-6-6-6zm0 10H7c-2.21 0-4-1.79-4-4s1.79-4 4-4h10c2.21 0 4 1.79 4 4s-1.79 4-4 4zM7 9c-1.66 0-3 1.34-3 3s1.34 3 3 3 3-1.34 3-3-1.34-3-3-3z"></path>
    </svg>
  </label>
  <input class="md-option" data-md-color-media="(prefers-color-scheme: dark)" data-md-color-scheme="slate" data-md-color-primary="" data-md-color-accent="" aria-label="Switch to light mode" type="radio" name="__palette" id="__palette_2">
  <label class="md-header__button md-icon" title="Switch to light mode" for="__palette_1" hidden="">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M17 7H7a5 5 0 0 0-5 5 5 5 0 0 0 5 5h10a5 5 0 0 0 5-5 5 5 0 0 0-5-5m0 8a3 3 0 0 1-3-3 3 3 0 0 1 3-3 3 3 0 0 1 3 3 3 3 0 0 1-3 3Z"></path>
    </svg>
  </label>
</form>

Name: search —

<form class="md-search__form" name="search">
  <input type="text" class="md-search__input" name="query" aria-label="Search" placeholder="Search" autocapitalize="off" autocorrect="off" autocomplete="off" spellcheck="false" data-md-component="search-query" required="">
  <label class="md-search__icon md-icon" for="__search">
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"></path>
    </svg>
    <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
      <path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8 11h12Z"></path>
    </svg>
  </label>
  <nav class="md-search__options" aria-label="Search">
    <button type="reset" class="md-search__icon md-icon" title="Clear" aria-label="Clear" tabindex="-1">
      <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
        <path d="M19 6.41 17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12 19 6.41Z"></path>
      </svg>
    </button>
  </nav>
</form>

Name: consent —

<form class="md-consent__form md-grid md-typeset" name="consent">
  <h4>Cookie consent</h4>
  <p>We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation
    better.</p>
  <input class="md-toggle" type="checkbox" id="__settings">
  <div class="md-consent__settings">
    <ul class="task-list">
      <li class="task-list-item">
        <label class="task-list-control">
          <input type="checkbox" name="analytics" checked="">
          <span class="task-list-indicator"></span> Google Analytics </label>
      </li>
      <li class="task-list-item">
        <label class="task-list-control">
          <input type="checkbox" name="github" checked="">
          <span class="task-list-indicator"></span> GitHub </label>
      </li>
    </ul>
  </div>
  <div class="md-consent__controls">
    <button class="md-button md-button--primary">Accept</button>
    <label class="md-button" for="__settings">Manage settings</label>
  </div>
</form>

Text Content

Skip to content


Percona Server for MySQL
5.7
 * 8.0 (LATEST)
 * 5.7

Installing Percona Server for MySQL 5.7 on Red Hat Enterprise Linux and CentOS

Type to start searching
percona/psmysql-docs
Percona Server for MySQL
percona/psmysql-docs
 * Home
 * Introduction
   Introduction
    * List of features available in Percona Server for MySQL releases
    * The Percona XtraDB Storage Engine
    * Percona Server for MySQL Feature Comparison
    * Changed in Percona Server 5.7
    * Understand version numbers

 * Installation
   Installation
    * Installing Percona Server for MySQL 5.7
    * Installing Percona Server for MySQL 5.7 on Debian and Ubuntu
    * Installing Percona Server for MySQL 5.7 on Red Hat Enterprise Linux and
      CentOS Installing Percona Server for MySQL 5.7 on Red Hat Enterprise Linux
      and CentOS
      On this page
       * What’s in each RPM package?
       * Installing from the Percona YUM repository
          * Percona yum Testing repository
      
       * Installing Percona Server for MySQL using downloaded rpm packages
       * Running Percona Server for MySQL
       * Uninstalling Percona Server for MySQL
   
    * Installing _Percona Server for MySQL_ 5.7 from a Binary Tarball
    * Installing _Percona Server for MySQL_ 5.7 from a Source Tarball
    * Compiling Percona Server for MySQL 5.7 from Source
    * Installing Percona Server for MySQL 5.7 from the Git Source Tree

 * Run in Docker
   Run in Docker
    * Running Percona Server for MySQL 5.7 in a Docker Container

 * Upgrade
   Upgrade
    * Upgrade from earlier versions
    * Performing a Distribution upgrade in-place on a System with installed
      Percona packages
    * Upgrading using the Percona repositories
    * Upgrading using Standalone Packages
    * Percona Server In-Place Upgrading Guide: From 5.6 to 5.7

 * Post-Installation
   Post-Installation
    * Post-Installation steps for Percona Server for MySQL 5.7

 * Diagnostics Improvements
   Diagnostics Improvements
    * User Statistics
    * Slow Query Log
    * Extended Show Engine InnoDB Status
    * Show Storage Engines
    * Process List
    * Misc. INFORMATION_SCHEMA Tables
    * Thread Based Profiling
    * Metrics for scalability measurement
    * Response Time Distribution
    * InnoDB Page Fragmentation Counters
    * Using libcoredumper
    * Stacktrace

 * Flexibility Improvements
   Flexibility Improvements
    * Suppress Warning Messages
    * Improved MEMORY Storage Engine
    * Restricting the number of binlog files
    * Extended mysqldump
    * Extended SELECT INTO OUTFILE/DUMPFILE
    * Per-query variable statement
    * Extended mysqlbinlog
    * Slow Query Log Rotation and Expiration
    * CSV engine mode for standard-compliant quote and comma parsing
    * Support for PROXY protocol
    * Per-session server-id
    * Compressed columns with dictionaries
    * InnoDB Full-Text Search improvements
    * Binlogging and replication improvements

 * Management Improvements
   Management Improvements
    * Percona Toolkit UDFs
    * Kill Idle Transactions
    * Enforcing Storage Engine
    * Expanded Program Option Modifiers
    * XtraDB changed page tracking
    * Expanded Fast Index Creation
    * Backup Locks
    * Audit Log Plugin
    * Start transaction with consistent snapshot
    * Extended SHOW GRANTS
    * Utility user
    * PS-Admin script

 * Percona MyRocks
   Percona MyRocks
    * Percona MyRocks Introduction
    * Percona MyRocks Installation Guide
    * MyRocks Limitations
    * Differences between Percona MyRocks and Facebook MyRocks
    * MyRocks Server Variables
    * MyRocks status variables
    * Gap locks detection
    * Data Loading

 * Performance Improvements
   Performance Improvements
    * Multiple page asynchronous I/O requests
    * Query Cache Enhancements
    * Limiting the Estimation of Records in a Query
    * Improved NUMA support
    * Thread Pool
    * XtraDB Performance Improvements for I/O-Bound Highly-Concurrent Workloads
    * Prefix Index Queries Optimization

 * Reliability Improvements
   Reliability Improvements
    * Too Many Connections Warning
    * Handle Corrupted Tables

 * Scalability Improvements
   Scalability Improvements
    * Improved Buffer Pool Scalability
    * Improved InnoDB I/O Scalability

 * Security Improvements
   Security Improvements
    * Data at Rest Encryption
    * PAM Authentication Plugin
    * SSL Improvements
    * Data Masking

 * TokuDB
   TokuDB
    * 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
    * Percona TokuBackup
    * Frequently Asked Questions
    * Removing TokuDB storage engine

 * Release notes
   Release notes
    * Release notes index
    * Percona Server for MySQL 5.7.41-44 (2023-03-02)
    * Percona Server for MySQL 5.7.40-43 (2022-11-28)
    * Percona Server for MySQL 5.7.39-42 (2022-08-15)
    * Percona Server for MySQL 5.7.38-41 (2022-06-02)
    * Percona Server for MySQL 5.7.37-40 (2022-03-31)
    * Percona Server for MySQL 5.7.36-39 (2021-12-22)
    * Percona Server for MySQL 5.7.35-38 (2021-08-18)
    * Percona Server for MySQL 5.7.34-37 (2021-05-26)
    * Percona Server for MySQL 5.7.33-36 (2021-03-02)
    * Percona Server for MySQL 5.7.32-35 (2020-11-24)
    * Percona Server for MySQL 5.7.31-34 (2020-08-24)
    * Percona Server for MySQL 5.7.30-33 ((2020-05-20)
    * Percona Server for MySQL 5.7.29-32 (2020-02-05)
    * Percona Server for MySQL 5.7.28-31 (2019-11-13)
    * Percona Server for MySQL 5.7.27-30 (2019-08-22)
    * Percona Server for MySQL 5.7.26-29 (2019-05-27)
    * Percona Server for MySQL 5.7.25-28 (2019-02-18)
    * Percona Server for MySQL 5.7.24-27 (2018-12-18)
    * Percona Server 5.7.24-26 (2018-12-04)
    * Percona Server 5.7.23-25 (2018-11-21)
    * Percona Server 5.7.23-24 (2018-11-09)
    * Percona Server 5.7.23-23 (2018-09-12)
    * Percona Server 5.7.22-22 (2018-05-31)
    * Percona Server 5.7.21-21 (2018-04-24)
    * Percona Server 5.7.21-20 (2018-02-19)
    * Percona Server 5.7.20-19 (2018-01-03)
    * Percona Server 5.7.20-18 (2017-12-14)
    * Percona Server 5.7.19-17 (2017-08-31)
    * Percona Server for MySQL 5.7.18-16 (2017-07-28)
    * Percona Server for MySQL 5.7.18-15 (2017-05-26)
    * Percona Server for MySQL 5.7.18-14 (2017-05-12)
    * Percona Server for MySQL 5.7.17-13 (2017-04-05)
    * Percona Server for MySQL 5.7.17-12 (2017-03-24)
    * Percona Server for MySQL 5.7.17-11 (2017-02-03)
    * Percona Server for MySQL 5.7.16-10 (2016-11-28)
    * Percona Server for MySQL 5.7.15-9 (2016-10-21)
    * Percona Server for MySQL 5.7.14-8 (2016-09-21)
    * Percona Server for MySQL 5.7.14-7 (2016-08-23)
    * Percona Server for MySQL 5.7.13-6 (2016-07-16)
    * Percona Server for MySQL 5.7.12-5 (2016-06-06)
    * Percona Server for MySQL 5.7.11-4 (2016-03-15)
    * Percona Server for MySQL 5.7.10-3 (2016-02-23)
    * Percona Server for MySQL 5.7.10-2 (2016-02-05)
    * Percona Server for MySQL 5.7.10-1 (2015-12-14)

 * References
   References
    * List of upstream MySQL bugs fixed in Percona Server for MySQL 5.7
    * List of variables introduced in Percona Server 5.7
    * Development of Percona Server for MySQL
    * Trademark policy
    * Index of INFORMATION_SCHEMA Tables
    * Frequently Asked Questions
    * Copyright and licensing information
    * Glossary

   
   
   Download PDF

On this page
 * What’s in each RPM package?
 * Installing from the Percona YUM repository
    * Percona yum Testing repository

 * Installing Percona Server for MySQL using downloaded rpm packages
 * Running Percona Server for MySQL
 * Uninstalling Percona Server for MySQL


INSTALLING PERCONA SERVER FOR MYSQL 5.7 ON RED HAT ENTERPRISE LINUX AND CENTOS¶

Note

The following instructions install Percona Server for MySQL 5.7 using the Yum
repository. The instructions to install Percona Server for MySQL 8.0 using the
Yum repository are available at this location.

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.

Note

The RPM packages for Red Hat Enterprise Linux 7 (and compatible derivatives) do
not support TLSv1.3, because TLSv1.3 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 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 older 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.
   
   This package is not included in downloads for Red Hat Enterprise Linux 9 and
   derivatives.

 * The Percona-Server-test-57 package includes the test suite for Percona Server
   for MySQL.


INSTALLING FROM THE PERCONA YUM REPOSITORY¶

Note

RHEL 8 and other EL8 systems enable the MySQL module by default. This module
hides the Percona-provided packages and the module must be disabled to make
these packages visible. The following command disables the module:

$ sudo yum module disable mysql


 1. Install the Percona yum repository by running the following command as a
    root user or with sudo:
    
    $ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
    

 2. Enable the Percona Server 5.7 repository:
    
    
    
    $ sudo percona-release setup ps57
    
    
    The output should resemble the following:
    
    
    
    * Disabling all Percona Repositories
    * Enabling the Percona Server 5.7 repository
    * Enabling the Percona XtraBackup 2.4 repository
    

 3. Test the repository. Make sure packages are available from the repository by
    executing the yum list command. We filter the results by the version number:
    
    $ yum list | grep 5.7.38-41.1
    
    
    The output should be similar to the following:
    
    ...
    Percona-Server-57-debuginfo.x86_64                     5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-57-debugsource.x86_64                   5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-client-57-debuginfo.x86_64              5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-rocksdb-57.x86_64                       5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-rocksdb-57-debuginfo.x86_64             5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-server-57-debuginfo.x86_64              5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-shared-57-debuginfo.x86_64              5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-shared-compat-57.x86_64                 5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-test-57-debuginfo.x86_64                5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-tokudb-57.x86_64                        5.7.38-41.1.el8                                           percona-release-x86_64
    Percona-Server-tokudb-57-debuginfo.x86_64              5.7.38-41.1.el8                                           percona-release-x86_64
    ...
    

 4. Install the packages. You can install Percona Server for MySQL by running
    the following command:
    
    $ 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 must install the Percona repository first if this operation has not been
done already. See installing from the Percona YUM repository


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 bundle which contains all the
    packages. The following example downloads the 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
    

 2. You should then unpack the bundle to get the packages:
    
    $ tar xvf Percona-Server-5.7.31-34-r2e68637-el7-x86_64-bundle.tar
    
    
    You should see the following packages:
    
    
    
    $ ls *.rpm
    
    
    The output should be similar to the following:
    
    
    
    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
    

 3. Run the following command to Percona Server for MySQL 5.7:
    
    $ 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 command only installs the 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 Percona MyRocks Installation.

To install all the packages (for debugging, testing, etc.) run the following
command:

$ rpm -ivh *.rpm


Note

When installing packages manually, you must resolve all dependencies and install
any missing packages.

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


The output should resemble the following:

datadir=/var/lib/mysql





RUNNING PERCONA SERVER FOR MYSQL¶

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.

 1. Start the service. Percona Server for MySQL does not start automatically on
    RHEL and CentOS after the installation. Start the server by running the
    following command:
    
    $ service mysql start
    

 2. Confirm that service is running by running the following command:
    
    $ service mysql status
    

 3. Stop the service by running the following command:
    
    $ service mysql stop
    

 4. Restart the service by running the following command:
    
    $ service mysql restart
    

Note

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 you must remove all the
installed packages and data files.

 1. Stop the Percona Server for MySQL service
    
    $ service mysql stop
    

 2. Remove the packages
    
    $ yum remove Percona-Server*
    

 3. Remove the data and configuration files:

Warning

This command removes all the packages and deletes all the data files (databases,
tables, logs, etc.). Take a backup 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: 2023-02-28
Back to top
Percona LLC, © 2023
Made with Material for MkDocs


COOKIE CONSENT

We use cookies to recognize your repeated visits and preferences, as well as to
measure the effectiveness of our documentation and whether users find what
they're searching for. With your consent, you're helping us to make our
documentation better.

 * Google Analytics
 * GitHub

Accept Manage settings