Skip to content
Percona Software for MySQL Documentation

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

Get help from Percona

Percona’s build of ProxySQL 2.5.5-1.2 and ProxySQL admin tools (2024-02-26)

Download Percona’s build of ProxySQL
Install
View the GitHub repository for Percona’s build of ProxySQL

ProxySQL is a high-performance proxy for MySQL and MySQL-compatible database servers such as Percona Server for MySQL and MariaDB. It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for the database administrator to solve complex replication topology issues. Percona distributes ProxySQL as a repackaged version of the upstream release, without making any code modifications.

You can download the original ProxySQL from GitHub. The ProxySQL documentation provides information on installing and running ProxySQL.

The ProxySQL Admin (proxysql-admin) tool simplifies the configuration of Percona XtraDB Cluster nodes with ProxySQL. ProxySQL Admin 2 supports Percona XtraDB Cluster without custom scripts.

The pxc_scheduler_handler tool can automatically perform a failover due to node failures, service degradation, or maintenance. This tool has features and capabilities that differ from the ProxySQL admin tool, so you should not use options from one tool in the other, as that may cause unintended results.

Release highlights

This release updates the Percona scripts with bug fixes and adds the LockRefreshTime variable.

Bug Fixes

PSQLADM-501 : Fixed the issue with --syncusers which created additional users in the mysql_users table when more than one admin user were defined in admin-admin_credentials. Thanks to Roberto Garcia de bem for the contribution.

PSQLADM-502 : Support for MariaDB 10.11 in using ProxySQL admin (customer request). Thanks to PN Morin for the contribution.

PSQLADM-506 : Updated systemd file from proxysql sources. Systemd file that is shipped by Percona was different from what was shipped by ProxySQL.

pxc_scheudler_handler FR#71 : Adds the following:

  • Support to delay the epoch flush

  • A new variable LockRefreshTime, which is time in seconds after which the scheduler will refresh the epoch inside the ProxySQL server table. This parameter was introduced to reduce the frequency of updates in ProxySQL.

Last update: 2025-06-02