Skip to content

v2.0.7
Compare
Choose a tag to compare
@pondix pondix released this 02 Oct 19:06
v2.0.7
4dd4ef5

Release date: 2019-10-02

Compared to v2.0.6, ProxySQL 2.0.7 introduces the following new features, bugs fixes and enhancements:

New features:

  • Implemented auto discovery for AWS Aurora
  • Added support for tcp_keepalives in proxysql client connections #2248
  • Handling of new SET statements for the following variables:
    • character_set_results
    • session_track_gtids
    • sql_auto_is_null
    • sql_select_limit
    • sql_safe_updates
    • collation_connection
    • net_write_timeout
    • max_join_size
    • tx_isolation
  • Handling of new SET statements for transactions:
    • SET SESSION TRANSACTION ISOLATION LEVEL ...
    • SET SESSION READ (WRITE|ONLY)
  • Added new variable mysql-monitor_groupreplication_healthcheck_max_timeout_count to define the number of timeout checks on Group Replication
  • Error log will report more verbose information in case of ping timeout #2265
  • Added more verbose information on error log when a client connection is closed
  • Generate a warning if mysql-wait_timeout is set to less than 5 seconds: this to facilitate debugging of connections being closed
  • Added new variable mysql-query_digests_no_digits (default false) . If set to true, digits are replaced by ? in query digests (for example on schema and tables names with digits).
  • Added packages for Debian 10 Buster
  • Added systemd support for CentOS 7. NOTE: This package will delete the deprecated /etc/init.d/proxysql script and install a systemd unit file
    ​

Bug fixes

  • Removed hardcoded capabilities that the client uses from libmariadbclient: CLIENT_MULTI_RESULTS and CLIENT_PS_MULTI_RESULTS .
  • Fixed incorrect handling of SET autocommit statements causing SET autocommit=0 to be ignored . This bug affectes both 2.0.5 and 2.0.6 , and an upgrade is highly recommended.
  • mysql-init_connect was not always set correctly
  • Fixed several bugs related to ProxySQL sending GTID to a client when it shouldn't.
  • Minor bug fixes on LDAP implementation
  • mysql-session_idle_ms was internally stored as either 0 or 1 , despite the minimum value for mysql-session_idle_ms being 100 and default 1000 . This bug is now fixed and the minimum value for mysql-session_idle_ms is 1 ms. If using --idle-threads it is highly recommended to verify CPU usage of proxysql and reduce the value of mysql-session_idle_ms
  • Downgraded libssl from 1.1.1b back to 1.1.0.h due to a bug causing high CPU usage.
  • Fixed incorrect handling of mysql_group_replication_hostsgroups.writer_is_also_reader=2 #2208
  • Fixed logic not to disable/shun backends for certain specific error codes #2261
    • From code 1048 to 1052
    • From code 1054 to 1075
  • Fixed a crash caused by KILL QUERY and mysql-eventslog_format=2
  • Applied mysql_query_rules.destination_hostgroup additionally when unable to parse SET statement. Before this bugfix the previous destination hostgroup was applied
  • Fixed CentOS7 packaging in order to restart the ProxySQL service on upgrade, on a fresh install the service will not be started so that the proxysql.cnf file can be modified.
    ​
    MD5s:
31c1dbd678755c6bc012f655fec724e6  proxysql-2.0.7-1-centos67.x86_64.rpm
0e58bf04a8b16ef9d2831cca08b8211a  proxysql-2.0.7-1-centos7.x86_64.rpm
e14196bf0bfe394997fdfef5e920e948  proxysql-2.0.7-1-clickhouse-centos7.x86_64.rpm
4b4cc2245bd4b06c337f22020b72bdd6  proxysql-2.0.7-1-clickhouse-fedora24.x86_64.rpm
1edce111ad68b778a059fc7773364d40  proxysql-2.0.7-1-clickhouse-fedora27.x86_64.rpm
c8b0823445e7661b893164c9f10dcb53  proxysql-2.0.7-1-clickhouse-fedora28.x86_64.rpm
470a2cfc13eb14d9dc4b8c5c49ea066c  proxysql-2.0.7-1-dbg-centos67.x86_64.rpm
c30466b781d95ad3e520231f835fd220  proxysql-2.0.7-1-dbg-centos7.x86_64.rpm
12fb5a50a18a6fea40bc5c9e7b14e0d3  proxysql-2.0.7-1-dbg-fedora24.x86_64.rpm
966b4d2fd59b7857cbc3845e90146b8a  proxysql-2.0.7-1-dbg-fedora27.x86_64.rpm
b1c05908a0507f46b27a2b34e87cae07  proxysql-2.0.7-1-dbg-fedora28.x86_64.rpm
34f85b60bd61d81ae959c5f5a060c8aa  proxysql-2.0.7-1-fedora24.x86_64.rpm
0d2ffb1b3477f78f0f1ae2154c97e8a3  proxysql-2.0.7-1-fedora27.x86_64.rpm
ddc96acb05dd790630518da907d5b8ce  proxysql-2.0.7-1-fedora28.x86_64.rpm
4304dddccb597e724a2e9680e5693578  proxysql_2.0.7-clickhouse-debian10_amd64.deb
971493668d96ab5e9e76ccdba77b268a  proxysql_2.0.7-clickhouse-debian9_amd64.deb
88b93dd730a166ffeb25635e388e4516  proxysql_2.0.7-clickhouse-ubuntu16_amd64.deb
57d5e7d40d2823e53c4bab1f073ce521  proxysql_2.0.7-clickhouse-ubuntu18_amd64.deb
45c1df16af0580169e766e0796f88ea8  proxysql_2.0.7-dbg-debian10_amd64.deb
d114125ad6cc0eb885e6a13a9ab61445  proxysql_2.0.7-dbg-debian8_amd64.deb
ded02058a909b63ca578b2587b16345a  proxysql_2.0.7-dbg-debian9_amd64.deb
9b767cfdfad46b38b45ffec1e930aee2  proxysql_2.0.7-dbg-ubuntu14_amd64.deb
a61ec88440502d7f9efcc7b40639d646  proxysql_2.0.7-dbg-ubuntu16_amd64.deb
7f5d1c0a17a1717634f9f4f28921105f  proxysql_2.0.7-dbg-ubuntu18_amd64.deb
949e2499cb16384924613de0a61ba914  proxysql_2.0.7-debian10_amd64.deb
5bacf7d104eb6ea0eee411e23984129c  proxysql_2.0.7-debian8_amd64.deb
081c32bfb7cfb7dcf76f39e452d1e533  proxysql_2.0.7-debian9_amd64.deb
12444247639bf6a9eb33b20ae3de6e18  proxysql_2.0.7-ubuntu14_amd64.deb
4734abf1a1a1bbc621206aa503239f8f  proxysql_2.0.7-ubuntu16_amd64.deb
05f031830dd9d2c0d677e2adf837bb4b  proxysql_2.0.7-ubuntu18_amd64.deb

SHA1s:

cee306c54baab2e9f7ba6d1a1fe4dd2b7bbd7022  proxysql-2.0.7-1-centos67.x86_64.rpm
bc02ee911e972d13639c2bca1715dd7bf63c58cf  proxysql-2.0.7-1-centos7.x86_64.rpm
a90bc060412b25c8ac7d50cec37c727dcbbbd0fd  proxysql-2.0.7-1-clickhouse-centos7.x86_64.rpm
064bd4f395d0ae1cb78e1ccd887a17fdbd1c785b  proxysql-2.0.7-1-clickhouse-fedora24.x86_64.rpm
deebc7fdf4ad26830c58a6793d9f02c2f37668de  proxysql-2.0.7-1-clickhouse-fedora27.x86_64.rpm
c188f01fa872a330838531d27d7632b577e03a50  proxysql-2.0.7-1-clickhouse-fedora28.x86_64.rpm
b5e6a18b085cf697e8a1bc6314eb3634321cf439  proxysql-2.0.7-1-dbg-centos67.x86_64.rpm
f9605a2b9dc96a3ac439ef1b538c8dea85f9dc10  proxysql-2.0.7-1-dbg-centos7.x86_64.rpm
8167a2f449d55178066a713cb919063c9a5f3085  proxysql-2.0.7-1-dbg-fedora24.x86_64.rpm
ef40a6972d122af7c4ba6d1645ffc4e2c2a5639f  proxysql-2.0.7-1-dbg-fedora27.x86_64.rpm
f187fa16c7cbac95cc4448773a6f69374bad067e  proxysql-2.0.7-1-dbg-fedora28.x86_64.rpm
4b78b3284efd65361f3f9f937e3d5c7e09baaab3  proxysql-2.0.7-1-fedora24.x86_64.rpm
927226326c631985c0d2526b1ddef899b9c5a7d1  proxysql-2.0.7-1-fedora27.x86_64.rpm
4e8835d5375bc4ede8429c1de99c5e1589a88a07  proxysql-2.0.7-1-fedora28.x86_64.rpm
3d8b3f615eb171eba3423f64f8314f62c7a4a5dd  proxysql_2.0.7-clickhouse-debian10_amd64.deb
29e25006fe8aad80d92e5fb3d76ac5046899b933  proxysql_2.0.7-clickhouse-debian9_amd64.deb
53ce5e6e55c969519425ef1b58e6b5cc6b230acc  proxysql_2.0.7-clickhouse-ubuntu16_amd64.deb
28002b65f0ad07d3dd89f15ed7ce51d68e868ab2  proxysql_2.0.7-clickhouse-ubuntu18_amd64.deb
a82cfb3d4fe2d20be13aa5e3acb4fefcc4779251  proxysql_2.0.7-dbg-debian10_amd64.deb
d768e5f007526b35fa44b3b357fe7c9c2c27e844  proxysql_2.0.7-dbg-debian8_amd64.deb
cc9da633a3769b7070541b9fc50984b99aaeb761  proxysql_2.0.7-dbg-debian9_amd64.deb
51629622042d5b9fa2fa606623bafadd83db3caf  proxysql_2.0.7-dbg-ubuntu14_amd64.deb
7f646ef720f2c6cd0294922a7842810f6be017fe  proxysql_2.0.7-dbg-ubuntu16_amd64.deb
a53f2af0dc6343dc22fca4a4ae961f8c730bc75c  proxysql_2.0.7-dbg-ubuntu18_amd64.deb
df8eb3ca754ba30c4c020ba98cfd1b7fd22baeaa  proxysql_2.0.7-debian10_amd64.deb
a4d9e176930bab256286aa25e46e556c4966a15e  proxysql_2.0.7-debian8_amd64.deb
2ffd0a4c4cde03c4d1c9c29dee65df7dbd68b039  proxysql_2.0.7-debian9_amd64.deb
e520c3b69add967d32477f583e561ad3fd8dfedf  proxysql_2.0.7-ubuntu14_amd64.deb
fc3678c68f2392bbe0c7a3498e6edfc42f812f1f  proxysql_2.0.7-ubuntu16_amd64.deb
b7297a30dd82b2f570487ce67279cb13aa862900  proxysql_2.0.7-ubuntu18_amd64.deb

SHA256s:

e8c9b358df5ad9b2724c68c93688a776291b85941bcfd989e2e98c258ce17f6b  proxysql-2.0.7-1-centos67.x86_64.rpm
ca7e0df6935c6a28f2db882d94852e15a51c41780a1df5062af84ca9203281e8  proxysql-2.0.7-1-centos7.x86_64.rpm
2b4721341ff4895e89dd9578a10cf5cf06cbc8bc8bd2c6f39d09ee473adcec56  proxysql-2.0.7-1-clickhouse-centos7.x86_64.rpm
920e5148e1279d8c4b87135979f61486a9f8d9de56951c2e294f798d30cf9d12  proxysql-2.0.7-1-clickhouse-fedora24.x86_64.rpm
ea26ac5551680003686dcfcc98091dd878c0c92e97e7a9246edd97d451e8cadf  proxysql-2.0.7-1-clickhouse-fedora27.x86_64.rpm
37d0f59eb36859f0d7d5464d59f8bc90021d8b1d78850aee7f1fec6388971a4d  proxysql-2.0.7-1-clickhouse-fedora28.x86_64.rpm
0a149345ece8b85ad75f353356868e18d7f278af34ceebd1e322f9b1725c9983  proxysql-2.0.7-1-dbg-centos67.x86_64.rpm
212f788822ac0912684b96108e0a1ce808f6d193730a9b1ced7b71c043a9c482  proxysql-2.0.7-1-dbg-centos7.x86_64.rpm
4947e3c57b8897181fe66e7216327109ea3c2655f04903151afdb05eda294e20  proxysql-2.0.7-1-dbg-fedora24.x86_64.rpm
175b4bd56af1b04d51d44c769cb57c4ef88e7aece60f787ed42439722e3fadda  proxysql-2.0.7-1-dbg-fedora27.x86_64.rpm
c29f012f0a6b9efec36d0263d17a70fea8f5994fb58cc364e7973dffb16ac62a  proxysql-2.0.7-1-dbg-fedora28.x86_64.rpm
22a7815bfc4cc6f3affe3dac1498312de54eab57dae8b617e5e42c23bfa35ef0  proxysql-2.0.7-1-fedora24.x86_64.rpm
13286ca1319861e9fbd0f4ebc0fb3bd9e672af6cb68962e8d70dd9ac26eb54a6  proxysql-2.0.7-1-fedora27.x86_64.rpm
bd909bf5c2848e6f1ede01928a7f56ffb3b4ab868fd34ac40815ceb57c7fc44b  proxysql-2.0.7-1-fedora28.x86_64.rpm
1e9d3e4fbc012f16875c0ffc962f720b9bd65b9a049987ed0aaeef909d8f4f0b  proxysql_2.0.7-clickhouse-debian10_amd64.deb
5d791cf22cc1e93045b587f3ce9aba4a33b75ff8bb755992024852d9b1dd7535  proxysql_2.0.7-clickhouse-debian9_amd64.deb
9676d35097417781a7926e797cd2594947d4d7012f8c470620fad5d069db5e56  proxysql_2.0.7-clickhouse-ubuntu16_amd64.deb
b47cb4274e39c9d9fa32e0ecef71c9c57b4d05c17873565558678b0749208708  proxysql_2.0.7-clickhouse-ubuntu18_amd64.deb
a703e655bb8bc774254636cd7364bc0912e50c3d8eb8135af0abab6d1e12ed48  proxysql_2.0.7-dbg-debian10_amd64.deb
222a964efd303889676a67a1f6b6c4b9dc187c8e41365adf2d87ac4c02e23e6e  proxysql_2.0.7-dbg-debian8_amd64.deb
bc40cd5404e798b7faa1cbdd8ea4b02a475d005c333533e5995f6ea3a3837d15  proxysql_2.0.7-dbg-debian9_amd64.deb
ce33210c95d4b7e094e9d05c56dbc4859757f38538547a75e9a026ab3704120b  proxysql_2.0.7-dbg-ubuntu14_amd64.deb
3e3a243b2b54ecf5c5de32f1fd13c61ceac01c243cdb6eba436b7f0dd5b2e6e6  proxysql_2.0.7-dbg-ubuntu16_amd64.deb
a17070f08759b4b76f299d75206e1077fd92b1301c825fc7c7978a22e78270bc  proxysql_2.0.7-dbg-ubuntu18_amd64.deb
b020d142c1d875645ae55c14406a913e2896a8b96ed3415598c2069428ec9bc1  proxysql_2.0.7-debian10_amd64.deb
478735014c1f5530ae1115d3371a7bb42846821623200feddc60554839df5aa8  proxysql_2.0.7-debian8_amd64.deb
910bef0e272522924375790cdfeece5ec3e281c4671fee3d9f99541692896bdb  proxysql_2.0.7-debian9_amd64.deb
6a2971f8142cf876872cd51e73c3699277f43088e3090358736001e89f65cf58  proxysql_2.0.7-ubuntu14_amd64.deb
f42bb10bbf2744beb667d2aabb3095a4ddbae6fee3183eda068de4c2000642ca  proxysql_2.0.7-ubuntu16_amd64.deb
49ddcd11400af75d4d797975cae96a3b3bd54875e7a93cf8dda3e026bc4a509f  proxysql_2.0.7-ubuntu18_amd64.deb
```​
Assets 32
Loading