ProxySQL 2.3.2 and proxysql-admin (2021-11-03)¶
ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for DBAs as a means of solving complex replication topology issues.
The ProxySQL 2.3.2 source and binary packages available from the Percona download page for ProxySQL 2 includes proxysql-admin - a tool developed by Percona to configure Percona XtraDB Clusters nodes into ProxySQL. Docker images are also available.
The ProxySQL 2.3.2 and proxysql-admin release includes all the features and bug fixes available in the following versions. Select the version number to see the individual release notes:
The following list are some of the bug fixes provided by ProxySQL from versions 2.2.1 to 2.3.2:
Supports the use of grave accent or backtick (`) symbol for SET statements. #3479
Re-implements how comments are handled in
PROXYSQL TLS RELOADcommand which allows reloading TLS files at runtime. This command lets ProxySQL change its certifications and key files used for client connections. #3552
Improves for group replication monitoring and replication lag actions. #3533
Fixes issues found with the
client error limitimplementation. #3627
psqladm-320: Performs a
SAVEoperation for the users table only if the users table has changed.
psqladm-339: Provides a method when a cluster read-only state has changed to update proxysql-admin without requiring a cluster restart.
psqladm-327: Adds the
--serveroption to skip the check for cluster membership. This option is specified with either the
--syncuserscommand or the
--sync-multi-cluster-userscommand and allows standalone nodes to be synced.
WARNING: An upgrade from ProxySQL v1.x to ProxySQL v2.x requires the user to manually remove the ProxySQL v1.x packages. After that operation, the user can install ProxySQL v2.x.
ProxySQL is available under Open Source license GPLv3.