sysown/proxysql v2.3.0

on GitHub

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.

MD5s:

2fe50168146cf5b05332f5ffd6546818  proxysql-2.3.0-1-centos67.x86_64.rpm
4356038b73bd112acfdeed252caea6dc  proxysql-2.3.0-1-centos7.aarch64.rpm
4a668be1327b05826dfb409004898c92  proxysql-2.3.0-1-centos7.x86_64.rpm
61a6d1d112d4e8e4a0d021f190f9a767  proxysql-2.3.0-1-centos8.aarch64.rpm
9920a89bd385be5c77d6adf5d69b8a88  proxysql-2.3.0-1-centos8.x86_64.rpm
45f6a45065e50d1581e9eebb492436a0  proxysql-2.3.0-1-dbg-centos67.x86_64.rpm
40ad469dddcb0cdbc215f72637b3aafd  proxysql-2.3.0-1-dbg-centos7.x86_64.rpm
2be029b2f7a08149589c46aaf8ef2155  proxysql-2.3.0-1-dbg-centos8.x86_64.rpm
cdf79f1d8753b0466a1e47e16e49a5ef  proxysql-2.3.0-1-dbg-fedora24.x86_64.rpm
83c6460a964f1d7b5737e810f8b1bc87  proxysql-2.3.0-1-dbg-fedora27.x86_64.rpm
48951fee6f95fc703d76c6ff064a1fdf  proxysql-2.3.0-1-dbg-fedora28.x86_64.rpm
d25e13c519fc6a0c6e458bc842d64532  proxysql-2.3.0-1-dbg-fedora33.x86_64.rpm
7045363fb5fdb68be7fda72272475891  proxysql-2.3.0-1-fedora24.x86_64.rpm
adcd91453cc37e2b73d29420cff1f5e0  proxysql-2.3.0-1-fedora27.x86_64.rpm
6d296929f923b4937d937dd42fcc839d  proxysql-2.3.0-1-fedora28.x86_64.rpm
6c29be150036b6966458e9996a2abbda  proxysql-2.3.0-1-fedora33.aarch64.rpm
f1cfe17b21f7f935d1e7085af5868b95  proxysql-2.3.0-1-fedora33.x86_64.rpm
d039e4af2c760300105717b8de79961b  proxysql_2.3.0-dbg-debian10_amd64.deb
889868463235f08a71401836c28f129e  proxysql_2.3.0-dbg-debian11_amd64.deb
6598e3040768b3e19672e782e6d2a40a  proxysql_2.3.0-dbg-debian8_amd64.deb
055412b10670c0b28b98519ed8e33e02  proxysql_2.3.0-dbg-debian9_amd64.deb
2f5d3fc5714dc745eea619f01a705e4c  proxysql_2.3.0-dbg-ubuntu14_amd64.deb
ce8affa7af73ba5153551d51be26bab5  proxysql_2.3.0-dbg-ubuntu16_amd64.deb
9e2a08dc02072a73b07003f7eaa7f415  proxysql_2.3.0-dbg-ubuntu18_amd64.deb
ede52a78da793471e76d2c4a57e0db5d  proxysql_2.3.0-dbg-ubuntu20_amd64.deb
201e906f2eb722e5e8f3e37f773e360a  proxysql_2.3.0-debian10_amd64.deb
d932ed519fae8d656d8afc4dcc0e6f4b  proxysql_2.3.0-debian10_arm64.deb
bbd78b7171ab0f2e0b89d10f8889a8ce  proxysql_2.3.0-debian11_amd64.deb
bc58cec9e0af9737ea5132bdbf545a46  proxysql_2.3.0-debian11_arm64.deb
0984f61aaa47567ad8b6fd5129daa8e3  proxysql_2.3.0-debian8_amd64.deb
a2ab18dc0d8eab33d478c11148d3945a  proxysql_2.3.0-debian9_amd64.deb
4bd4404019a048821cd1584f91bc9c3f  proxysql_2.3.0-debian9_arm64.deb
bfebcbac5dba842a510da70cf02437fd  proxysql_2.3.0-ubuntu14_amd64.deb
0835b7ab0a59ad0748845c77cd0448c1  proxysql_2.3.0-ubuntu16_amd64.deb
0a7337f1d253f4a4e1504acb5aea1849  proxysql_2.3.0-ubuntu18_amd64.deb
e2eb3a4b658a775a08c11414f70553c6  proxysql_2.3.0-ubuntu18_arm64.deb
e67dcae95c84c0c329e101dba50811b4  proxysql_2.3.0-ubuntu20_amd64.deb
da1ccd0fbc9b0dc593159e180875302f  proxysql_2.3.0-ubuntu20_arm64.deb

SHA1s:

0f0dcbf19cf90f92bc2fbebd69e45c978e46a3b5  proxysql-2.3.0-1-centos67.x86_64.rpm
8678f0b34505790423d4710e6a11c5fd34582d40  proxysql-2.3.0-1-centos7.aarch64.rpm
fb726aca1d75fe22d665e7445e566f535545189d  proxysql-2.3.0-1-centos7.x86_64.rpm
1a0b367492013b049dc4c27b755badea638debd3  proxysql-2.3.0-1-centos8.aarch64.rpm
2758474f1a9fac0d5c8149ea494088cfb56962a9  proxysql-2.3.0-1-centos8.x86_64.rpm
8ccabea019278da8d5ff5f1d08b3ecf36ade8bb8  proxysql-2.3.0-1-dbg-centos67.x86_64.rpm
3cc18c0f5308296a325d2753f8a051387c132f36  proxysql-2.3.0-1-dbg-centos7.x86_64.rpm
6203c940003980f328e5dc96355d75ab5319fb32  proxysql-2.3.0-1-dbg-centos8.x86_64.rpm
ab70f13a4bce11da2810fe6e6a1b13fda86d7ad7  proxysql-2.3.0-1-dbg-fedora24.x86_64.rpm
3c2f7e777c651e17d94684e9e5bd164832e174e2  proxysql-2.3.0-1-dbg-fedora27.x86_64.rpm
c3ced9fa865e349354073faf2226ac3ef9a7ba61  proxysql-2.3.0-1-dbg-fedora28.x86_64.rpm
5f0dec32c40069b1039e51d54256eb58a78f7b00  proxysql-2.3.0-1-dbg-fedora33.x86_64.rpm
9329e3fa77c4717f8d944ec35ba5ebe223124150  proxysql-2.3.0-1-fedora24.x86_64.rpm
415ba96b05faf7cc7d147d3b1028a241e8a57284  proxysql-2.3.0-1-fedora27.x86_64.rpm
cbee6bf80981cba94f4a653c2a27e22e40bf4e40  proxysql-2.3.0-1-fedora28.x86_64.rpm
e52c8277389c2b02908f058ca0b96c7b1583c995  proxysql-2.3.0-1-fedora33.aarch64.rpm
dd610bbd8d82c5c954a0cd2f1b535b45a420d7de  proxysql-2.3.0-1-fedora33.x86_64.rpm
02b07651ad7a3c16bf1d9749cb058aa30b579e6e  proxysql_2.3.0-dbg-debian10_amd64.deb
7bd41120a3f851c4ad7255d01466ec7192fb2c6f  proxysql_2.3.0-dbg-debian11_amd64.deb
afb55eb1cf408c6eb00d5656f29a1d284b77a21c  proxysql_2.3.0-dbg-debian8_amd64.deb
a48ed1c4e1691dbaacf5d2750940b3940370cb33  proxysql_2.3.0-dbg-debian9_amd64.deb
a838ffdc26c9ebe501dbef09579659a8b1bc164d  proxysql_2.3.0-dbg-ubuntu14_amd64.deb
7c30ab6f413d6a295a35c92f0dc36db6e3425ba9  proxysql_2.3.0-dbg-ubuntu16_amd64.deb
c5a0fb9f803083a5c0a27c860291c3c407feec79  proxysql_2.3.0-dbg-ubuntu18_amd64.deb
dd22cc5877e670657207e4dff1c8a44cf0269c61  proxysql_2.3.0-dbg-ubuntu20_amd64.deb
fb985b0642fd0012f90e9ab0a4b04ca8a90632b3  proxysql_2.3.0-debian10_amd64.deb
3903d1ef826a16fd784af4e35e057bb098fda8b1  proxysql_2.3.0-debian10_arm64.deb
21fd2c21b9a85453cdeaf2c5eea67a98464588de  proxysql_2.3.0-debian11_amd64.deb
9c57ebaff4de977409ab039d2fb7ba1c9c81b9be  proxysql_2.3.0-debian11_arm64.deb
60fa231abc0e6c578194a4feb61c43b98e21a5ac  proxysql_2.3.0-debian8_amd64.deb
e032943d5531588de1fe94066fa1e0fb15189f43  proxysql_2.3.0-debian9_amd64.deb
32e41a32cb7e8a5d5832074edb00126b019065f3  proxysql_2.3.0-debian9_arm64.deb
7825e11ac4fbeaee8105d18c507fdd58f60c9f7a  proxysql_2.3.0-ubuntu14_amd64.deb
53a9a31551ba6a39579fe4893d1e63d2bdfb5d05  proxysql_2.3.0-ubuntu16_amd64.deb
0bf482bb18c0708aad4bc2298ada120c1adff0b3  proxysql_2.3.0-ubuntu18_amd64.deb
558ed87909f2a67eb438c2246657ad67af83e71b  proxysql_2.3.0-ubuntu18_arm64.deb
c086f10c5c62b2b43b6a1e60fff49c330cc26f0c  proxysql_2.3.0-ubuntu20_amd64.deb
ef70c44e0e788d928c6d87e685a4118051dd053d  proxysql_2.3.0-ubuntu20_arm64.deb

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