Releasing ProxySQL 1.4.9

  • Date:
  • Tags: proxy mysql release proxysql ha gpl 1.4.8 1.4.9
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