ProxySQL 1.4.16 and Updated proxysql-admin Tool Now Available
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.
- PSQLADM-219: The scheduler was handling the
pxc_maint_modevariable 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