Replicate MySQL to ClickHouse with Sling (opens in new tab)

Introduction ClickHouse is a columnar OLAP database. It runs aggregate queries across billions of rows in seconds. MySQL is what most apps run on for transactional reads and writes. Different jobs, different storage shapes, which is why people end up running them side by side: MySQL for the app, ClickHouse for analytics on top of the app's data. The piece in the middle, the bit that copies tables from MySQL into ClickHouse and keeps them current, is what Sling does. This guide replicates a My...