We are proud to announce the latest release of ProxySQL version 2.5.2

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.5.2 is a patch release comprising of several enhancements and bug fixes. This release is the second patch release of the 2.5 branch and includes minor and major fixes and improvements that were introduced in the 2.x branches after 2.5.1 was released.

Be sure to try out the ProxySQL 2.5.2 release and let us know your experience!

Release Highlights

Detailed release notes for ProxySQL 2.5.2 are available on the release page, a few new changes worth of mentioning are:

  • Update OpenSSL to 3.1.0
  • Allow to specify weighted for `flagOUTs` for `mysql_query_rules`
  • Monitor ‘read-only’ actions rework
  • Optimizations for the generation and querying of ‘stats_mysql_query_digest’ table , drastically reducing locking time
  • Add new variable ‘mysql-query_rules_fast_routing_algorithm’
  • Added capability to generate core dumps on demand (Google coredumper)
  • Deprecate ‘admin-checksum_*’ variables in favor of ‘admin.cluster_*_diffs_before_sync’
  • Add support for `last_insert_id` for `Query Log`
  • Minor optimizations for ‘replication-lag’ actions
  • Introduced capability for debug builds of logging debug entries to a new schema debugdb_disk (on disk) and table debug_log
  • Added several new tracked variables
  • Added Fedora 38 build targets
  • Fixed issue with monitor checks failing when using SSL connections
  • Fixed DNS module trying to resolve hostnames when Unix sockets are used
  • Fixed RESTAPI configuration not persisting when loaded from config file
  • Fixed final data left unread (COM_QUIT) in Unix sockets
  • Fixed servers moved from writer hostgroups into reader hostgroups, when using multiple hostgroups and `writer_is_also_reader=1`
  • Fixed replication_hostgroups being deleted due to other monitoring actions
  • Fixed potential floating point exception in monitor_read_only
  • Fixed refetching of modules after re-enabling ‘admin.cluster_*_diffs_before_sync’ variables
  • Removed redundant prometheus ‘client_connections’ metrics
  • Fixed invalid memory accesses to ‘checksums_values’ during shutdown
  • Improved user feedback for ‘DNS Cache’ warning message

Upgrade Notes

Upgrading from v2.4.x or previous versions via repository:

  • Make sure to change the repository URL from proxysql-2.4.x (or previous) to proxysql-2.5.x

Please follow the repository configuration instructions at https://repo.proxysql.com/

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 of 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 & MySQL Environments