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 –syncusers or –sync-multi-cluster-users, the –add-query-rule option can now be specified to add the singlewriter query rules for the new users.

• PSQLADM-51: Update mysql-server_version variable. The –update-mysql-version command has been added to set the mysql-server_version global 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-servers option did not work on enable. When running with proxysql-cluster, the galera hostgroups information was not replicated, which could result in failing to run –enable on a different ProxySQL node. The –force option was added for –enable to 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 –force option was specified, then a warning was issued in case any existing rules were found; otherwise an error was issued. The –disable-updates option was added to ensure that ProxySQL cluster updates did not interfere with the current command.

• PSQLADM-200: users were not created for –syncusers with Percona XtraDB Cluster (PXC) operator. When using the Percona XtraDB Cluster (PXC) operator for Kubernetes, the –syncusers command was run but the mysql_users table was not updated. The fix for PSQLADM-199 that suggested to use –disable-updates also 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.

---

Last update: 2023-03-24