ProxySQL is a high-performance proxy, currently for MySQL and its forks (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.12 source and binary packages available at https://percona.com/downloads/proxysql include ProxySQL Admin – a tool, developed by Percona to configure Percona XtraDB Cluster nodes into ProxySQL. Docker images for release 1.4.12 are available as well: https://hub.docker.com/r/percona/proxysql/. You can download the original ProxySQL from https://github.com/sysown/proxysql/releases. GitHub hosts the documentation in the wiki format.
- #68: Scripts are now compatible with Percona XtraDB Cluster (PXC) hosts using IPv6
- #107: In
include-slaves, a slave would always be moved into the write hostgroup even if the whole cluster went down. A new option
--use-slave-as-writerspecifies whether or not the slave is added to the write hostgroup.
- #110: In some cases, pattern cluster hostname did not work with
proxysql-admintestsuite bug fixes.
proxysql_galera_checkerassumed that parameters were given in the long format
- #114: In some cases, ProxySQL could not be started
proxysql_node_monitorcould fail with more than one command in the scheduler
- #116: In some cases, the scheduler was reloading servers on every run
- #117: The
--syncusersoption did not work when enabling cluster
- #125: The function
check_is_galera_checker_runningwas not preventing multiple instances of the script from running
ProxySQL is available under Open Source license GPLv3.