ProxySQL 2.0.7

Proudly announcing the release of the latest stable version of ProxySQL 2.0.7 on 2nd of October 2019.

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here, from the ProxySQL Repository and freely usable and accessible according to the GNU GPL v3.0 license. Docker images are also available on DockerHub if preferred.

ProxySQL 2.0.7 includes the following key features:

  • Support for AWS Aurora auto-discovery
  • Tracking and handling of:
    • SET SESSION READ ONLY and SET SESSION READ WRITE
    • SET SESSION TRANSACTION ISOLATION LEVEL ...
    • All the following session variables: character_set_results , session_track_gtids, sql_auto_is_null, sql_select_limit, sql_safe_updates, collation_connection, net_write_timeout, max_join_size, tx_isolation
  • A new variable mysql-query_digests_no_digits : if set to true, digits are replaced by ? in query digests (for example on schema and tables names with digits) in order to reduce the query digest overhead when using digits for sharded schema names
  • Packages for Debian 10 Buster

As well as the following important fixes:

  • The incorrect handling of SET autocommit , regression bug introduced in version 2.0.5 : upgrade from 2.0.5 and 2.0.6 is highly recommended
  • High CPU utilization for client connections using SSL , regression bug introduced in 2.0.4
  • The destination hostgroup was incorrectly set when unable to parse SET statements , bug introduced in 2.0.6

NOTE: The full release notes for ProxySQL 2.0.7 listing the complete set of improvements and fixes are available on the release page

A special thanks to all the people that report bugs: this makes each version of ProxySQL better than the previous. Please report any bugs or feature requests on the project’s Github issue tracker.

If you have any questions please do not hesitate to contact us. Our performance and scalability experts are readily available to analyze your infrastructure and help to build a robust and reliable MySQL HA architecture. We also offer consulting, long term support and training for ProxySQL.

Authored by: Nick Vyzas