Learn how to efficiently synchronize data in real time between MySQL and ClickHouse in this 18-minute conference talk from OSACon. Discover why traditional transactional databases like MySQL, PostgreSQL, and MongoDB struggle with real-time analytics and space efficiency as data volumes increase. Explore the Altinity Sink Connector open source project, which offers a robust solution for accurate and high-performance data replication, including schema changes. Get hands-on insights into checksumming, dumping, and loading terabytes of data efficiently using this generally available connector, designed with operational simplicity in mind.
Replicating Data Between Transactional Databases and ClickHouse
Overview
Syllabus
Replicating data between transactional databases and ClickHouse®
Taught by
OSACon
Related Courses
-
AWS Database Specialty Certification
-
Unified Data Management with ClickHouse and Postgres - Building an Efficient Data Platform
-
Running ClickHouse in Production - Lessons Learned
-
ETL vs ELT - Building Real-Time Data Pipelines with RudderStack and ClickHouse
-
ClickHouse Data Management Internals - Understanding MergeTree Storage, Merges, and Replication
-
Building Fast Data Loops from Insert to Query Response in ClickHouse
