The Altinity ClickHouse Sink Connector is a great way to add sophisticated analytics to your organization with minimal impact to your production MySQL or PostgreSQL system. In this article, we’ll start a test environment and put the Sink Connector to…
Altinity released version 2.0 of the Altinity ClickHouse Sink Connector is here! This open-source, Apache 2.0-licensed project lets you mirror changes from a MySQL or PostgreSQL database into ClickHouse. Read more about the new features in this blog.
With Altinity and Percona’s partnership, building more powerful, cost-efficient applications using ClickHouse as an analytic extension for MySQL is now a reality.
Since its inception, Altinity has contributed to and maintained many open source projects that are accelerating ClickHouse development and adoption. Read our open source story!
Want fast MySQL analytics? Then check out the Altinity Sink Connector for ClickHouse. Merging the power of ClickHouse with MySQL, the sink connector lets you replicate data from MySQL to ClickHouse in real-time.
Our last ClickHouse SF Bay Area meetup was on September 10th and focused on data integration. This turned out to be a popular subject. We had well over 100 signups with 59 people in attendance. This article summarizes the talks…
ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks. Since September 2017 ProxySQL supports ClickHouse as a backend, so clients can connect to ClickHouse via MySQL protocol. In practice, this helps MySQL-aware…
July 2, 2018Vladislav Klimenko from Altinity and Valery Panov from Ivinco presented a talk at HighLoad Siberia 2018 conference recently. They described the real problem that Ivinco faced and how it has been solved with migration of analytics from MySQL…
In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail. Audit logs are available with a free plugin for Percona Server for MySQL. Besides providing insights about activity on…
Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. In this article Percona’s blogger Alexander Rubin is talking about archiving MySQL tables in ClickHouse for storage and…
Feb 12, 2018There are multiple ways how ClickHouse and MySQL can work together. External Dictionaries, ProxySQL support or [realtime streaming] of MySQL binary logs into ClickHouse. A few weeks ago ClickHouse team has released mysql() table function that allows to…
