ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository

ProxySQL 1.4.9

ProxySQL 1.4.9ProxySQL 1.4.9, 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 its forks (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.9 source and binary packages available at https://percona.com/downloads/proxysql include ProxySQL Admin – a tool, developed by Percona to configure Percona XtraDB Cluster nodes into ProxySQL. Docker images for release 1.4.9 are available as well: https://hub.docker.com/r/percona/proxysql/. You can download the original ProxySQL from https://github.com/sysown/proxysql/releases.

This release contains the following bug fixes and enhancements in ProxySQL Admin:

  • PSQLADM-31proxysql-admin is now able to handle multiple ProxySQL instances using separate configuration files passed with the enable command. This new multi-instance functionality was the reason to fix detection of a hostgroup, which was previously hardcoded in the script (bug fixed PSQLADM-56), and to fix features broken on multiple clusters: host priority (bug fixed PSQLADM-63), user accounts sync (bug fixed PSQLADM-70), and, finally, reading right cluster name from scheduler by the Galera checker script, broken in case of a matching write hostgroup (bug fixed PSQLADM-69).
  • BLD-1068: A “-percona” suffix added to the proxysql version now indicates the Percona built version.
  • PSQLADM-62: The new  --without-check-monitor-user option allows using ProxySQL Admin tool  without human interaction, to provide an automatic deployment.
  • PSQLADM-57: proxysql-admin script now checks if the current user has sufficient privileges on the ProxySQL data directory instead of unconditionally asking to be executed by root user.
  • PSQLADM-67: When the cluster comes back online after the maintenance activity (in which all nodes are OFFLINE_SOFT and are moved to a reader hostgroup), Galera checker will now promote one of the read nodes to write node in singlewrite mode setup.
  • PSQLADM-58: Now the proxysql_galera_checker script terminates if the monitor credentials do not match ones of Percona XtraDB Cluster, to avoid situations when monitor user password rotation puts the cluster to a read-only state until the next ProxySQL restart.

ProxySQL is available under the OpenSource license GPLv3.

The post ProxySQL 1.4.9 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

关注dbDao.com的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569