ProxySQL 1.4.16 and Updated proxysql-admin Tool Now Available

ProxySQL 1.4.16, 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. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.

The ProxySQL 1.4.16 source and binary packages available from the Percona download page for ProxySQL include ProxySQL Admin – a tool developed by Percona to configure Percona XtraDB Cluster nodes into ProxySQL. Docker images for release 1.4.16 are available as well. You can download the original ProxySQL from GitHub. GitHub hosts the documentation in the wiki format.

Bugs Fixed

• PSQLADM-219: The scheduler was handling the pxc_maint_mode variable incorrectly. As a result, open connections were closed immediately. This bug has been fixed and now the scheduler only sets the node status to OFFLINE_SOFT. This prevents opening new connections and lets the already established connections finish their work. It is up to the user to decide when it is safe to start the node maintenance.

ProxySQL is available under Open Source license GPLv3.

by Borys Belinsky via Percona Database Performance Blog