sysown/proxysql v2.0.9 on GitHub

Release date: 2020-02-17

Compared to v2.0.8, ProxySQL v2.0.9 introduces the following bug fixes and enhancements:

Enhancements

Introduced new variables mysql-monitor_groupreplication_max_transactions_behind_count to disable backend node in a Group Replication cluster only if the node was behind beyond that threshold #2326
Upgraded mariadb client connector from version 3.0.2 to 3.1.4 . This also fixes several bugs present in the old version
Introduced new variable admin-stats_mysql_query_digest_to_disk , table history_mysql_query_digest.history_mysql_query_digest , and command SAVE MYSQL DIGEST TO DISK . See #2368 . These are useful tools for the new firewall functionality
Upgraded clickhouse-cpp library to support ENUM
It is now possible to generate configuration file (text format) in 2 ways:
- Executing the query SELECT CONFIG INTO OUTFILE /path/to/file
- Executing the query SELECT CONFIG FILE and save the resultset to file, for example mysql -padmin -uadmin -h127.0.0.1 -P6032 -e 'select config file' > /path/to/file
Support min_gtid annotation , so that client can specify the minimum GTID set to execute a query on a replica, when combined with binlog reader #2469
In Admin, added support for syntax SHOW TABLES IN #2478
When Monitor is configure to monitor a PXC server using the native support for Galera , pxc_maint_mode will be evaluated is present
If Monitor isn't able to verify the status of a backend because the monitor password is expired, the backend is still considered healthy. For visibility, this event will be logged on error log

Enhancements related to AWS Aurora

Added new settings (add_lag_ms , min_lag_ms and lag_num_checks) related to AWS Aurora
Allows the same nodes to be part of multiple clusters

Improvements related to Web module

Upgraded libmicrohttpd to version 0.9.68
Enabled SSL in curl
Enabled SSL in libmicrohttpd compiling against GnuTLS
SSL is now enabled in Web UI
Implemented version checking
Version checker in Web UI:
- is now able to check latest version using HTTPS
- uses the correct agent version

Improvements related to SQLite3 Server module

SQLite3 Server is now better able to mimic a more complex relational database system:

Ability to handle transactions
SERVER_STATUS_IN_TRANS flag is set in OK packets and resultsets if a transaction is running
A persistent database file in datadir is used instead of in-memory database
Database file uses WAL (Write-Ahead Logging)
WAL journal size is set to 64MB
Monitor user can always login to SQLite3 Server
In case of database lock within a transaction, an error is immediately returned to client

Security enhancements

Beside the introduction of SSL on Web modules, more advanced security features were introduced:

Implemented firewall whitelist
Implemented SQL injection engine

New REST API module

Introduced a new REST API (not feature completed and still under development) that will allow further extension of ProxySQL capabilities. Details of the implementation are available in the wiki .

Bug fixes

Fixed several small memory leaks
Fixed a race condition on KILL CONNECTION that could cause a leak of file descriptors (connections not being properly closed)
Fixed a buffer overflow for long GTID set #2395
If some session variables were set by the client before proxysql turned on lock_hostgroup, these variables were not set #2423
Fixed few crashing bugs in native Galera support #2419
Fixed a crashing bug in eventlog writer #2427
Reimplemented and corrected how MySQL protocol command MYSQL_SET_OPTION enables/disables multi statements when multiplexing is disabled #2449
Return error code 1290 id the backend server is in read-only mode #2451
A prepared statement with large resultset (larger than 4GB) would cause a crash
A prepared statement returning a resultset with at least one row larger than 16MB would cause a crash
Unable to start with systemd if datadir isn't the default #2494

General

General code cleanup and refactoring
Deprecated the use of google-coredumper : this allows to compile on ARM processor, and should allow to compile on BSD systems
If ProxySQL's watchdog intentionally crashes ProxySQL, the error log reports a link to the wiki
Updated init.d script #2115
Deprecated Debian 7 and CentOS / RHEL 6 support

MD5s:

96617d5f227eb2561f7750c71c2f6327  proxysql-2.0.9-1-centos7.x86_64.rpm
ed6831e2a69df1237347884170f36430  proxysql-2.0.9-1-centos8.x86_64.rpm
7d3f6526b54c6dd5c7635aec772d8466  proxysql-2.0.9-1-clickhouse-centos7.x86_64.rpm
317fe238dea2857b6b559c68da5cfc03  proxysql-2.0.9-1-clickhouse-centos8.x86_64.rpm
082aba6d54a86a8e324eb20913c29123  proxysql-2.0.9-1-clickhouse-fedora24.x86_64.rpm
b1685d31955d1e0f4f9f47b989218cf3  proxysql-2.0.9-1-clickhouse-fedora27.x86_64.rpm
a2ac3bb3a64c955c4f2eb5e5e96f1f0b  proxysql-2.0.9-1-clickhouse-fedora28.x86_64.rpm
c194d81f4d9d240cbd1ab78b2b851aba  proxysql-2.0.9-1-dbg-centos7.x86_64.rpm
39194f45205fd30f6c3a10461222a365  proxysql-2.0.9-1-dbg-centos8.x86_64.rpm
9940c60f51a7051869db4e68ceb2c9b1  proxysql-2.0.9-1-dbg-fedora24.x86_64.rpm
9f85e88a3c8e407f67222251ac179b60  proxysql-2.0.9-1-dbg-fedora27.x86_64.rpm
2312e2446b49351b2f791b27c31641d3  proxysql-2.0.9-1-dbg-fedora28.x86_64.rpm
7c971455282193a98d5abeddec206dd0  proxysql-2.0.9-1-fedora24.x86_64.rpm
eff88507eba4cae4d7137aab849f8605  proxysql-2.0.9-1-fedora27.x86_64.rpm
51462e7c5bde8be248643ce2e93964f6  proxysql-2.0.9-1-fedora28.x86_64.rpm
bd2c0dbdca30f9a90e017c7e5783f025  proxysql_2.0.9-clickhouse-debian10_amd64.deb
82af4b0d2aa286968312f432647e33ce  proxysql_2.0.9-clickhouse-debian9_amd64.deb
8f9a3e6b99290f407c703f8589a5882c  proxysql_2.0.9-clickhouse-ubuntu16_amd64.deb
3644bf061ca69cc15a8d25a205b754d7  proxysql_2.0.9-clickhouse-ubuntu18_amd64.deb
93e2ae301be0c87e95a9abd4a41bfca7  proxysql_2.0.9-dbg-debian10_amd64.deb
b98e2cb51627eb1a068a90df63731d47  proxysql_2.0.9-dbg-debian8_amd64.deb
fe98232c4e155d23f18602fe9108233d  proxysql_2.0.9-dbg-debian9_amd64.deb
b3f156a55ac76681a7d74cef2c5908a5  proxysql_2.0.9-dbg-ubuntu14_amd64.deb
0659464c40e7b82f13827431de59713c  proxysql_2.0.9-dbg-ubuntu16_amd64.deb
f9a4272063defdd454d68d0aaa588b66  proxysql_2.0.9-dbg-ubuntu18_amd64.deb
1312b8f378d73002a1c8eff97d322d94  proxysql_2.0.9-debian10_amd64.deb
900e3be58e0f650a5a223b0c88c12b49  proxysql_2.0.9-debian8_amd64.deb
d584b84d3399c1f11ce5939b6bc8f8c4  proxysql_2.0.9-debian9_amd64.deb
ce7416bcb381c68fc1b69f8d4d1c9aa7  proxysql_2.0.9-ubuntu14_amd64.deb
4db20b0cba452bf0b54d71a0fc24a0f3  proxysql_2.0.9-ubuntu16_amd64.deb
a55110279f636ca52d6a532ce5ba9880  proxysql_2.0.9-ubuntu18_amd64.deb

SHA1s:

51ddf164eec50250921d32416bd37a366b618379  proxysql-2.0.9-1-centos7.x86_64.rpm
230db6a0d12e27e60617425a5e0f31af78eaeb91  proxysql-2.0.9-1-centos8.x86_64.rpm
dcb93b5b74f312d39e4bb4598be3afe16d307895  proxysql-2.0.9-1-clickhouse-centos7.x86_64.rpm
2c1ad1e006c0da8dddd47e8c9149ec5936b34b1c  proxysql-2.0.9-1-clickhouse-centos8.x86_64.rpm
22363cdcb33b7122ea150b66fd1a840592c1876e  proxysql-2.0.9-1-clickhouse-fedora24.x86_64.rpm
1be2ce01abe26c4697c30a765e449e92ebc3fb8d  proxysql-2.0.9-1-clickhouse-fedora27.x86_64.rpm
aa077eb5e967767a3beb0a69ae3484c4939934b1  proxysql-2.0.9-1-clickhouse-fedora28.x86_64.rpm
fa02f5298a8fbb15cb59e514ddd297a3fcc5d66d  proxysql-2.0.9-1-dbg-centos7.x86_64.rpm
ac649393d780a2656ea7366ee7f992d2e27ee7f5  proxysql-2.0.9-1-dbg-centos8.x86_64.rpm
7bd4cd23ae677218f2f9f6bb825247b7973cf33d  proxysql-2.0.9-1-dbg-fedora24.x86_64.rpm
2429f46604acda8c3645cc3790c7142fd4d5305f  proxysql-2.0.9-1-dbg-fedora27.x86_64.rpm
b3c48262e4d4516f89a76637974ede24ee63d3bf  proxysql-2.0.9-1-dbg-fedora28.x86_64.rpm
f90206be7ba69611a8902f07a509812f25a5e48a  proxysql-2.0.9-1-fedora24.x86_64.rpm
befe5dbbd69d18cb27d89296d14eaf600a7002b7  proxysql-2.0.9-1-fedora27.x86_64.rpm
8acf93e13630bb41e070a2684981c167b39ab4f7  proxysql-2.0.9-1-fedora28.x86_64.rpm
d4bb01f71a97cca4874d6a29d9fadc06b5dde421  proxysql_2.0.9-clickhouse-debian10_amd64.deb
dc63c62ae50b6052797b5147581f67632a833537  proxysql_2.0.9-clickhouse-debian9_amd64.deb
876cbb6792e64b2736670ad891bf71320bad2b25  proxysql_2.0.9-clickhouse-ubuntu16_amd64.deb
df9236017aeecc6a5004c2c13ffb0402b337d141  proxysql_2.0.9-clickhouse-ubuntu18_amd64.deb
c7b7400a7053ba5dd0e75f0f7acc0dd725b38540  proxysql_2.0.9-dbg-debian10_amd64.deb
10157ed3cfe830eda46996e4c38c41bad14c5ad1  proxysql_2.0.9-dbg-debian8_amd64.deb
86da44b2d09ca8858aab2eb8ac8a6460ec4f767c  proxysql_2.0.9-dbg-debian9_amd64.deb
81f1b8d015593b2cd4f4aa9ace83a4a8ea635808  proxysql_2.0.9-dbg-ubuntu14_amd64.deb
fd02e92d58e1bff8d9080355526209fda714b90d  proxysql_2.0.9-dbg-ubuntu16_amd64.deb
d5b42b874e5a2994290ce0cd0ff16f020bfc9424  proxysql_2.0.9-dbg-ubuntu18_amd64.deb
d361f91b785bcea583d4b0c1ad98dee1fe456595  proxysql_2.0.9-debian10_amd64.deb
da9e492df8a243cd0c9605730bd001ba0ac679f0  proxysql_2.0.9-debian8_amd64.deb
37ab4af4b0a1e392cbf23f528e945ee9c4b73208  proxysql_2.0.9-debian9_amd64.deb
3a8e9743e6c9a3a30116c712623f48eea185186e  proxysql_2.0.9-ubuntu14_amd64.deb
8f3712dbdc2be32d248bfe0bc6f7a49719060e41  proxysql_2.0.9-ubuntu16_amd64.deb
51417d8fdff2c7c9ff17c60bf17712614de51378  proxysql_2.0.9-ubuntu18_amd64.deb

SHA256s:

ab51e6f42566e4c25fab3dcdd14aeecef6da2455243d1e5fcc513778dd2eb4aa  proxysql-2.0.9-1-centos7.x86_64.rpm
5ffe91a42c921a96d2efc32a7721931f3c070bfb54558d7cf6f1916aabad69cf  proxysql-2.0.9-1-centos8.x86_64.rpm
580cf663be2b0d302702005f0da2b7e1696f5487968a6bb0ab1ac9b1c14ab1fd  proxysql-2.0.9-1-clickhouse-centos7.x86_64.rpm
ed9de171738ddd1c8bfe0b6ca291f4ba3c5e0ffdbeee8daf5df61e6188bd16f1  proxysql-2.0.9-1-clickhouse-centos8.x86_64.rpm
e51e64fdbef8eb430e0f4353735756da10297bbeae41b2911dcf6f153e32611c  proxysql-2.0.9-1-clickhouse-fedora24.x86_64.rpm
db9140378ed0caaede6e5b0b473d03c3bff2fafe92d118278c8abeb5e8c6c1bb  proxysql-2.0.9-1-clickhouse-fedora27.x86_64.rpm
627df2926a702e669c5513324ee0a1b02869788ab3c4d20f0dbd8dbce865f621  proxysql-2.0.9-1-clickhouse-fedora28.x86_64.rpm
a7069f82b1b64689943d4cb9dc2d5646da36ede75ec2dd79e5b4529f62070d0f  proxysql-2.0.9-1-dbg-centos7.x86_64.rpm
86498b41e4a23f17d9b74e8352beb46bde6de18c43fcb0c805be1c460025d88b  proxysql-2.0.9-1-dbg-centos8.x86_64.rpm
49e38c5d6f885c5a52e2832df74798ca8271e13316d50816834c13dbf8951865  proxysql-2.0.9-1-dbg-fedora24.x86_64.rpm
f13843f734ab5bf36dd8a5608ddfe5e2c1fe3d8118704ff21bd3a83148887366  proxysql-2.0.9-1-dbg-fedora27.x86_64.rpm
599e8cd557c36b04f9f1d24975b11e6b33288e9481a49e35982c2ebb8f42c56f  proxysql-2.0.9-1-dbg-fedora28.x86_64.rpm
dfa3751fd92f43ee4fe800d111e152f8abd0bfca2db001e24aa7804dc1316874  proxysql-2.0.9-1-fedora24.x86_64.rpm
fba5fc38949052c722cdf80a0ed38e3efef122cf231a367f691777b2ed7432b3  proxysql-2.0.9-1-fedora27.x86_64.rpm
e48273844dade395eead2076074ab366b043518e606f0ec488634cc8aba69830  proxysql-2.0.9-1-fedora28.x86_64.rpm
77c752edfc2525fea9d8b277e89b2738396d4c5bbc46248297b806162dda1a17  proxysql_2.0.9-clickhouse-debian10_amd64.deb
f6d15f18bed829655d849e8700e65dd0d6259e79e423528385a9edf8a89bf964  proxysql_2.0.9-clickhouse-debian9_amd64.deb
4d83561390606ed101185237a49d20b0bb78ab18503a9f3f51aeb047d72c3f6a  proxysql_2.0.9-clickhouse-ubuntu16_amd64.deb
c28b281054b776f7290128476ccc6d34c29a5a5990aa425df12fa8cab9224a27  proxysql_2.0.9-clickhouse-ubuntu18_amd64.deb
8f3496a4e13104b7abcbe17ab3a4d34a70da3eddedbd696aec3fa613b6ac71c4  proxysql_2.0.9-dbg-debian10_amd64.deb
4fa99016dba72e52a8d815337c863904b569b1b3076aaec22f92f58d055418cf  proxysql_2.0.9-dbg-debian8_amd64.deb
ad3a8c8e70ccd32490763fd48ea2b9305bbf6709fca8fc9d5fd90642466e30e3  proxysql_2.0.9-dbg-debian9_amd64.deb
af6d1f403c4c4190d73f8d05015cbd72f7d30142ce98e3b550249f69c23c90d8  proxysql_2.0.9-dbg-ubuntu14_amd64.deb
a9b40a9e9e781f4d54b23821a84f93719b82bd110d9d7880d370155f3abde2c7  proxysql_2.0.9-dbg-ubuntu16_amd64.deb
c443f8c7ee686c11d41c498b089de49ea9be56db6d7e7480f645399bdce3219a  proxysql_2.0.9-dbg-ubuntu18_amd64.deb
c156b262669dfce9f22519516f742108fe4f58b493d7f3b8c8af53fd6aac46fe  proxysql_2.0.9-debian10_amd64.deb
ef49b9ba693e1cff82e4a3d558ba69b9b5176ca7a930e5d0be6f222fb55f4170  proxysql_2.0.9-debian8_amd64.deb
8a7262832dc5563c1a2ce869cd008f3f5d162d541121cf8bad785b185a662aaf  proxysql_2.0.9-debian9_amd64.deb
5294f7d795aae8e74e87cc2d09fad0b12660d2d8975b46ec8ca164d7e9ae9361  proxysql_2.0.9-ubuntu14_amd64.deb
1ba42e35430c65f82f7ab7991c9bd31092f72455bbe509f0766ba884bd4e5f5d  proxysql_2.0.9-ubuntu16_amd64.deb
64266d61ff132606993352f8664e18ec2bb240e4acf44e8483daee788cbee376  proxysql_2.0.9-ubuntu18_amd64.deb