v1.4.9
Release date: July 16, 2018
Improvements
-
BLD-1068 Append -percona to proxysql version
Added "-percona" to the proxysql version to indicate Percona built version. -
PSQLADM-31 Handle multiple proxysql instances in proxysql-admin
Added the ability to use multiple proxysql instances on the same server. -
PSQLADM-62 silent mode
Added the --without-check-monitor-user option which configures proxysql without prompting/creating the monitor user (allows for automated deployment scenarios). -
PSQLADM-63 host_priority on multiple clusters
Added the ability to set host_priority on multiple clusters using the same proxysql instance.
Bug fixes
-
BLD-1077 Can't set limits for proxysql on systemd systems
Open file limits can now be set on systemd systems. -
PSQLADM-56 "--syncuser" option was using a hardcoded hostgroup
proxysql-admin now uses the WRITE_HOSTGROUP_ID variable rather than a hardcoded value. -
PSQLADM-57 proxysql-admin requires to run as root
Removed requirement for tool to run as root, instead check for needed permissions to access configuration files/directories. -
PSQLADM-58 Monitor user password rotation leads to cluster being read only
Added code to check if the proxysql password is the same as the PXC monitor password. -
PSQLADM-67 With singlewrite mode, Galera checker is not changing writer hostgroup id when nodes become ONLINE from OFFLINE_SOFT
Fixed a bug where changing the monitor user password may lead to making the entire cluster read-only. -
PSQLADM-69 Reading multiple cluster names from the scheduler if write hostgroup matches.
Fixed a bug with incorrect pattern matching, causing multiple clusters to be returned depending on the hostgroup id. -
PSQLADM-70 proxysql-admin --syncusers do not support multiple clusters in the same proxysql instance.
Do not allow syncusers to delete users if they are from a different hostgroup.