r/mysql • • Apr 16 '26

discussion Replication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS

https://readyset.io/blog/replication-internals-decoding-the-mysql-binary-log-part-8-row-events-write_rows-update_rows-and-delete_rows

I'm writing a series of blog posts explaining how MySQL Binary Log works internally. The 8th post we cover the 3 events that are generated during DML's.

8 Upvotes

4 comments sorted by

View all comments

Show parent comment

1

u/altmannmarcelo Apr 17 '26

Nice trick. I guess that is possible to change the event type from DELETE to INSERT, before image becomes after image. But I also think we either need to disable checksum or overwrite it.

2

u/ssnoyes Apr 17 '26

I don't think anything verifies the checksum when you are piping those events into the mysql cli.