ProxySQL 2.0.5 and proxysql-admin (2019-11-23)¶
- Installation: https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql-v2.html#installing-proxysql-v2
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 release source and binary packages available from the Percona download page for ProxySQL 2 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. For more information on the issues fixed, features, or enhancements, see the ProxySQL 2.0.5 release notes
This version includes ProxySQL release. For more information on the issues fixed, features, or enhancements, see the ProxySQL release release notes
The proxysql-admin tool has been enhanced to support the following new options and commands:
||Creates query rules for synced MySQL users. This option is only applicable for the singlewrite mode and works together with the
||Skips existing configuration checks in
PSQLADM-49: Create rules for
–syncusers. When running with
–add-query-ruleoption can now be specified to add the
singlewriterquery rules for the new users.
–update-mysql-versioncommand has been added to set the
mysql-server_versionglobal variable in ProxySQL. This will take the version from a node in the cluster and set it in ProxySQL.
–remove-all-serversoption did not work on enable. When running with
proxysql-cluster, the galera hostgroups information was not replicated, which could result in failing to run
–enableon a different ProxySQL node. The –force option was added for
–enableto be able to ignore any errors and always configure the cluster.
PSQLADM-199: query-rules removed during proxysql-cluster creation with Percona XtraDB Cluster (PXC) operator. When using the Percona XtraDB Cluster (PXC) operator for Kubernetes and creating a proxysql-cluster, the query rules could be removed. The code was modified to merge the query rules (rather than deleting and recreating). If the
–forceoption was specified, then a warning was issued in case any existing rules were found; otherwise an error was issued. The
–disable-updatesoption was added to ensure that ProxySQL cluster updates did not interfere with the current command.
PSQLADM-200: users were not created for
–syncuserswith Percona XtraDB Cluster (PXC) operator. When using the Percona XtraDB Cluster (PXC) operator for Kubernetes, the
–syncuserscommand was run but the mysql_users table was not updated. The fix for PSQLADM-199 that suggested to use
–disable-updatesalso applies here.
ProxySQL is available under Open Source license GPLv3.