We are proud to announce the latest release of ProxySQL version 2.2.0
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.2.0 is a minor release comprising of backward compatible changes, enhancements and bug fixes. Going forward ProxySQL will be using the common versioning standard “Major.Minor.Patch” and so this is essentially the first minor release of the 2.1 branch and inclues many fixes and features that were added to the 2.0 branches after 2.1 was released.
Important fixes that improve stability and enhance the performance of ProxySQL, detailed release notes for ProxySQL 2.2.0 are available on the release page, a few noteworthy highlights can be found here:
- In ProxySQL 2.1 an important change related to Prepared Statements was introduced for ProxySQL to process routing for Prepared Statements not only during PREPARE, but also during EXECUTE.
- In ProxySQL 1.x – 2.0.x Prepared Statements that had already been PREPARED were always going to be routed to the target hostgroup that was determined during PREPARE, so they had to be “refreshed” after. For example, after updating ProxySQL Query Rules, they required to be re-PREPAREd in order to be routed to the new target hostgroup.
- In ProxySQL v2.2 this has been further enhanced to support the processing of Query Annotations present in the statement also during EXECUTE.
- Many many more fixes and updates!
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