# Under the Hood: Building MySQL Change Data Capture in ClickPipes

DevFeed: [Under the Hood: Building MySQL Change Data Capture in ClickPipes](<https://devfeed.tech/articles/under-the-hood-building-mysql-change-data-capture-in-clickpipes-5012.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/building-msql-change-data-capture-in-clickpipes>)

Author: Kaushik Iska, Philip Dubé

Published: 2025-05-13T15:31:24Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Replication](<https://devfeed.tech/topics/replication.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [datasets](<https://devfeed.tech/topics/datasets.md>)

Tags: [architectures](<https://devfeed.tech/tags/architectures.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [replication](<https://devfeed.tech/tags/replication.md>)

## AI overview

This technical deep dive explains how ClickPipes, ClickHouse Cloud's native data integration solution, implements Change Data Capture for MySQL. It covers MySQL binary logs, binlog formats, the requirement for complete before-and-after row images, GTIDs, and the architecture used for reliable, high-performance replication and real-time data integration.

## Source excerpt

CDC is a critical pattern in modern data architectures that require real-time data integration. In this deep dive, we'll explore how ClickPipes implements CDC for MySQL databases.