Releasing ProxySQL 1.4.9
Proudly announcing the release of the latest stable release of ProxySQL 1.4.9 as of the 31st of May 2018.
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL. Freely usable and accessible according to GPL license and can be downloaded here or using the APT / YUM repos listed in the project's Github WIKI.
ProxySQL 1.4.9 includes a number of important improvements and bug fixes including:
- Added an additional client capability toggle variable for client_multi_statements to configure how proxysql connects to backends (i.e. multi-statement or not)
- Added feature to load mysql_group_replication_hostgroups from config file
- Improved query cache performance for large resultsets by combining multiple packets in larger buffer
- Fixed enforce_autocommit_on_reads when changing autocommit from 1 to 0
- Added parsing of /! SET xxx / commands
- Fixed a bug which would cause ProxySQL to crash during a backend shutdown when a connection is null
- Added a workaround for a MariaDB client bug reporting an incorrect autocommit value CON-332
- Added a fix to allow multiple SET variables in a single command
- Added all session status values to display in processlist
- Minor modifications of Makefile to compile on Darwin
- Fixed applied to prevent duplicate execution of proxysql_galera_checker.sh
- Added default_schema to checksum criteria for ProxySQL Cluster in order to trigger syncronization when updated
- Fixed the no such table: INFORMATION_SCHEMA.TABLES error when dumping tables from ProxySQL Admin
- Improved handling of SET statements from mysqldump
- Fixed a segmentation fault which occured when using musl rather than glibc
- Fixed a bug for the lookup in mysql_query_rules_fast_routing
- Updated INSTALL.md to include updated package names for newer RHEL based distributions
The related issues/commits can be found in the v1.4.9 release.
A special thanks to all the people that reports bugs: this makes each version of ProxySQL better than the previous one.
Please report any bugs or feature requests on github issue tracker
Authored by: Nick Vyzas