Release date: 2020-09-08 ​ Compared to v2.0.13, ProxySQL v2.0.14 introduces the following bug fixes and enhancements: ​

New Features

​ Although only bug fixes are supposed to go into ProxySQL 2.0, we had to introduce a few minor new features: ​

• Ability to compile in FreeBSD
• Ability to compile on Mac OSX
• Added new variable mysql-connect_timeout_client : if a client doesn't complete the authentication and establishes a connection within the given timeout, its connection is terminated
• Added new variable mysql-monitor_replication_lag_count : this variable defines the number of replication lag checks that returns a value greater than max_replication_lag before shunning the lagging node. This prevents shunning node(s) in case of a single replication lag spike. The default value is 1 for backward compatibility
• Added DEB package for Ubuntu 20
• ClickHouse support is now merged into main packages ​

Bug fixes

​

• Fixed various compiler warning messages
• Fixed various bugs related to GTID parsing from streams coming from binlog reader that could cause a crash
• Never reset backend connections with a client error code #2989
• A client connection could use a backend connection with a session variable set by a different client #3000
• Fixed several bugs that caused proxysql to restart during a graceful stop or shutdown
• Killed connection were not terminated if they were idle and handled by the auxiliary (not worker) MySQL thread
• The minimum max_connections value for AWS Aurora nodes automatically discovered was set to 1000 . This is now reduced to 10
  ​

Miscellaneous

​

• Upgraded libhttpserver to version 0.18.1
• Improved and enhanced several internal automated tests

MD5s:

4fd87ae7cb85f708147f3ef756eaf8ca  proxysql-2.0.14-1-centos67.x86_64.rpm
956e4a1afd0711299cb1043e7fd65cd6  proxysql-2.0.14-1-centos7.x86_64.rpm
5385a3df9aaf59f7958063a795a2f2fd  proxysql-2.0.14-1-centos8.x86_64.rpm
f58a3668cd9efa2a2d7ea1013d4cd261  proxysql-2.0.14-1-dbg-centos67.x86_64.rpm
646895482c3a95ec82f20b7acf3f7352  proxysql-2.0.14-1-dbg-centos7.x86_64.rpm
f5c2d9b878eda76d8856e32e53d3930c  proxysql-2.0.14-1-dbg-centos8.x86_64.rpm
7a335839bcc1c218d9f5555ea854db1f  proxysql-2.0.14-1-dbg-fedora24.x86_64.rpm
3a260e86bd94ee30af594675b0fcdc2b  proxysql-2.0.14-1-dbg-fedora27.x86_64.rpm
cb8eb1e84a15d8a31d0640013533f94b  proxysql-2.0.14-1-dbg-fedora28.x86_64.rpm
1e4b839c143bb818a514b112ea80ee5b  proxysql-2.0.14-1-fedora24.x86_64.rpm
57e4981bb268078707be25a7f9291496  proxysql-2.0.14-1-fedora27.x86_64.rpm
62cfb0adf0c531890d4564ebf412656e  proxysql-2.0.14-1-fedora28.x86_64.rpm
dbdd37569097330b4142e1295080d10c  proxysql_2.0.14-dbg-debian10_amd64.deb
51b1ddc377bb0911258d2e56e59a0b93  proxysql_2.0.14-dbg-debian8_amd64.deb
163b5e607511f4bcf6c3314dbda7964c  proxysql_2.0.14-dbg-debian9_amd64.deb
9b4dc9745be5de88af2f5feb0cea7b0c  proxysql_2.0.14-dbg-ubuntu14_amd64.deb
0afff0e3e8a45b6aad3d2197d4203385  proxysql_2.0.14-dbg-ubuntu16_amd64.deb
5e5ef0d80c0b86607fdf9c3477270bf2  proxysql_2.0.14-dbg-ubuntu18_amd64.deb
c431c9cdb2a7886a78425df1426e805a  proxysql_2.0.14-dbg-ubuntu20_amd64.deb
5b31994df1821c92c9f3aec6a39ff3d0  proxysql_2.0.14-debian10_amd64.deb
3e521a7a841560bae7c27c457cf4c3f0  proxysql_2.0.14-debian8_amd64.deb
68db1733dd569ec16e4ebd541d13b3f1  proxysql_2.0.14-debian9_amd64.deb
bb8be952a7b49e67a4bb72c5b41ccfbf  proxysql_2.0.14-ubuntu14_amd64.deb
6f845f162a4ea18eab099ce78aa5cda0  proxysql_2.0.14-ubuntu16_amd64.deb
f30901bc450f14babe4c2d5070247d05  proxysql_2.0.14-ubuntu18_amd64.deb
d78debd191fe8a6f75ae270b03e95d73  proxysql_2.0.14-ubuntu20_amd64.deb

SHA1s:

fb7adabf624c1b5cfa96f43a589f57524b34ba22  proxysql-2.0.14-1-centos67.x86_64.rpm
9d63294e0d1e1a8ab500824ca8e2b7df581b1e06  proxysql-2.0.14-1-centos7.x86_64.rpm
64319264501b1c16600cc56880131460a431d81a  proxysql-2.0.14-1-centos8.x86_64.rpm
8401f32966f093417cd38a89802e67b03cd4c091  proxysql-2.0.14-1-dbg-centos67.x86_64.rpm
c6bec38f2e11929be10cb5d3b1467ed0c5b67a8d  proxysql-2.0.14-1-dbg-centos7.x86_64.rpm
ca97c8b36f598933d328487590704125e4075706  proxysql-2.0.14-1-dbg-centos8.x86_64.rpm
b8154702d13db51581a9ed6f5f8d425735037507  proxysql-2.0.14-1-dbg-fedora24.x86_64.rpm
47c2b9743cfebe108f77a21ab697a5b0c6fe18df  proxysql-2.0.14-1-dbg-fedora27.x86_64.rpm
958d96b7f7aa36379d0b9ff554aabf91a5ec5808  proxysql-2.0.14-1-dbg-fedora28.x86_64.rpm
2e1bf183357e84133e7d530302d25fbba6ad5a99  proxysql-2.0.14-1-fedora24.x86_64.rpm
ded13350177c4ee78b860eb848a14a1f6f7dd06a  proxysql-2.0.14-1-fedora27.x86_64.rpm
e708e94595d62d057da8ce48b1f4e1b238badb73  proxysql-2.0.14-1-fedora28.x86_64.rpm
4bca3b7927c036da589e32ca8ae0030672587086  proxysql_2.0.14-dbg-debian10_amd64.deb
40ba3e71bd9e2898c823fec6ffbfb59264a591fe  proxysql_2.0.14-dbg-debian8_amd64.deb
e8db40c652ac9b2eff5b44e5784c2f4fc4f77b8b  proxysql_2.0.14-dbg-debian9_amd64.deb
9ff69cdaddb21ce8f77efc3e17846365d249634e  proxysql_2.0.14-dbg-ubuntu14_amd64.deb
7ab09b1091111ed879a916e1f8b06585ee7c4133  proxysql_2.0.14-dbg-ubuntu16_amd64.deb
e49ee92c6f76f25cd5621c02f4c9fc0f8330ed84  proxysql_2.0.14-dbg-ubuntu18_amd64.deb
faaa1372f4e64ee6dc82131a30685abb6602cc03  proxysql_2.0.14-dbg-ubuntu20_amd64.deb
3da37529bc68a94ec330519c1dddb3730ae547ff  proxysql_2.0.14-debian10_amd64.deb
c7c8bb1bb5ed34bc453a3e183079bf9768507eec  proxysql_2.0.14-debian8_amd64.deb
f673f4b06b09f998955149c0213aad7a5c9b5d5c  proxysql_2.0.14-debian9_amd64.deb
c6a6325b587b2af1b2e2eec19a5916827e45d91f  proxysql_2.0.14-ubuntu14_amd64.deb
a2482cd4369b502471f14ab68eeb0cd4baa42dff  proxysql_2.0.14-ubuntu16_amd64.deb
f17b0449f38101261a5bba47de3b48385fe3799f  proxysql_2.0.14-ubuntu18_amd64.deb
483cb3e6b4361386b95eae1062095b5bab43d4c2  proxysql_2.0.14-ubuntu20_amd64.deb

SHA256s:

714e124f62d2310e892d7b96b9ab81fc8deb3d04348987ded2a898c37450f9c0  proxysql-2.0.14-1-centos67.x86_64.rpm
012342035db36f8dce395c21d5ef6f9e759cd2cc366ccf583af5a8eafffc22a9  proxysql-2.0.14-1-centos7.x86_64.rpm
346612ebbbfa9b502156b4bf0945afe55f242e0f0ac8fd7306cfb8245cdcfee0  proxysql-2.0.14-1-centos8.x86_64.rpm
b1c2be2a3d7f333a54435b44b03977378e68cdb8b674ddbd4dab88048ccf7c1b  proxysql-2.0.14-1-dbg-centos67.x86_64.rpm
8c3c682f30c9622561058e9bb4eb0952dca428004ad3a62d74ac9194c90aeb4a  proxysql-2.0.14-1-dbg-centos7.x86_64.rpm
bf3d1f3fe6a18e165281698c1d506eb8e18c8588b14a5e25ab5d97be11d16f77  proxysql-2.0.14-1-dbg-centos8.x86_64.rpm
ebab48bd61bb2d987d277fd05a9349f0e9e1b6cc7d3f19b780f389351dfb9ae3  proxysql-2.0.14-1-dbg-fedora24.x86_64.rpm
d9c3ce88e5fda830e52abcb9a74a8e302bf7d515bf5095b021e986be4cf389a4  proxysql-2.0.14-1-dbg-fedora27.x86_64.rpm
0780e0d0b789e40223b02808176a80def0d78061d88faa56ee709858e02bdb86  proxysql-2.0.14-1-dbg-fedora28.x86_64.rpm
573783351d5a4213325c4e3a467efb1404cc558daaab83647de0e10c690a848c  proxysql-2.0.14-1-fedora24.x86_64.rpm
4a3f1f322dc7f6553406335aa04c85a0ff286eebae8bcf5ca1ea8a3f1894c463  proxysql-2.0.14-1-fedora27.x86_64.rpm
75b369f064b448e6c2aca919e58ef8a71f490a89df02a7c05307b01c2bf71f2f  proxysql-2.0.14-1-fedora28.x86_64.rpm
f1ee290a5b65ad5b5b713d9b05c215b3eebcf4f8491c9306e8b29a15746be9d1  proxysql_2.0.14-dbg-debian10_amd64.deb
fb570f822ee23979d4db46d1028aebd5042cde19499b31da06ce92b437cef8a1  proxysql_2.0.14-dbg-debian8_amd64.deb
337dfd74c168b9a12b2224bebb08089b4dbfcd6e0225bf61577645e08ffd530b  proxysql_2.0.14-dbg-debian9_amd64.deb
c2044af7d2df2b29187ada1b1e7f1138b4736e6045c7d5ad736e0f498a69a214  proxysql_2.0.14-dbg-ubuntu14_amd64.deb
a370111b39c50815a9b7b0e6dcdee2085a059f59c932dcf7432b91bd8b6da4a5  proxysql_2.0.14-dbg-ubuntu16_amd64.deb
758968f76c01e6b5b30dfd8adf2a37a0d1ecdf3691eb69da48c214a940346978  proxysql_2.0.14-dbg-ubuntu18_amd64.deb
93e54740dd244f78fc4386b04e07429c87bddca6a9312b3cac7dfbb01c0334a6  proxysql_2.0.14-dbg-ubuntu20_amd64.deb
ddadc065e7ad71702da1002f584d35047f324265b778caf11140ccbea0fd6945  proxysql_2.0.14-debian10_amd64.deb
85b1953fe5dc8a31c245ca58fbb03b234fccc496b00659d5443cab24650637b0  proxysql_2.0.14-debian8_amd64.deb
10d3b3e40fcd48e16cea98ae591e2f13db0890aa5c7f96760ce80632041343d1  proxysql_2.0.14-debian9_amd64.deb
96ee92b8cf9a2e71bb42462f9d2f7b16bfe95dc1c4c1c9202cdd9a35a7c99b72  proxysql_2.0.14-ubuntu14_amd64.deb
380741988e6e8884a300636e968292ef0db044ce9802932c7766b03a6a6ebc89  proxysql_2.0.14-ubuntu16_amd64.deb
1e2aa15cc0a65d0dc0ebba6b423ac84fb1a649e7ad35dc1e4c78bbeca585acd8  proxysql_2.0.14-ubuntu18_amd64.deb
46a0aa79bb6e90d0f1bce01079ac67ef6f0207fca3278f424ccb665876f1116d  proxysql_2.0.14-ubuntu20_amd64.deb