looks simple at first, but things get tricky once it’s running under load
put together a breakdown of how it actually works in practice:
https://streams.dbconvert.com/blog/mysql-change-data-capture/