MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it
Summary
An in-depth guide explaining how Change Data Capture using MySQL binlog works to stream changes into BigQuery, and why periodic batch syncs can miss deletes and intermediate updates. It covers prerequisites (ROW format binlog with full row images, replication privileges, server-id, binlog retention), setup steps, and how CDC differs from regular scheduled syncs, including the role of managed platforms in handling snapshot behavior and recovery.