Releasing ProxySQL 1.4.3 , and support for ClickHouse

[René Cannaò]

Original post: http://www.proxysql.com/blog/proxysql-143-clickhouse

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!

But not only!

In today's release, ProxySQL 1.4.3, the most important feature is surely the support for ClickHouse as a backend!
Clients can still connect to ProxySQL using the MySQL Protocol, and ProxySQL will query ClickHouse.
Because of this, the above statement needs to be edited: ProxySQL doesn't support only MySQL!

Support for ClickHouse is available only in packages for Ubuntu 16, Debian 9, CentOS 7, and Fedora 24, where the package name includes clickhouse.
It is possible to download it here.
ClickHouse module is disabled by default, and it is initialized using the option --clickhouse-server .

ProxySQL 1.4.3 is also an SQLite Network Server.
Using MySQL clients and credentials of MySQL users, it is possible to connect to a network SQLite Server over TCP connections.
This feature for now is a simple POC and has several limitations, like the fact that it is in memory only and there is no users isolations, but it is a fully transactional RDBMS powered by SQLite3.
SQLite Server module is compiled in every package, it is disabled by default, and it is initialized using the option --sqlite3-server .

[Zhenhua Cao]

I have question about mysql group replication data synchronization delay, whether to write data, the cluster of each node will be read immediately to get the data that is just write by the ProxySQL.

I find a blog that answer the question :http://lefred.be/content/mysql-group-replication-read-your-own-write-across-the-group/  But if proxysql can do it. and how to configure the proxysql.

在 2017年9月19日星期二 UTC+8下午1:32:12，René Cannaò写道：