Replicating Data from MySQL to ClickHouse
summary
Describes moving analytical workloads from MySQL to ClickHouse by replicating data from MySQL into ClickHouse. Covers using ClickHouse’s scalable, high-performance columnar storage to run fast analytical queries on raw data instead of relying on MySQL precomputations, and highlights ClickHouse’s ability to scale linearly and handle trillions of rows.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 6:08Performance challenges
- 7:33Migration options
- 12:33Replication tool
- 17:29Solution architecture
- 22:46Implementation results
- 26:43Q&A
related talks
42mBuilding an Analytic Extension to MySQL with ClickHouse® and Open Source
51mTheory and practice of using ClickHouse in real applications
51mWhat You Need to Know About ClickHouse Architecture
40mData warehouse or conventional database: Which is right for you?
30mSQL Row Store vs Data Warehouse: Which Is Right for Your Application?
59mEffective Use of ClickHouse
49mSolving real business cases with ClickHouse
55mBuilding Fast ClickHouse Analytics for MySQL Transaction Data Using Kubernetes