ProxySQL 2.5.1 and ProxySQL admin tools (2023-04-17)¶

Release date	April 17, 2023
Install instructions	ProxySQL and proxysql-admin
Download this version	ProxySQL 2 using the instructions

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.

Release highlights¶

Compared to the previous ProxySQL 2.4.8 release, this release includes all improvements and bug fixes available in ProxySQL 2.5.0 and ProxySQL 2.5.1.

The improvements and bug fixes introduced by ProxySQL 2.5.0 and included in this release are:

Native Group Replication monitoring is supported for MySQL-8.
Added a new mysql_hostgroup_attributes feature with support for the following attributes:
- mysql_hostgroup_attributes.multiplex
- mysql_hostgroup_attributes.free_connections_pct
- mysql_hostgroup_attributes.throttle_connections_per_sec
Fixed memory leaks related to load_mysql_servers_to_runtime.

The improvements and bug fixes introduced by ProxySQL 2.5.1 and included in this release are:

mysql_hostgroup_attributes.init_connect option is supported.
Multiple binlog clients support consuming events via the same username.
Fix for when connections were killed due to invalid max_transaction_time tracking.

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

ProxySQL Admin and pxc_scheduler_handler have not changed since the previous release.

Useful links¶

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-08-23