A safe MySQL upgrade that wasn't so safe
Summary
A technical blog post describes a problematic MySQL upgrade where adding an AUTO_INCREMENT column caused ID mismatches between source and replica due to mixed binary log formats. The article explains how statement-based versus row-based replication, driven by binlog_format, led to inconsistencies in one table, highlighting the risks of replication and the importance of thorough testing during migrations.