v2.6.0 Release notes

Release date: 2024-03-04

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

Compared to version 2.5.5 ProxySQL 2.6.0 introduces the following changes:

New features and enhancements

Major

• Added support for caching_sha2_password:
  • Deprecated variable admin-hash_passwords
  • Added new variable mysql-default_authentication_plugin
  • Extra details in several sections of the official documentation
• Added new feature mysql_servers_ssl_params #4458
  • Allows overriding the global SSL parameters in a per-host basis.
  • Introduces new configuration table mysql_servers_ssl_params.
• Completely new Web Interface via Web Interface Plugin:
  • The plugin targets 2.6.0 as it's initial target release.
  • Upcoming news and blogpost on ProxySQL website.
• Improved LDAP support, via LDAP Plugin:
  • Updated plugin version targets 2.6.0 as it's initial target release.
  • Upcoming news and blogpost on ProxySQL website.
• Upgrade multiple dependencies:
  • libmariadbclient from 3.1.9 to 3.3.8 #4407
  • OpenSSL from 3.1.4 to 3.2.1 #4360, #4371, #4447, #4448
  • SQLite3 from 3.42 to 3.43.2 #4363
  • curl from 7.87.0 to 8.4.0 #4359
  • libhttpserver from 0.9.75 to 0.9.77 #4362
• Added builds for CentOS 9 stream builds #4394
• Added support for warnings handling #4365
  • Allows for warning propagation from backend to client.
  • Adds support for SHOW WARNINGS command.
  • Introduces two new variables for control mysql-handle_warnings and mysql-query_cache_handle_warnings.
• Added support for hostgroup_attributes for AWS aurora autodiscovery #4279, via #4295
  • Allows to configure auto-discovered servers defaults via servers_defaults.
• Added support for Group Replication Autodiscovery for MySQL 8 #4208
  • Allows to configure auto-discovered servers defaults via servers_defaults.
• Added support for Bootstrap Mode for MySQL 8 Group Replication #4232
• Added new synchronization algorithm for mysql_servers for Cluster #4169

Minor

• Update several defaults #4339
  • monitor_history: from 600000 to 7200000 (from 10 minutes to 2 hours)
  • use_tcp_keepalive: from false to true
  • tcp_keepalive_time: from 0 to 120
  • set_parser_algorithm: from 1 to 2
• Added new column hostgroup_settings to mysql_hostgroup_attributes table #4374
• Added new prepared statement memory usage monitoring via: #4372
  • prepare_statement_metadata_memory: Bytes of metadata cache stored for prepared statements.
  • prepare_statement_backend_memory: Bytes used for prepared statements in backend connections.
• Remove trailing spaces and semicolons in SET (parsing resiliency) #4385
• Improve detection of viable_candidate server for MySQL 8 Group Replication #4208
• Added new configuration variable mysql-evaluate_replication_lag_on_servers_load #4450
• Allow values above 65536 for mysql-servers_capabilities #4424
• Improve shutdown consistency via fast shutdown for TERM signal handler #4425
• Add new PROXYSQL INTERNAL SESSION field MultiplexDisabled_ext #4430
• Improve handling of several STATUS commands from MySQL 8 CLI #4396
• Added new status variable mysql_listener_paused indicating if PROXYSQL PAUSE was executed #4428
• Added missing/incorrect LICENSE info in packages #4444

Deprecations

• Deprecation of multiple distributions:
  • Debian 8
  • Debian 9
  • Fedora 27
  • Fedora 28
  • Fedora 33
  • Fedora 34
  • Fedora 36
  • Fedora 37
  • Ubuntu 14
  • CentOS 6
• Deprecation of unused variable mysql-default_tx_isolation #4429

Bug Fixes

Major

• Fixed assert due to duplicated entries in monitor.mysql_server_galera_log #4351
• Fixed servers_defaults column not being synced by Cluster #4374
• Fixed Admin deadlock on concurrent connections #4416
• Fixed crash when frequently querying stats_mysql_query_digest* tables #4414
• Fixed AWS Aurora replicas not being shunned due to replication lag #4279
• Fixed AWS Aurora new writer not honoring new_reader_weight #4279
• Fixed invalid removal of servers when present in multiple AWS Aurora clusters #4279
• Fixed IP not being resolved after connection error in Cluster #4452

Minor

• Fixed interactions between checksum_% and %_diffs_before_sync variables #4381
  • Variables checksum_% were deprecated in 2.5.2 #4161
  • Unintentional checksum resets for Cluster also fixed for cluster_ldap_variables #4381
• Fixed memory leaks when querying stats_mysql_prepared_statements_info #4455
• Fixed heap use after free when setting auditlog_filename #4455
• Fixed memory leaks in ProxySQL HTTP Server #4455
• Fixed invalid handling of aliases when exceeding 250 characters #4403
• Fixed inclusion of servers in SHUNNED|SHUNNED_REPLICATION_LAG for checksums computation #4279

Hashes

SHA256s:

547a1e065a5d0d98d2b680662f70b50388dd0981212947157ad62bb570549df6  proxysql-2.6.0-1-almalinux8-clang.x86_64.rpm
f3e74318238aa99f98d20260e7c11451d5de8e9e88e119eb91b902a3e72254df  proxysql-2.6.0-1-almalinux8.aarch64.rpm
3e64e21efa1e360acc51448565809aaf85f25bc0d6255a076503b8ae9d54d595  proxysql-2.6.0-1-almalinux8.x86_64.rpm
f4b63dce969ea677820da13843badd8e230431598b8e964fe67fc11eecbd2c68  proxysql-2.6.0-1-almalinux9-clang.x86_64.rpm
a774f70fcbb6102fa5907e595b3974e89d307f3877b15e9b1002ce4ffe7c0c06  proxysql-2.6.0-1-almalinux9.aarch64.rpm
c62ef0a37bc989f05e8b396e523440fe02f9b56d31541be935f5f1f2e5a2e3f9  proxysql-2.6.0-1-almalinux9.x86_64.rpm
d04400d0a4dc45c3a5eeda04b2a6989a7808d52c4d2f9222a032bb854aa9d90e  proxysql-2.6.0-1-centos7.aarch64.rpm
85d59cd7b23b94d144f0937c8c0878106c50f21418d5594a4b9f70becced4cc0  proxysql-2.6.0-1-centos7.x86_64.rpm
b5874ed805b76394119676935aec75c9a97226f1b908e787961e2cfce159f97c  proxysql-2.6.0-1-centos8-clang.x86_64.rpm
baa7766c28ba21ec1aa9c21ff56dfa44fb5c3e0ca195b452c272a6a98fdb391b  proxysql-2.6.0-1-centos8.aarch64.rpm
fac52885f9d66c2b14b8f52e0669e54154c47042310675653d19d6334d9011bb  proxysql-2.6.0-1-centos8.x86_64.rpm
e738f1b1fb23c401fbd33ccbb49fc1e99f451af4f313592286c4905368d898fc  proxysql-2.6.0-1-centos9-clang.x86_64.rpm
d01bad4b9f718020e3e734353a18ca84f78e430afc7aabe8ffefc88d789ef348  proxysql-2.6.0-1-centos9.aarch64.rpm
1bd408460b66b8f571d9ead3a94d2fd08249d20af45e7406d3397cbef0cabe26  proxysql-2.6.0-1-centos9.x86_64.rpm
be27e6e1da16b8b326a46de71e6ceaa488241c98c88b573eeef0b14f6ed8a60d  proxysql-2.6.0-1-dbg-almalinux8.x86_64.rpm
36a30fe0d92b404edebba70a05653607331b17d8c400e316022c5372dc1f3036  proxysql-2.6.0-1-dbg-almalinux9.x86_64.rpm
09f840198fdff54a074d5f0ca5f5b9c7e338f349624248b66492996de41a61ca  proxysql-2.6.0-1-dbg-centos7.x86_64.rpm
060f71dc381a029f8c863d38653d35819c0611ecdc222b4b453c2822d43e1ded  proxysql-2.6.0-1-dbg-centos8.x86_64.rpm
07dec0cf374eda89ced753cf93ac0c049d5fd6201bd6108b8bd57b59cf0253f8  proxysql-2.6.0-1-dbg-centos9.x86_64.rpm
ebfa7f0e7b9de795457a6478fcab5231d5e6f5e6d4e39f7706fc69c81bf841a9  proxysql-2.6.0-1-dbg-fedora38.x86_64.rpm
f4ee14765f5a6c5622715c8dcd5b5d62de933b38e0d3688b71261045dcaf62ae  proxysql-2.6.0-1-dbg-fedora39.x86_64.rpm
4be7935db39d142e8fb4c256f722243fb3fa068f67cadf7c8d0fb471a61f900b  proxysql-2.6.0-1-dbg-opensuse15.x86_64.rpm
d47eaee38fd6d4fd3f58e5f92821edc6ac1acfeb77f7b23e9d3a9763f60296a3  proxysql-2.6.0-1-fedora38-clang.x86_64.rpm
aea497adddeb4d62e5b2e70a107cf074a21b4b7d29456d11b8e73579fdcb9a60  proxysql-2.6.0-1-fedora38.aarch64.rpm
66cace9a2fae18d58900761afc3d9652b07ed04bdd17fd30d1386c805b798200  proxysql-2.6.0-1-fedora38.x86_64.rpm
bcb887b19c24f3fa5f9993515771d12631cc7fe6fa7719026230cb79a3d5e8c1  proxysql-2.6.0-1-fedora39-clang.x86_64.rpm
8b6de09462faa3ea93d347427752db647150a16c4bc947af17783423ecac54e4  proxysql-2.6.0-1-fedora39.aarch64.rpm
bcb6e96d72fca9d5e21e9f30e06a230e8df0f10373091b64478cf0872111725d  proxysql-2.6.0-1-fedora39.x86_64.rpm
78bcdb3c5cf25382628bbea18fe15655bcca0551eb2028fdb4e6163cf0c023da  proxysql-2.6.0-1-opensuse15-clang.x86_64.rpm
44eebd314c0dad2d04ecf43ead3a1223eedbe20f8e3a97dc6198aee3acbd2c1e  proxysql-2.6.0-1-opensuse15.aarch64.rpm
6ba5d375a3539b6419b7eb5c07b669978af5964c2187352ccc44b6ae7f67115c  proxysql-2.6.0-1-opensuse15.x86_64.rpm
765c6f13c30b15ce993f1d05d17dabc1a1780e9b2b6cd6525e92cad28861deae  proxysql-2.6.0.id-hash
c3404d1a7380379af4029f684fd339afba061afa5e8c3cf760a0193e3ef4beab  proxysql_2.6.0-dbg-debian10_amd64.deb
e7bc52eaa7a7fa641e1061267686990de153258a76cb8d450469f32e085e484a  proxysql_2.6.0-dbg-debian11_amd64.deb
628476436fbd9738290b63b4c582ae7914eaff9a3271ff300b89a6bf5d837f8d  proxysql_2.6.0-dbg-debian12_amd64.deb
cd0e0f4f21faad20b212e0075f7987e49eb9b673052f7b1d1d621dcbf4a563e2  proxysql_2.6.0-dbg-ubuntu16_amd64.deb
5816191f8e1a41331529094002de9c440e4f3ce690489347f69831ef273ea0ea  proxysql_2.6.0-dbg-ubuntu18_amd64.deb
538a41fefc82fb591c6c1fb58bece883857ef5fea08e902e49c5a91d06ef097d  proxysql_2.6.0-dbg-ubuntu20_amd64.deb
e495674db3bef34c67c82cd1e48fd376e6d01258afb0cadfdccbf0adfe2fd892  proxysql_2.6.0-dbg-ubuntu22_amd64.deb
66887c5ab4e1ede5c0839105a6abc71f07269f55c6750c6a4be32f840be83a52  proxysql_2.6.0-debian10_amd64.deb
df36d69669492f8c5f8add711c19c7ba9c56b7e425a179b922b563f4a8fa8edc  proxysql_2.6.0-debian10_arm64.deb
2cc2e821e7e53f6be88ad45130feda52d11c49049a4e6b37468f02e92a309999  proxysql_2.6.0-debian11-clang_amd64.deb
6f1099eed0018c576dd2cb8c5993e49271f975ac60608a22b58ba9e8153573c6  proxysql_2.6.0-debian11_amd64.deb
21053e3ebd75a49a59a59ec4c48a182ae93d6efe6ccaf85418694964d8416698  proxysql_2.6.0-debian11_arm64.deb
404de2ac9ff7539f7631a5743ce6b95c710fb1bbdf0645e0603188137df8d7bb  proxysql_2.6.0-debian12-clang_amd64.deb
c7f7479ddcfb54822a87daa62706c2b98c7725c656c42c299460809b692ed3a1  proxysql_2.6.0-debian12_amd64.deb
7a487d458983754c30b2d049354fd4b9c3cb7841ede312dd9fef1d4a5accd09e  proxysql_2.6.0-debian12_arm64.deb
730e571deb82f0ea9f7dab1ab6efb8c915e1d1812679d48330767969ca943ed1  proxysql_2.6.0-ubuntu16_amd64.deb
80265f08c4db59fb676fa9e6891352efe2948027956f6dd3b11c98bcf869066e  proxysql_2.6.0-ubuntu16_arm64.deb
4224def07dbca865e1b42ded4cddc8b036785c2a3075fe009de343950e50b618  proxysql_2.6.0-ubuntu18_amd64.deb
9b74805b025a513c0aa9da24b13f59a18be6c6dda44b65a469889cc2f60d0ef1  proxysql_2.6.0-ubuntu18_arm64.deb
ef22286f579c0342fd8bf1f50eb2eb0ba8ad09a4741c6c0a8879993c281dbbd4  proxysql_2.6.0-ubuntu20-clang_amd64.deb
5bdc9fa5329e37430cec21f12345d99a5f610069bb7727bf8d467faec8f277a8  proxysql_2.6.0-ubuntu20_amd64.deb
82e3c8bf18bd66cdc169d7007a705f1aa815511350b6057581651b90dcb70356  proxysql_2.6.0-ubuntu20_arm64.deb
f5bcdfe8d2a5fd752f51904a902789e2cea609866ecee7aa4cb248a0166b1197  proxysql_2.6.0-ubuntu22-clang_amd64.deb
b71430e0ab0383050d63a22933c7043efdb225b758d6760b15a97ece4d13ade5  proxysql_2.6.0-ubuntu22_amd64.deb
8b575ad5e15b8bae52bd913897749382a9f35440ff8b3d999ed9d2d52d1cc2d5  proxysql_2.6.0-ubuntu22_arm64.deb