logoalt Hacker News

krautburglaryesterday at 11:05 PM2 repliesview on HN

Mixing binlog formats across replicas sounds like user error to me.


Replies

setrtoday at 2:18 AM

Per the article, the replicas are configured the same. MIXED is just dynamically selecting the format automatically, and it seems to be the case that AUTOINCREMENT has fundamentally broken semantics under replication.

And instead of erroring out when replicating, it instead chooses ROW format and plays a game of complete nonsense.

The user error is in not sufficiently reading the docs, but it seems to me MySQL is going out of its way to wrap the noose

show 1 reply
rf15yesterday at 11:11 PM

Or the use of AUTO_INCREMENT, a feature which is already a footgun if implemented badly (as it clearly was)

show 1 reply