Skip to content

Release Notes for Version 1

ProxySQL 1.4.16 and proxysql-admin (2020-02-11)

ProxySQL release, 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 1.4.16 source and binary packages are 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

Bugs Fixed

  • PSQLADM-219: The ProxySQL scheduler was handling the pxc_maint_mode variable incorrectly. As a result, open connections were closed immediately. This bug has been fixed and now the ProxySQL scheduler only sets the node status to OFFLINE_SOFT. This prevents opening new connections and lets the already established connections finish their work. It is up to the user to decide when it is safe to start the node maintenance.

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.12 and proxysql-admin (2018-11-13)

ProxySQL release, 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 1.4.12 source and binary packages are 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

Improvements

  • PSQLADM-68: Scripts are now compatible with Percona XtraDB Cluster (PXC) hosts using IPv6

  • PSQLADM-107: In include-slaves, a slave would always be moved into the write hostgroup even if the whole cluster went down. A new option –use-slave-as-writer specifies whether or not the slave is added to the write hostgroup.

Bugs Fixed

  • PSQLADM-110: In some cases, pattern cluster hostname did not work with proxysql-admin.

  • PSQLADM-104: proxysql-admin testsuite bug fixes.

  • PSQLADM-113: proxysql_galera_checker assumed that parameters were given in the long format.

  • PSQLADM-114: In some cases, ProxySQL could not be started

  • PSQLADM-115: proxysql_node_monitor could fail with more than one command in the ProxySQL scheduler.

  • PSQLADM-116: In some cases, the ProxySQL scheduler was reloading servers on every run

  • PSQLADM-117: The –syncusers option did not work when enabling cluster

  • PSQLADM-125: The check-is-galera-checker-running function was not preventing multiple instances of the script from running.

Other bugs fixed: PSQLADM-112, PSQLADM-120

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.8 and proxysql-admin (2018-05-22)

  • Installation

https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql-v1.html#installing-proxysql-v1

ProxySQL release, 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 1.4.8 source and binary packages are 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

Usability improvement

  • PSQLADM-84: Now proxysql_status tool dumps host_priority and /etc/proxysql-admin.cnf. Also output format was changed.

Other improvements and bug fixes

  • PSQLADM-66: The –syncusers option now makes ProxySQL Admin to update the user’s password in ProxySQL database if there is any password difference between ProxySQL user and MySQL user.

  • PSQLADM-45: it was unclear from the help screen, that –config-file option requires an argument.

  • PSQLADM-48: ${PROXYSQL_DATADIR}/${CLUSTER_NAME}_mode file was not created at ProxySQL Admin upgrade (1.4.5 or before to 1.4.6 onwards).

  • PSQLADM-52: The proxysql_galera_checker script was not checking empty query rules.

  • PSQLADM-54: proxysql_node_monitor did not change OFFLINE_HARD status properly for the coming back online nodes.

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.7 and proxysql-admin (2018-04-16)

ProxySQL release, 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 1.4.7 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

Usability improvements

  • Added proxysql_status tool to dump ProxySQL configuration and statistics.

Bug fixes

  • PSQLADM-2: proxysql_galera_checker script didn’t check if another instance of itself is already running. While running more then one copy of proxysql_galera_checker in the same runtime environment at the same time is still not supported, the introduced fix is able to prevent duplicate script execution in most cases.

  • PSQLADM-40: ProxySQL scheduler generated a lot of proxysql_galera_checker and proxysql_node_monitor processes in case of wrong ProxySQL credentials in /etc/proxysql-admin.cnf file.

  • PSQLADM-41: Timeout error handling was improved with clear messages.

  • PSQLADM-42: An inconsistency of the date format in ProxySQL and scripts was fixed.

  • PSQLADM-43: proxysql_galera_checker didn’t take into account the possibility of special characters presence in mysql-monitor_password.

  • PSQLADM-44: proxysql_galera_checker generated unclear errors in the /etc/proxysql.log file if wrong credentials where passed.

  • PSQLADM-46: proxysql_node_monitor script incorrectly split the hostname and the port number in URLs containing hyphen character.

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.6 and proxysql-admin (2018-03-12)

ProxySQL release, 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 1.4.6 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

Usability improvements

  • PSQLADM-32: Now, proxysql-admin script can configure multiple clusters in ProxySQL, when there are unique cluster names specified by the wsrepcluster_name option, and the /etc/proxysql-admin.cnf configuration contains different _ProxySQL READ/WRITE hostgroup and different application user for each cluster. Currently multiple clusters support is not compatible with host priority feature, which works only with a single cluster.

  • PSQLADM-81: The new version substantially increases the number of test cases in the ProxySQL Admin test-suite.

Bug fixes

  • PSQLADM-35: proxysql_galera_checker monitoring script was unable to discover new writer nodes.

  • PSQLADM-36: upgrade to ProxySQL 1.4.6 from the previous version was broken.

  • PSQLADM-79: Fixed by properly quoting the MONITOR_USERNAME environment variable in the admin script query.

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.5 and proxysql-admin (2018-02-15)

ProxySQL 1.4.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 1.4.5 source and binary packages are 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

  • PSQLADM-6: If the cluster node goes offline, the proxysqlnode_monitor script now sets the node status as OFFLINE_HARD, and does not remove it from the _ProxySQL database. Also, logging is consistent regardless of the cluster node online status.

  • PSQLADM-30: Validation was added for the host priority file.

  • PSQLADM-33: Added –proxysql-datadir option to run the proxysql-admin script with a custom ProxySQL data directory.

  • Also, BATS test suite was added for the proxysql-admin testing.

Bug fixes

  • PSQLADM-5: Percona XtraDB Cluster (PXC) mode specified with proxysql-admin with use of –mode parameter was not persistent.

  • PSQLADM-8: ProxySQL High CPU load took place when mysqld was hanging.

ProxySQL is available under Open Source license GPLv3.

ProxySQL 1.4.4 and proxysql-admin (2018-01-18)

ProxySQL 1.4.4, 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 1.4.4 source and binary packages are 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 are available as well. You can download the original ProxySQL from GitHub. ProxySQL offers the ProxySQL documentation.

This release fixes the following bugs in ProxySQL Admin

  • PXC-892: proxysql-admin was unable to recognize IP address of localhost.

  • PXC-893: proxysql-admin couldn’t interpret passwords with special characters correctly, such as ‘$’

  • PSQLADM-3: proxysql_node_monitor script had writer/reader hostgroup conflict issue.

  • PQA-155: Runtime table was not updated in case of any changes in Percona XtraDB Cluster membership.

  • BLD-853: ProxySQL logrotate script did not work properly, producing empty /etc/proxysql.log after logrotate.

ProxySQL is available under Open Source license GPLv3.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert

Last update: 2024-04-18