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.9 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.9 are available as well: https://hub.docker.com/r/percona/proxysql/. You can download the original ProxySQL from https://github.com/sysown/proxysql/releases.
This release contains the following bug fixes and enhancements in ProxySQL Admin:
proxysql-adminis now able to handle multiple ProxySQL instances using separate configuration files passed with the
enablecommand. This new multi-instance functionality was the reason to fix detection of a hostgroup, which was previously hardcoded in the script (bug fixed PSQLADM-56), and to fix features broken on multiple clusters: host priority (bug fixed PSQLADM-63), user accounts sync (bug fixed PSQLADM-70), and, finally, reading right cluster name from scheduler by the Galera checker script, broken in case of a matching write hostgroup (bug fixed PSQLADM-69).
- BLD-1068: A “-percona” suffix added to the proxysql version now indicates the Percona built version.
- PSQLADM-62: The new
--without-check-monitor-useroption allows using ProxySQL Admin tool without human interaction, to provide an automatic deployment.
proxysql-adminscript now checks if the current user has sufficient privileges on the ProxySQL data directory instead of unconditionally asking to be executed by root user.
- PSQLADM-67: When the cluster comes back online after the maintenance activity (in which all nodes are OFFLINE_SOFT and are moved to a reader hostgroup), Galera checker will now promote one of the read nodes to write node in singlewrite mode setup.
- PSQLADM-58: Now the
proxysql_galera_checkerscript terminates if the monitor credentials do not match ones of Percona XtraDB Cluster, to avoid situations when monitor user password rotation puts the cluster to a read-only state until the next ProxySQL restart.
ProxySQL is available under the OpenSource license GPLv3.
The post ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.