MySQL Binlog Replication Modes and CDC Reliability: 8 Things Every Engineer Should Know
Row-based binlog format with FULL images and GTID mode are just the start of reliable MySQL CDC.
Tobias Ferch
Section
7 stories in Change Data Capture.
Row-based binlog format with FULL images and GTID mode are just the start of reliable MySQL CDC.
Stalled replication slots can fill your disk with unbounded WAL retention.
Anchor reads to the change log to bootstrap large tables without data loss.
Production CDC pipelines need coordination across three layers to truly deliver exactly once.
Design pipelines around 24-hour retention and two-consumer limits.
Resume tokens protect change streams only until the oplog overwrites them.
Understanding four key primitives prevents logical replication failures in production.