sysown/proxysql v2.5.2

on GitHub

v2.5.2 Release notes

Release date: 2023-05-12

This is a minor release for ProxySQL 2.x series containing some enhancements and several bug fixes.

Compared to version 2.5.1, ProxySQL 2.5.2 introduces the following changes:

New features and enhancements

Major

• Update OpenSSL to 3.1.0 #4165
• Allow to specify weighted for flagOUTs for mysql_query_rules #4202
  • in mysql_query_rules.attributes it is now possible to define a new object in the form "flagOUTs":[array_of_ids_andweights] , where each element of the array has the form {"id":XXX,"weight":YYY}. Example: {"flagOUTs":[{"id":1,"weight":1000},{"id":2,"weight":3000}]}
• Monitor ‘read-only’ actions rework #4127
  • Monitor actions no longer modify ‘mysql_servers’ config table
  • Monitor ‘read-only’ actions are now much more lighter operations
• Optimizations for the generation and querying of ‘stats_mysql_query_digest’ table , drastically reducing locking time #4096
• Add new variable 'mysql-query_rules_fast_routing_algorithm' #4182
  • if value is 1 : default behavior , each worker thread hold a copy of ‘mysql_query_rules_fast_routing’ map
  • if value is 2 : new algorithm, where all worker threads use a global map for ‘mysql_query_rules_fast_routing’ . This algorithm is useful for a very large number of rules (several hundreds of thousands) because it reduces memory usage, and it also allow to drastically reduces the load of a new routing table
• Added capability to generate core dumps on demand (Google coredumper) #4188
  • Added commands PROXYSQL COREDUMP and PROXYSQL COMPRESSEDCOREDUMP
  • This feature is available only on x86-64 Linux system
• Deprecate ‘admin-checksum_*’ variables in favor of ‘admin.cluster_*_diffs_before_sync’ #4161
  • Module checksums are now always computed.
  • Disable module fetching for Cluster should be done via ‘admin.cluster_*_diffs_before_sync=0’.

Minor

• Add support for last_insert_id for Query Log #4203
• Minor optimizations for ‘replication-lag’ actions #4144
• Introduced capability for debug builds of logging debug entries to a new schema debugdb_disk (on disk) and table debug_log #4149
• Added several new tracked variables #4191
  • MariaDB max_statement_time
  • sql_generate_invisible_primary_key
  • sql_require_primary_key
• Added Fedora 38 build targets #4199

Bug Fixes

Major

• Fixed issue with monitor checks failing when using SSL connections #4196
• Fixed DNS module trying to resolve hostnames when Unix sockets are used #4210
• Fixed RESTAPI configuration not persisting when loaded from config file #4177
• Fixed final data left unread (COM_QUIT) in Unix sockets #4186
• Fixed servers moved from writer_hostgroups into reader hostgroups, when using multiple hostgroups and writer_is_also_reader=1 #4127
• Fixed replication_hostgroups being deleted due to other monitoring actions #4127

Minor

• Fixed potential floating point exception in monitor_read_only #12d91871
• Fixed refetching of modules after re-enabling ‘admin.cluster_*_diffs_before_sync’ variables.
• Removed redundant prometheus ‘client_connections’ metrics #4180
• Fixed invalid memory accesses to ‘checksums_values’ during shutdown #4189
• Improved user feedback for ‘DNS Cache’ warning message #4209

Hashes

SHA256s:

ab4ac2b7a60c4cfdc732b159c07720fbe3cf70946529f61bd243e08a8edd86dc  proxysql-2.5.2-1-almalinux8-clang.x86_64.rpm
58c0dea1a2db6e04a33db0191a2e4b746ab9010944ada7a924903c4b43a40b74  proxysql-2.5.2-1-almalinux8.aarch64.rpm
ddcfb52a41835b4910208de15309210ced803c05a8d33e0fe96724eb387da3fd  proxysql-2.5.2-1-almalinux8.x86_64.rpm
ec57e04a6798f4c814a5719b13af699a87d949af4a0706a2b520f75c07b39768  proxysql-2.5.2-1-almalinux9-clang.x86_64.rpm
919dbfaea0cc85cd1c801b1c68db3888ce7fd13f6ddf5836fee72988fd79073d  proxysql-2.5.2-1-almalinux9.aarch64.rpm
676a1ce4cd3cfe8d16132ad0762715af1226db12bc7bc62e791fc0aca05d752a  proxysql-2.5.2-1-almalinux9.x86_64.rpm
b10e1dc8208e071c88ce4738a9a9dcda6a7629046e10d4ee1e59d9959e2b53ea  proxysql-2.5.2-1-centos6.x86_64.rpm
61e2bca52eace0e46b2ef5205d809f81a002898d5cc9ea914f9566f56953ddd3  proxysql-2.5.2-1-centos7.aarch64.rpm
6f7ecc879864708ac7b62cf05edf31f6785697e1501e389e9a8f0d8fc92da489  proxysql-2.5.2-1-centos7.x86_64.rpm
acaa0ac58c8ca7772af9dac748e1cdd4270635d7b0aec9af4c2a7d4d5691d404  proxysql-2.5.2-1-centos8-clang.x86_64.rpm
4f9965a90ae1e729c6b6136f9e44433db9cf175590b8ae32896a8e77b6b6b5cb  proxysql-2.5.2-1-centos8.aarch64.rpm
907aad401c885231105efae75cafc427b2ac48d38f0df024f0ea7855dee8a93a  proxysql-2.5.2-1-centos8.x86_64.rpm
34beca252e3af67c4b5cebd08a5469ecadb7485a2e03875955a848c773fbe9c7  proxysql-2.5.2-1-dbg-almalinux8.x86_64.rpm
08ad2a95bc56d909de395258df092d549e0d10d2be25cbcbbf417085130ede3a  proxysql-2.5.2-1-dbg-almalinux9.x86_64.rpm
a4c3d2e597ea03e965c4987a619bdb313bdfc11ef005c5f01839d9a1b8c8dc76  proxysql-2.5.2-1-dbg-centos6.x86_64.rpm
239352bb6426d9be8a47f08330419f8ee3b605e962958e9d1df593022bfdd969  proxysql-2.5.2-1-dbg-centos7.x86_64.rpm
31de5a33797b49f5c74ccbe2d29606e4a535528fe1d3827f19f1a6f89d21f8c6  proxysql-2.5.2-1-dbg-centos8.x86_64.rpm
29598465ddb8e74a793d3cc2472e054a0ac35d508ff708cb5896f09ee5b11ace  proxysql-2.5.2-1-dbg-fedora27.x86_64.rpm
2931f5df64c5d5bc2a6abd1a635e0080bd74885832d264ec7ed81bed11267ec5  proxysql-2.5.2-1-dbg-fedora28.x86_64.rpm
5c3554238f9b189f1fe53e4f18599527928a722e22c77e74691cfd7c07860c4d  proxysql-2.5.2-1-dbg-fedora33.x86_64.rpm
0aa37be328d2d042d5f061bbb9a0f9458a4d1356d7dabd060de411b8d7aa32cf  proxysql-2.5.2-1-dbg-fedora34.x86_64.rpm
d782ad8c2fe5fb77a842f65d1b42239b3dccb115754775df121281fd6d0df351  proxysql-2.5.2-1-dbg-fedora36.x86_64.rpm
e53155d552bdbbf2e8f9d95927af33f9858b24be7d3992021ae6bcb6a3ef1dd2  proxysql-2.5.2-1-dbg-fedora37.x86_64.rpm
bdc49c4ab0d48e211434b3fb8e8f87e13d1e20da81611b43e7ffda820eefd23d  proxysql-2.5.2-1-dbg-fedora38.x86_64.rpm
23e159471e73a9e06c96d8280d5a33324616fec5136ec44e72e04cfea5ff5fb4  proxysql-2.5.2-1-dbg-opensuse15.x86_64.rpm
4da9a9cb33553f5643186bfc61a9750251f0b3bbe510ef03659aee69f03ae533  proxysql-2.5.2-1-fedora27.x86_64.rpm
6dc0dc560c0dee0765e3dfbd8951290206a4b233fdfce78eec8e90756e2a26e5  proxysql-2.5.2-1-fedora28.x86_64.rpm
b2aaa7ad06332caebb1089a12247738903e0e9885bf976fd1ee5e4b1ed216061  proxysql-2.5.2-1-fedora33.aarch64.rpm
3965abcfe6d6d19cff8d203e27cf7e2d43b30ce29362a7b2538e5d392c4307cf  proxysql-2.5.2-1-fedora33.x86_64.rpm
d2e32dfe7a96e8ec7b503a5910adc35dee8b9ac826180a23e40a5de60edfe6e2  proxysql-2.5.2-1-fedora34-clang.x86_64.rpm
c858da98cf64909dcde9bae5cd5b3d73ce2c273829acfc63fcf1cf007eb8ddaf  proxysql-2.5.2-1-fedora34.aarch64.rpm
2aa6a2b752b01d6aa6cf3678f080f701bd636d3f8c19350891fbbf8e85905ee6  proxysql-2.5.2-1-fedora34.x86_64.rpm
6b1bc318c0839d690afe3f696d544c26972dbf8e476a3855cc8d7cb8417ad899  proxysql-2.5.2-1-fedora36-clang.x86_64.rpm
24ae39deae81c7cdefebd14129fce6205456a792a91010a412c6bba5108a8dd7  proxysql-2.5.2-1-fedora36.aarch64.rpm
efde44f5ff0b798263c6c4fd51a2410ca79b048e3119559118e8e05456d54fa5  proxysql-2.5.2-1-fedora36.x86_64.rpm
860496c8e2faa331874ed4bf1d27e79594df1d79be55a80baeb2b333557f8c9b  proxysql-2.5.2-1-fedora37-clang.x86_64.rpm
d9a9365b4081f6782216bd453e0f1df2dd321c6518cec0dad970ffcaf6471dff  proxysql-2.5.2-1-fedora37.aarch64.rpm
e62d8acd20ac8bc1b58aa4b006c2313eb2ebc751df37525ee4a4b556b089798a  proxysql-2.5.2-1-fedora37.x86_64.rpm
77c9b09aff95fd73ee895cfdb57f6ee2c41e142a501a764b632f173f3cd4df37  proxysql-2.5.2-1-fedora38-clang.x86_64.rpm
c4a149a1687ff4b000a26b49394ec24a35796c2ef9854deef07d21cc157073dc  proxysql-2.5.2-1-fedora38.aarch64.rpm
53c5f334a7f15dd0148c6e413553715ac4d6fb96cb8b6407c2fc82fd747e4dc0  proxysql-2.5.2-1-fedora38.x86_64.rpm
0a267fa8da4188275b4c778af71449854740fc10ec703201183296a62e33548f  proxysql-2.5.2-1-opensuse15-clang.x86_64.rpm
3713b620e75e048256edbcb57b35640028bf1fae79865131bc963227186b872c  proxysql-2.5.2-1-opensuse15.aarch64.rpm
14b6e8ecbe37a1729f8d38c4f15522b2899abf0aeafac0d5befa5be82f6da44a  proxysql-2.5.2-1-opensuse15.x86_64.rpm
8183fd3407d1889fc74e6aa406e7d3eb68e7fe5dbab7438b80a4b8ecc9d66652  proxysql-2.5.2.id-hash
4084de40e7d8f7b9b03762320115b7a70e2687c3b46fb72af0258bfb1b02c3c9  proxysql_2.5.2-dbg-debian10_amd64.deb
4d43af4f181fe206a6aeda3440de8b24da3d7c8434a9def77258d99c2dd435af  proxysql_2.5.2-dbg-debian11_amd64.deb
c61e48fd0cecab2eae16ccdf2401e34bd52350c625ceeb36a991244568c73874  proxysql_2.5.2-dbg-debian8_amd64.deb
ef372d02605f094d97cdda4d0a1e97b59fb2780edb2cf78eb6205f494f42ad3c  proxysql_2.5.2-dbg-debian9_amd64.deb
59427aa282a8248d1b10e1af2b4c1ec93e72f4e430667dd6481b4f9c990dda27  proxysql_2.5.2-dbg-ubuntu14_amd64.deb
95c8d98bafa6295a5c9ffce0699153bd55be7f346f1ab6a919e7e9a0d60eb31a  proxysql_2.5.2-dbg-ubuntu16_amd64.deb
1ebabcc87a71a2945d343c741cd44227e9518859ef91d56f7f230d49d7accf18  proxysql_2.5.2-dbg-ubuntu18_amd64.deb
5099f96970bd732fdfc032e975696141e7399f5e9dc178f584effc8ea73433e0  proxysql_2.5.2-dbg-ubuntu20_amd64.deb
884b69bc17b35346cc44e00c54c4990b1dff7a063f20c0a14f4d4a0d4b883a6a  proxysql_2.5.2-dbg-ubuntu22_amd64.deb
3bafff598c3d6aae83a3ac2f38f7de4438e70067645d65d978ce003be99cb8ee  proxysql_2.5.2-debian10_amd64.deb
cb492c01e0dbda8b72b596ef5afc10910d24d878ff89ecd7dea0531d3514bc6a  proxysql_2.5.2-debian10_arm64.deb
9a46a340188c324ee237c37b305234ce53bf8dbd2cb78da7b1a21e6f15b255d7  proxysql_2.5.2-debian11-clang_amd64.deb
73567bd8977f3f9cd0fd5091977ee76c5d6ebb1fc0b40ea42297ca84dadc37d9  proxysql_2.5.2-debian11_amd64.deb
6efcdea6ced39be6d8705eff53d029a52ab9329f7e136614e79e8d64addfdeec  proxysql_2.5.2-debian11_arm64.deb
c4b2c522ee3b2a6d98a43764dee065bc81e03ade6d3e17fb29a4b3dc9d3ffca2  proxysql_2.5.2-debian8_amd64.deb
cf0338744984401dfa12c664d283ec283228b01118a88079358a46314d5ef3e4  proxysql_2.5.2-debian9_amd64.deb
b74c800138f551815c2f0aaa4c08392f449ff042da88827e17abf5d7784c1e93  proxysql_2.5.2-debian9_arm64.deb
301710d237c4b7a7f8d4785ad8f17f68bec1df5b16fa102f924f54c3eefc1c14  proxysql_2.5.2-ubuntu14_amd64.deb
8a595ae092810db621b77ca7a3a631e4d9e01d387375fb6cb6e8bfe05d37c3d8  proxysql_2.5.2-ubuntu16_amd64.deb
8762ceba1f0383d413e0878c8e4947d24d8c8339e993320ec75ac37935354691  proxysql_2.5.2-ubuntu16_arm64.deb
a6dab9a2912f4d37a89849c9fbf00396b345b937fbf099f1db1c0e4372daf3ad  proxysql_2.5.2-ubuntu18_amd64.deb
04835b424876660b3b81e3d5d59ee9f399555936a184768658b609565940cf07  proxysql_2.5.2-ubuntu18_arm64.deb
72166e7899e5c3ce38396fa3e0e8c8969c55bf262d7429bf6e79c4029679f025  proxysql_2.5.2-ubuntu20-clang_amd64.deb
b0c412638f9c15c6696309871c6f7a985aed3e0cf153a18bac9b9833abe17136  proxysql_2.5.2-ubuntu20_amd64.deb
0a44f872d339b5a53207b04300d473e951380c0cfdedf30582158dd011a01032  proxysql_2.5.2-ubuntu20_arm64.deb
14c8eda4b85150515ba8a55779cc7452072c80f5c668a41ca86ea0da5987e25d  proxysql_2.5.2-ubuntu22-clang_amd64.deb
57dcf039dfe1676b1ea83a9765e759e3248ffb129cae5bff74e3b6f9b03df310  proxysql_2.5.2-ubuntu22_amd64.deb
d412913229d42edb1bb757bd32f22602594f217af1917b1af5662a362a5b6ab3  proxysql_2.5.2-ubuntu22_arm64.deb