{"repo":"bakwc/mysql_ch_replicator","free":true,"listed":false,"github":"https://github.com/bakwc/mysql_ch_replicator","clone":"git clone https://github.com/bakwc/mysql_ch_replicator.git","description":"Tool for replication of MySQL databases to ClickHouse","language":"Python","stars":107,"topics":["clickhouse","database","mysql-clickhouse","replication"],"license":"MIT","category":"databases-storage","readme_excerpt":"mysql ch replicator [![Release][release-image]][releases] [![License][license-image]][license] [release-image]: https://img.shields.io/github/v/release/bakwc/mysql ch replicator?style=flat [releases]: https://github.com/bakwc/mysql ch replicator/releases [license-image]: https://img.shields.io/badge/license-MIT-blue.svg?style=flat [license]: LICENSE mysql ch replicator is a powerful and efficient tool designed for real-time replication of MySQL databases to ClickHouse. With a focus on high performance, it utilizes batching heavily and uses C++ extension for faster execution. This tool ensures seamless data integration with support for migrations, schema changes, and correct data management. Table of Contents - Features - Installation - Requirements - Installation - Docker Installation - Usage - Basic Usage - One Time Data Copy - Configuration - Required settings - Optional settings - Advanced Features - Cluster Mode - Migrations & Schema Changes - Recovery Without Downtime - Known Limitations - Production usage - Development - Running Tests - Contribution - License - Acknowledgements Features - Real-Time Replication : Keeps your ClickHouse database in sync with MySQL in real-time (±5 seconds delay). - High Performance : Utilizes batching and ports slow parts to C++ (e.g., MySQL internal JSON parsing) for optimal performance (±20K events / second on a single core). - Supports Migrations/Schema Changes : Handles adding, altering, and removing tables without breaking the replica","default_branch":null,"files":null,"tree":[],"storefront":"/r/bakwc","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bakwc/mysql_ch_replicator/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}