MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it

What happened
MySQL CDC syncs miss deletes and intermediate updates. Learn how binlog-based Change Data Capture works, what MySQL settings it requires, and how to land it reliably in BigQuery.
Summary assembled by rule from the sources below