Position for MySQL 9.1 might be incorrect

[dveeden]

To me it looks like for MySQL 9.1 the position might be end pos instead of the start position of the event.

[lance6716]

Hi @dveeden do you mean the position in binlog header?

It means "position of the next event" in all versions. You can search for "log-pos" in https://dev.mysql.com/doc/dev/mysql-server/9.1.0/page_protocol_replication_binlog_event.html

[dveeden]

That's very well possible. I'll do some tests to verify this. Note that mysqlbinlog names this end_log_pos and has at %d for the start position of the event.

• We may have to double check the docs on this
• We could consider renaming the field to EndPos to make this obvious for people
• Maybe there should be a StartPos and EndPos in the header?
• Any renames should be done in a way that doesn't break compatibility if possible