--- title: MySQL CDC connector for ClickPipes is now Generally... description: ClickHouse announced general availability of its MySQL CDC connector for ClickPipes, enabling replication of MySQL and MariaDB data into ClickHouse Cloud for... canonical: https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: MySQL CDC connector for ClickPipes is now Generally Available | daily.dev og:description: ClickHouse announced general availability of its MySQL CDC connector for ClickPipes, enabling replication of MySQL and MariaDB data into ClickHouse Cloud for... og:url: https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn og:image: https://api.daily.dev/og/posts/ON4YKiJYn.png og:image:alt: MySQL CDC connector for ClickPipes is now Generally Available og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # MySQL CDC connector for ClickPipes is now Generally Available **[ClickHouse](https://daily.dev/sources/clickhouse)** · 7 min read · 1 upvotes · 0 comments ## Summary ClickHouse announced general availability of its MySQL CDC connector for ClickPipes, enabling replication of MySQL and MariaDB data into ClickHouse Cloud for analytics. The GA release adds parallel snapshotting (automatic partition key detection across more data types, cutting a 1TB snapshot from over a day to about an hour with 32 workers), safer production defaults (GTID-based replication and a minimum 72-hour binlog retention requirement for new pipes), expanded observability metrics (CPU, memory, network bandwidth, and source/destination/end-to-end replication lag), and infrastructure-as-code support via Terraform (v3.14.0+) and OpenAPI. Billing for the connector becomes active September 1, 2026, priced at a claimed 5-10x cheaper than third-party ETL tools. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### Does ClickHouse's MySQL CDC connector for ClickPipes now require GTID-based replication? Yes, as of general availability, new MySQL CDC ClickPipes require GTID-based replication by default instead of the legacy file position-based mechanism. GTID support has existed since MySQL 5.6.5 and MariaDB 10.0.2, and it allows replication to resume automatically after failover, unlike file position-based replication which ties resumption to a specific binlog file and offset. Existing pipes using the old mechanism continue to work unaffected. _daily.dev helps teams track breaking defaults like this before migrating a production CDC pipeline._ ### What is the minimum binlog retention required for ClickHouse ClickPipes MySQL CDC connector to avoid a full resync? A minimum of 72 hours of binlog retention is now required for MySQL CDC ClickPipes. This gives the pipe enough runway to recover from a worst-case outage or backpressure on the ClickHouse side before the binlog segment containing the last processed GTID gets purged, which would otherwise force an irrecoverable full resync. _Engineers configuring CDC pipelines can follow database reliability changes like this on daily.dev._ ### How much faster is parallel snapshotting in ClickHouse's MySQL CDC connector compared to single-threaded snapshots? A 1TB snapshot that took over a day on a single thread finishes in about an hour when distributed across 32 workers. ClickPipes now automatically detects a suitable logical partition key from the table's primary key, including string and UUID types, removing the earlier requirement to manually pick a numeric or temporal partition column for parallel processing. _daily.dev keeps data engineers current on CDC and replication performance improvements like this._ ## Similar posts on daily.dev - [MongoDB CDC connector for ClickPipes is now in Public Beta](https://daily.dev/posts/mongodb-cdc-connector-for-clickpipes-is-now-in-public-beta-7i7rcjdo9) · ClickHouse · 2 upvotes · 0 comments - [Terraform & OpenAPI for ClickPipes is now Generally Available](https://daily.dev/posts/terraform-openapi-for-clickpipes-is-now-generally-available-edcomkmwk) · ClickHouse · 0 upvotes · 0 comments - [Postgres CDC in ClickHouse, A year in review](https://daily.dev/posts/postgres-cdc-in-clickhouse-a-year-in-review-myvugvjfb) · ClickHouse · 1 upvotes · 0 comments - [How Spyne simplified their CDC pipeline with ClickPipes and ClickHouse Cloud](https://daily.dev/posts/how-spyne-simplified-their-cdc-pipeline-with-clickpipes-and-clickhouse-cloud-xtczu2jzw) · ClickHouse · 0 upvotes · 0 comments --- Tags: [#data-engineering](https://daily.dev/tags/data-engineering), [#terraform](https://daily.dev/tags/terraform), [#mysql](https://daily.dev/tags/mysql), [#clickhouse](https://daily.dev/tags/clickhouse), [#change-data-capture](https://daily.dev/tags/change-data-capture) [View this post on daily.dev](https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"MySQL CDC connector for ClickPipes is now Generally Available","url":"https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn"},"datePublished":"2026-09-02T14:04:54.332Z","dateModified":"2026-09-02T14:12:30.384Z","description":"ClickHouse announced general availability of its MySQL CDC connector for ClickPipes, enabling replication of MySQL and MariaDB data into ClickHouse Cloud for...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/c7d6a4cd9fd5a67827aad1f4248c05fa?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/c7d6a4cd9fd5a67827aad1f4248c05fa?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"data-engineering,terraform,mysql,clickhouse,change-data-capture","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"MySQL CDC connector for ClickPipes is now Generally Available"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/mysql-cdc-connector-for-clickpipes-is-now-generally-available-on4ykijyn#faq","mainEntity":[{"@type":"Question","name":"Does ClickHouse's MySQL CDC connector for ClickPipes now require GTID-based replication?","acceptedAnswer":{"@type":"Answer","text":"Yes, as of general availability, new MySQL CDC ClickPipes require GTID-based replication by default instead of the legacy file position-based mechanism. GTID support has existed since MySQL 5.6.5 and MariaDB 10.0.2, and it allows replication to resume automatically after failover, unlike file position-based replication which ties resumption to a specific binlog file and offset. Existing pipes using the old mechanism continue to work unaffected. daily.dev helps teams track breaking defaults like this before migrating a production CDC pipeline."}},{"@type":"Question","name":"What is the minimum binlog retention required for ClickHouse ClickPipes MySQL CDC connector to avoid a full resync?","acceptedAnswer":{"@type":"Answer","text":"A minimum of 72 hours of binlog retention is now required for MySQL CDC ClickPipes. This gives the pipe enough runway to recover from a worst-case outage or backpressure on the ClickHouse side before the binlog segment containing the last processed GTID gets purged, which would otherwise force an irrecoverable full resync. Engineers configuring CDC pipelines can follow database reliability changes like this on daily.dev."}},{"@type":"Question","name":"How much faster is parallel snapshotting in ClickHouse's MySQL CDC connector compared to single-threaded snapshots?","acceptedAnswer":{"@type":"Answer","text":"A 1TB snapshot that took over a day on a single thread finishes in about an hour when distributed across 32 workers. ClickPipes now automatically detects a suitable logical partition key from the table's primary key, including string and UUID types, removing the earlier requirement to manually pick a numeric or temporal partition column for parallel processing. daily.dev keeps data engineers current on CDC and replication performance improvements like this."}}]} ```