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 thesinglewriter
query rules for the new users. -
PSQLADM-51: Update
mysql-server_version
variable. The–update-mysql-version
command has been added to set themysql-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 withproxysql-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.