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…
Altinity has developed an open source clickhouse-mysql tool that helps to migrate existing MySQL table to ClickHouse and setup realtime replication of changes (INSERTS only). Here we review necessary steps using a simple example.
We use cookies to enhance your experience. By consenting, we can process data like browsing behavior or unique IDs. Without consent, some features may not work as expected.