ProxySQL 2.4.7 and ProxySQL admin tools (2023-02-14)¶

Release date	February 14, 2023
Install instructions	ProxySQL and proxysql-admin
Download this version	ProxySQL 2.x

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 as a solution for complex replication topology issues.

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 1.x.x requires custom Bash scripts to track the status of a Percona XtraDB Cluster. ProxySQL Admin 2.x.x supports Percona XtraDB Cluster without custom scripts.

The ProxySQL 2.x.x and pxc_scheduler_handler tool can automatically perform a failover due to node failures, service degradation, or maintenance. The pxc_scheduler_handler tool has different features and capabilities than ProxySQL admin. Do not use the options from one tool in the other tool. Mixing the options may cause unintended results.

For training, contact Percona Training - Start learning now.

Release highlights¶

This release includes all features and bug fixes available in ProxySQL 2.4.7. The bug fix introduced by ProxySQL and included in this release is:

A connection may hang under some rare edge case conditions determined by TCP packet size, if SSL is used for frontend or fast_forward connection.

For more information on these items and other improvements and bug fixes, see the ProxySQL 2.4.7 release notes.

Improvement¶

psqladm-458: pxc_scheduler_handler adds a server pingTimeout option to avoid the tool hanging when the node is not reachable.

Bug fixes¶

psqladm-439: The lock file time calculation was corrected.

Useful links¶

Last update: 2025-01-17