Skip to content

For help, click the link below to get free database assistance or contact our experts for personalized support.

Install Percona build of ProxySQL and the admin tools

Select the same package installer used to install Percona XtraDB Cluster or other Percona software to ensure compatibility.

Verify that you’re installing the correct ProxySQL version for your environment, such as proxysql2 or proxysql3.

If you installed Percona software using APT, run the following command as sudo or as root. Make sure to use the correct package name for the version you installed, such as proxysql2 or proxysql3.

$ sudo apt install proxysql2

or

$ sudo apt install proxysql3
Expected output
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  debconf-utils logrotate
The following NEW packages will be installed:
  debconf-utils logrotate proxysql2
0 upgraded, 3 newly installed, 0 to remove and 3 not upgraded.
Need to get 7259 kB of archives.
...

If you installed Percona software using YUM, run the following command. Make sure to use the correct package name for the version you installed, such as proxysql2 or proxysql3.

$ sudo yum install proxysql2

or

$ sudo yum install proxysql3
Expected output
Last metadata expiration check: 0:01:47 ago on Wed Oct  5 14:42:00 2022.
Dependencies resolved.
=========================================================================================================================
Package                  Architecture          Version                        Repository                           Size
=========================================================================================================================
Installing:
proxysql2                x86_64                2.4.4-1.1.el8                  tools-release-x86_64                 21 M
Installing dependencies:
logrotate                x86_64                3.14.0-4.el8                   baseos                               85 k

Transaction Summary
=========================================================================================================================
Install  2 Packages

Total download size: 21 M
Installed size: 88 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): logrotate-3.14.0-4.el8.x86_64.rpm                                                 371 kB/s |  85 kB     00:00
(2/2): proxysql2-2.4.4-1.1.el8.x86_64.rpm                                                3.6 MB/s |  21 MB     00:05
-------------------------------------------------------------------------------------------------------------------------
Total                                                                                    3.3 MB/s |  21 MB     00:06
...

Verify the pxc_scheduler_handler installation

If you have installed ProxySQL 2.3.2-2.1 or later, verify the pxc_scheduler_handler installation with the following command:

$ percona-scheduler-admin --debug

Running this command without the pxc_scheduler_handler configuration file generates an error.

Error message
ERROR : The --config-file option is required but is missing from the command.

Run Docker

To run the Percona build of ProxySQL in Docker, do the following:

MySQL 8.4 and Percona Server for MySQL 8.4 considerations

In an MySQL 8.4 or Percona Server for MySQL 8.4 environment, you may have the following issues:

  • ProxySQL contains counters that have not been updated to use the new terminology. Unexpected results may occur
  • The binlog reader errors out during initialization due to the use of the old terminology, such as SHOW MASTER STATUS command.

Last update: 2025-06-02