ProxySQL 1.4.7 and proxysql-admin (2018-04-16)¶
- Installation: https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql-v1.html#installing-proxysql-v1
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.7 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.
proxysql_statustool to dump ProxySQL configuration and statistics.
proxysql_galera_checkerscript didn’t check if another instance of itself is already running. While running more then one copy of
proxysql_galera_checkerin the same runtime environment at the same time is still not supported, the introduced fix is able to prevent duplicate script execution in most cases.
PSQLADM-40: ProxySQL scheduler generated a lot of
proxysql_node_monitorprocesses in case of wrong ProxySQL credentials in
PSQLADM-41: Timeout error handling was improved with clear messages.
PSQLADM-42: An inconsistency of the date format in ProxySQL and scripts was fixed.
proxysql_galera_checkerdidn’t take into account the possibility of special characters presence in mysql-monitor_password.
proxysql_galera_checkergenerated unclear errors in the
/etc/proxysql.logfile if wrong credentials where passed.
proxysql_node_monitorscript incorrectly split the hostname and the port number in URLs containing hyphen character.
ProxySQL is available under Open Source license GPLv3.