Skip to content
Percona Software for MySQL Documentation

Install ProxySQL 2.x.x and the admin utilities

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.

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

If you used APT to install Percona software, run the following command as sudo or as root:

$ sudo apt install proxysql2
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 used YUM to install Percona software, run the following command:

$ sudo yum install proxysql2
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 ProxySQL2 in Docker, download the latest image at percona/proxysql2.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert

Last update: 2024-11-20