ProxySQL 1.4.3 - the ClickHouse release

  • Date:
  • Tags: proxy mysql release proxysql ha gpl cluster
ProxySQL 1.4.3

Releasing ProxySQL 1.4.3 , and support for 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 .