---
title: "Discussion on \"Streaming MySQL to BigQuery with the binlog: how CDC works, and the parts that bite\" | Hashnode"
description: "Discussion on \"Streaming MySQL to BigQuery with the binlog: how CDC works, and the parts that bite\". Most teams start syncing MySQL to BigQuery with a nightly dump or a query like SELECT * FROM orders WHERE updated_at > :last_run. It works until someone asks why deleted orders still show up in the da"
url: "https://hashnode.com/posts/streaming-mysql-to-bigquery-with-the-binlog-how-cdc-works-and-the-parts-that-bite/6af1824097c64d348b02ff31"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Streaming MySQL to BigQuery with the binlog: how CDC works, and the parts that bite](https://quayen.hashnode.dev/streaming-mysql-to-bigquery-with-the-binlog-how-cdc-works-and-the-parts-that-bite?utm_source=hashnode&utm_medium=feed)

Most teams start syncing MySQL to BigQuery with a nightly dump or a query like SELECT \* FROM orders WHERE updated\_at > :last\_run. It works until someone asks why deleted orders still show up in the da

2d ago · 6 min read · quayen.hashnode.dev  
Read the article

-   [#bigquery](https://hashnode.com/tag/bigquery)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#dataengineering](https://hashnode.com/tag/dataengineering)

## Written by

[Quayen](https://hashnode.com/@quayen)

@quayen

  
[View profile](https://hashnode.com/@quayen)

MySQL to BigQuery in real time: set up CDC replication in 15 minutes (RDS, Aurora, Cloud SQL)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.