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

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.4.5 is a patch release comprising of several enhancements and bug fixes. This release is the forth patch release of the 2.4 branch and includes minor and major fixes and improvements that were introduced in the 2.x branches after 2.4.0 was released.

 

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

Release Highlights


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

  • Update to OpenSSL 3.0.7
  • Several improvements for RESTAPI
  • Added new feature ProxySQL local DNS Cache
  • Make newer RPM distros use systemd
  • Build support for MacOS
  • Added support for @@local syntax and optimizer_use_condition_selectivity session variable
  • Added support for mysql-ldap_user_variable for prepared statements
  • Add new field stmt_id to eventslog for COM_STMT_PREPARE|COM_STMT_EXECUTE events
  • Add new variable mysql-parse_failure_logs_digest
  • Honor mysql-verbose_query_error for MySQL query warnings
  • Avoid printing version number for version check on request failure
  • Fix malformed packet when connecting to MariaDB with fast_forward
  • Fix servers metrics not being properly updated after hostgroup change
  • Fix corrupted MySQL_Client_Connect_ERR message in audit log
  • Fix invalid digest value in ‘eventslog’ for COM_STMT_EXECUTE
  • Fix invalid removal of EOF packet for binary resultsets holding ERR packets
  • Fix mysql_stmt_store_result potential stalls when failing due to ERR
  • Fix heap overflow error during authentication when no password is provided
  • Fix mysql_ldap_mapping not being load to runtime at startup
  • Fix support for stats_mysql_users for LDAP plugin
  • Fix connection stall when handling big split compressed packets
  • Fix invalid sequence_id on EOF to OK packet conversion for Query Cache
  • Fix warning and status position in EOF to OK packet conversion for Query Cache
  • Fix crash on RESTAPI script invocation
  • Fix java.lang.ArrayIndexOutOfBoundsException when connecting with MySQL JDBC driver
  • Fix invalid memory accesses to digests due to concurrent purge
  • Fix several memory leaks during handshake when using MySQL_LDAP_Authentication
  • Fix heap overflow error during authentication when no password is provided
  • Fix errors when re-enabling monitor due to expired connections being used

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