Release date: August 31, 2022

ProxySQL package update

Improvements

PSQLADM-402: The proxysql-status command did not work as intended. The script had a requirement to pass the .cnf file but this requirement is no longer needed.

PSQLADM-419: The CVE-2021-38561 was found in a library used by pxc_scheduler_handler. The appropriate patch was applied.

Release date: August 10, 2022

ProxySQL package update

Improvements

When pxc_scheduler_handler launches, a lock file is created to prevent the running of multiple instances of pxc_scheduler_handler. Previously, the lock file remained in the file system and prevented the handler script from running.

Now, on startup, pxc_scheduler_handler does the following:

• reads the Process identifier (PID),
• reads the timestamp from the lock file,
• checks if PID is running on startup.

If PID is still running, the newly launched pxc_scheduler_handler exits. If the PID is not running, pxc_scheduler_handler checks whether the timeout specified in lockFileTimeout exceeds. If the timeout exceeds, pxc_scheduler_handler removes the lock file and performs the operations.

Release date: June 15, 2022

ProxySQL package update

New Features

• PSQLADM-330: Adds support for the Percona Scheduler Admin tool.

Improvements

The ProxySQL Admin tool adds support for Percona XtraDB Cluster 5.5 and MariaDB Server 10.6.

• PSQLADM-385: Support MySQL / PXC 5.5 with proxysql-admin Thanks to michaelcoburn for the contribution.

• PR #215: Support MariaDB Server 10.6 Thanks to Snake-Whisper for the contribution.

Release date: November 3, 2021

ProxySQL package update

Improvements

• PSQLADM-320 : Performs a SAVE operation for the users table only if the users table has changed

• PSQLADM-327 : Adds the --server option to skip the check for cluster membership This option is specified with either the --syncusers command or the --sync-multi-cluster-users command and allows specific standalone nodes to be synced.

• PSQLADM-339 : Provides a method when a cluster read-only state has changed to update proxysql-admin without requiring a cluster restart The --force option was added to skip the cluster membership check.

• PR-202 : add support for MariaDB 10.1 Thanks to shovelwagon for this.

• PR-203 : add support for MariaDB 10.0, 10.1, and 10.5 Thanks to Esysteme for this.

Release date: August 10, 2021

ProxySQL package update

Update of the ProxySQL binaries. No changes were made to proxysql-admin-tools.

Please see https://github.com/sysown/proxysql/releases/tag/v2.2.0

Release date: July 9, 2021

ProxySQL package update

Enhancements

• PSQLADM-314 : Added a tool to help setting up the test workdir Added the tests/setup_workdir.sh script to help setup the workdir corectly.

Release date: April 19, 2021

ProxySQL package update

Update of the ProxySQL binaries. No changes were made to proxysql-admin-tools.

Please see https://github.com/sysown/proxysql/releases/tag/v2.0.18

Release date: April 7, 2020

ProxySQL package update

Bug Fixes

• PSQLADM-282 : Fix proxysql-admin zombie process issue In some circumstances, the use of bash process substitution was causing zombie processes to appear. The --use-stdin-for-credentials flag can be set to use stdin instead of process substitution.

• PSQLADM-285 : Testsuite not working with PXC 8.0.21 The testsuite has been updated to work with PXC 8.0.21.

Release date: November 17, 2020

ProxySQL package update

Improvements

• PSQLADM-92 : Allow the use of an encrypted password in proxysql-admin Login credentials used by proxysql-admin can now be encrypted in a separate file, rather than being stored in cleartext in proxysql-admin.cnf. Please see the information about login-file in the README.

• PR-184 : Proxysql status command can now use .my.cnf configuration file proxysql-status will now use the default MySQL client credentials in ~/.my.cnf if no other credentials are specified.

Release date: September 25, 2020

ProxySQL package update

Bug Fixes

• PSQLADM-256 : Wrong password with % character Using a password with an embedded '%' character would fail to login (even though it is a valid MySQL password string).