ProxySQL 2.3.2 and proxysql-admin (2021-11-03)¶

Installation: https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql-v2.html#installing-proxysql-v2

ProxySQL 2.3.2, released by ProxySQL, is now available for download in the Percona repository along with an updated version of Percona’s proxysql-admin tool.

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.

You can download the original ProxySQL from GitHub. ProxySQL provides the ProxySQL documentation.

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:

Release Highlights¶

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 USE statements. #3610
Implements the PROXYSQL TLS RELOAD command 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 limit implementation. #3627

Improvements¶

psqladm-320: Performs a SAVE operation 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 --server option to skip the check for cluster membership. This option is specified with either the --syncusers command or the --sync-multi-cluster-users command 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.

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-04-18