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 2.0.5, released by ProxySQL, is now available for download in the Percona repository along with an updated version of Percona’s proxysql-admin tool.
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:
| Option | Description |
|---|---|
–add-query-rule |
Creates query rules for synced MySQL users. This option is only applicable for the singlewrite mode and works together with the –syncusers and –sync-multi-cluster-users options. |
–force |
Skips existing configuration checks in mysql_servers, mysql_users and mysql_galera_hostgroups tables. This option will only work together with the –enable option: $ proxysql-admin --enable --force |
–update-mysql-version (command) |
Updates the mysql-server_version variable in ProxySQL with the version from a node in Percona XtraDB Cluster. |
Improvements¶
-
PSQLADM-49: Create rules for
–syncusers. When running with–syncusersor–sync-multi-cluster-users, the–add-query-ruleoption can now be specified to add thesinglewriterquery rules for the new users. -
PSQLADM-51: Update
mysql-server_versionvariable. The–update-mysql-versioncommand has been added to set themysql-server_versionglobal variable in ProxySQL. This will take the version from a node in the cluster and set it in ProxySQL.
Bugs fixed¶
-
PSQLADM-190: The
–remove-all-serversoption did not work on enable. When running withproxysql-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.
Contact us
For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or consulting services , contact Percona Sales.
