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.
This release includes ProxySQL 2.0.5 which fixes many bugs and introduces a number of features and enhancements. The
proxysql-admin tool has been enhanced to support the following new options:
--add-query-ruleoption creates query rules for synced MySQL users. This option is only applicable for the singlewrite mode and works together with the
--forceoption skips existing configuration checks in
mysql_galera_hostgroupstables. This option will only work together with the –enable option:
proxysql-admin --enable --force.
--update-mysql-versionoption updates the
mysql-server_versionvariable in ProxySQL with the version from a node in Percona XtraDB Cluster.
The ProxySQL 2.0.5 source and binary packages available from the Percona download page for ProxySQL include
proxysql-admin – a tool developed by Percona to configure Percona XtraDB Cluster nodes into ProxySQL. Docker images for release 2.0.5 are available as well. You can download the original ProxySQL from GitHub. GitHub hosts the documentation in the wiki format.
ProxySQL 2.0.5 Improvements
- PSQLADM-49: Create rules for –syncusers. When running with
--add-query-ruleoption can now be specified to add the singlewriter query rules for the new users.
- PSQLADM-51: Update mysql-server_version variable. The
--update-mysql-versioncommand 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.
- PSQLADM-190: The
--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
--forceoption 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 PXC operator. When using the 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 PXC operator. When using the 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.