Skip to content

@pondix pondix released this Feb 17, 2020

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:

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
Assets 33
You can’t perform that action at this time.