ProxySQL is proud to announce the release of the latest stable version of ProxySQL 2.0.13 on the 15th of July 2020

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

New Features

Although only bug fixes are supposed to go into ProxySQL 2.0, we had to introduce a few minor new features:

  • A client can force ProxySQL to run a query in a new connection using a query annotation using create_new_connection=1 in a comment. For example SELECT /* create_new_connection=1 */ 1 . See #2874
  • Added support for SAVEPOINT , RELEASE SAVEPOINT and ROLLBACK TO SAVEPOINT #948
  • ProxySQL Version checker checks for new version every 24 hours

Bug fixes

  • ProxySQL could crash if stats_mysql_processlist was queried while a client connection wasn’t fully initialized
  • Improved the handling of charsets and session variables, and removed several deprecated global variables
  • The value of stats_mysql_connection_pool.Queries_GTID_sync was always 0 from 2.0.10 till 2.0.12
  • Fixed several bugs in the parsing of SET statements
  • Command COM_FIELD_LIST could generate an error if the table is a keyword
  • Internal mysql_data_stream was not correctly reset in case of change user
  • Variable mysql-default_track_gtids was being ignored
  • a large query cache was causing an interger overflow when computing the size of the query cache itself
  • PXC nodes were not being re-enabled after pxc_maint_mode was set to DISABLED
  • Fixed invalid path for logrotate, in case you have installed 2.0.12 you will need to run “rm -fr /etc/logrotate.d/proxysql” to delete the invalid configuration before installing 2.0.13

NOTE: Detailed release notes and package along with their checksums for ProxySQL 2.0.13 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 evaluate the overall state your database infrastructure and help to build a robust and reliable MySQL HA architecture. We also offer consulting, long term support and training for ProxySQL.