MySQL 9.6: Foreign Key Cascade Operations Finally Hit the Binary Log
Summary
MySQL 9.6 moves foreign key cascade enforcement from the InnoDB storage engine to the SQL layer, making cascaded deletes/updates visible in the binary log. The article discusses implications for replication and CDC pipelines, backward compatibility options, and performance considerations, highlighting benefits for downstream data accuracy and auditability.