mysql_ch_replicator
A tool for real-time replication of MySQL databases to ClickHouse, with support for migrations and schema changes.
About
mysql_ch_replicator keeps a ClickHouse database in sync with MySQL with a delay of around five seconds. It batches heavily and moves slow parts, such as MySQL’s internal JSON parsing, into a C++ extension, which its README puts at about 20,000 events per second on a single core.
It’s written in Python and released under the MIT license.
Category
Software & Tools
Subcategory
Replication & High Availability, Data Warehouse & Analytics
Website
github.com ↗
✎ Suggest an updateCommunity feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.