v2.3.0 Release notes

Release date: 2021-09-15

This is a major release for ProxySQL 2.x series containing several important features, fixes and enhancements.

New features and enhancements

• Added support for reloading TLS files at runtime, allowing ProxySQL to change its cert/key files used for client connections. This also introduces the command PROXYSQL TLS RELOAD: #3552.
• Enhanced support for SPIFFE authentication: #3552.
• For client connections using TLS, added support for private keys others than RSA, for example EC keys: #3552.
• Added support for certificate revocation list (CRL) and multiple certificate authorities (CA) #3577.
• Added new feature ("Client Error Limit") that automatically blocks clients if they repeatedly fails to connect to ProxySQL #3617.
• Several improvements for group replication monitoring and replication lag actions: #3533
  • Servers which lag is above mysql-monitor_groupreplication_max_transactions_behind_count are now SHUNNED instead of being moved to offline hostgroup . Introduced also a new variable mysql-monitor_groupreplication_max_transaction_behind_for_read_only that determines if the servers are shunned only if in the reader hostgroup or also in the writer hostgroup
  • Servers can now be set for maintenance via OFFLINE_SOFT state.
  • When servers are shunned due to replication lag, SHUNNED status is executed in two stages in order to allow a grace time before terminating all the connections
• Added per-user default transaction isolation level: #3466
• Several improvements related to Aurora: #3515
  • Handle replicas where REPLICA_LAG_IN_MILLISECONDS == 0
  • Ignore decommissioned or renamed nodes, see #3484.
  • During a failover, the former writer (still reporting MASTER_SESSION_ID) is not considered a writer if it is not the last updated.
  • Increases the amount of entries per server stored in mysql_server_aws_aurora_log from 50 to 150 snapshots.
• LDAP authenticating has been reworked for future enhancements: #3491

Minor

• Improved verbosity for connections issues: #3467
• Added commands PROXYSQL GCOV DUMP and PROXYSQL GCOV RESET for improving coverage support: #3486
• Updated libcurl version addressing security concerns: #3518.
• Added new boolean variable mysql-enable_load_data_local_infile to allow or block the executing of command LOAD DATA LOCAL INFILE. Please note that behavior of LOAD DATA LOCAL INFILE hasn't changed, when executed LOAD DATA LOCAL INFILE still refers to a file in ProxySQL instance, NOT on client side: #3526

Bug Fixes

Major

• Fixed crashes due to asserts when under specific timing conditions, a backend connection is being reset after it failed to execute a ping : #3502
• Adding support for error message at the end of a binary protocol resultset. #3548
• Fixed memory leak affecting SSL initialization for frontend connections #3620.

Minor

• Fixed crashes when adding invalid hostname to mysql_servers table: #3431.
• Fixed infinite loop when address specified by sqliteserver-mysql_ifaces isn't available: #3524
• Fixed memory leak affecting failing connections due to invalid credentials #3620.

SHA256s:

ace8c672b8d1d47481e2c062e0f76bbafc6160521a3611975590e75798651d28  proxysql-2.3.0-1-centos67.x86_64.rpm
c9689e7c7246303ea8b27bd08a19be052492e00d8768941883f87980c178b0ba  proxysql-2.3.0-1-centos7.aarch64.rpm
e77e80341b7e3bec947057d4623d123874a527234a4f6f50c6470c95f6b41d7c  proxysql-2.3.0-1-centos7.x86_64.rpm
11d4b657ac9b5cbb200f5d90dc21954f526c196fdf5356fa9763123abb8ee848  proxysql-2.3.0-1-centos8.aarch64.rpm
6c48dd751cffb7fd2811e5e48fa3fd4ee722abd241b759e91b342786ebdb0c7f  proxysql-2.3.0-1-centos8.x86_64.rpm
ab43fae14ab5b7b182440d13a83810c23810169937e4c1feea5d8473e80722f0  proxysql-2.3.0-1-dbg-centos67.x86_64.rpm
7b036d51dd3cad39099e4d467784e94bc7dfa6744fba5179f65e647941abcb58  proxysql-2.3.0-1-dbg-centos7.x86_64.rpm
55fe1a4f57af7173ca018d77d0916329577f39c32dff531d5d9441c1b772b6cd  proxysql-2.3.0-1-dbg-centos8.x86_64.rpm
e68cfcf004088e22b01111b8150f1c86af4bda19c839030f42d86eb8e46a3e63  proxysql-2.3.0-1-dbg-fedora24.x86_64.rpm
96e581307d875f14f3923912f0c62a5a99d8b5ee5d21cdcf67afdc8d03b06455  proxysql-2.3.0-1-dbg-fedora27.x86_64.rpm
47b4193668ebd4f9d5d24d328cfa22c30309fa492e46432582c3ed0a0b6c6c72  proxysql-2.3.0-1-dbg-fedora28.x86_64.rpm
3d7ab54ec0bc4ad6a21df166cc1f17774625b58a44c7288f5bc34313b4ba9e75  proxysql-2.3.0-1-dbg-fedora33.x86_64.rpm
2e516e5957de28ddeda409d5692c1790a0fc5b264c1e9214be99a510de63dcdf  proxysql-2.3.0-1-fedora24.x86_64.rpm
9f84b31882f791d2128123a23e803be1c4434bb33381630a6c3e3a1761727429  proxysql-2.3.0-1-fedora27.x86_64.rpm
d34f9e6daacbd1daa547f8d8ce5200f1cf8ce7d32f4a394970002d3fbd02522f  proxysql-2.3.0-1-fedora28.x86_64.rpm
b44f639098a6dfb783cf810a97d8dfeede8c2036a3948d832243b0c0c1ebb327  proxysql-2.3.0-1-fedora33.aarch64.rpm
9920f59925c93bf6fcc3cb67f356ce48294b12e214cece30e9fad2d1aa494f20  proxysql-2.3.0-1-fedora33.x86_64.rpm
463aebcf12eee58696cbccb3806731fb47e82af88a63ae1cea19cde34f3ddbac  proxysql_2.3.0-dbg-debian10_amd64.deb
500a68f94ce6d3b05ab94bafcd0c4da7a3c5443bf6b75bdf97b3974c737c9d67  proxysql_2.3.0-dbg-debian11_amd64.deb
49f2dd02625df6faacd6c27f4e9538e58d3abe39003880a01692f87cdec62757  proxysql_2.3.0-dbg-debian8_amd64.deb
2e6af856aa8f0a65cd16c02fd816a817c546caeb74edbce47952a615fd1655ce  proxysql_2.3.0-dbg-debian9_amd64.deb
ddd298ee460c1ccbe7719a78967d18c65d6df34313bc69a4d2e12de47562b950  proxysql_2.3.0-dbg-ubuntu14_amd64.deb
ad7ddefdab8bef8ed057ee96e71b27899e48eee78a2ae13e61df0fbc8bc7de70  proxysql_2.3.0-dbg-ubuntu16_amd64.deb
8548a86c0d9751e6d85bce08ebaebdf2bb79d54fca2d629994382f97f7ae7954  proxysql_2.3.0-dbg-ubuntu18_amd64.deb
7f5f6cc346fa9e620c50d470eb4e0a49951aabfcc9244a84c75ed0166c58174e  proxysql_2.3.0-dbg-ubuntu20_amd64.deb
a70890c7816e2cd94b85bc8dcbcb853981507bab1a9d4c08451aa3fdd72d7e65  proxysql_2.3.0-debian10_amd64.deb
7f81be2a9216718f1adc149c2bf17d33fd1cf3cbc4fe71b3f3a4eed9ca590cde  proxysql_2.3.0-debian10_arm64.deb
37b5e1e6ad922821141aa056880720873c3bc75834098ac74a8951d8bd53a0f6  proxysql_2.3.0-debian11_amd64.deb
4e7f86299341bc55f8eecd71c3ee39eca737909d007182a4181bad2220f2f019  proxysql_2.3.0-debian11_arm64.deb
c9bd2bdd4fa2f6703d7900ca66c13ad36d2362a1ab2b0e35604819a9c4a557e9  proxysql_2.3.0-debian8_amd64.deb
22b4fffa04857f5b54f810ef0b2e385584ce15df21dd8f3f7236bd20d670746b  proxysql_2.3.0-debian9_amd64.deb
af98ffbe862401ba934ac03e831580df71b0c031a8ed52985424b510e4cc8696  proxysql_2.3.0-debian9_arm64.deb
6474f3734d6e8200b298c0d35902ad94c169c5f02849d175f60fe392213de0de  proxysql_2.3.0-ubuntu14_amd64.deb
3ac63628a911d13a3d838c7caa2cf9a1234c4fd8c2d7a6777525cac396425be0  proxysql_2.3.0-ubuntu16_amd64.deb
1ea8af4141fcef1b37db144eee45e1b9517f1e3d60de61ce06720ffbecfbdc62  proxysql_2.3.0-ubuntu18_amd64.deb
e698c8445cb1c6f32b11c99c6e6d266b77c5bd96ca1370f4c1e61a43f9cba334  proxysql_2.3.0-ubuntu18_arm64.deb
3b623d05e649feac613f1eb3b68527c5ce89cc38cc994316076766b3ce56f9b3  proxysql_2.3.0-ubuntu20_amd64.deb
64f21045ecc27e47d1385b562d61e94d8d96e0f490066b24e57f7ba69868eb93  proxysql_2.3.0-ubuntu20_arm64.deb