Replication is the process of pushing changes from the master node to worker replica nodes in a database system to allow for horizontal scalability. One of the methods of replication is statement-based which is popular in MySQL. In this episode of the Backend Engineering Show, I explain why statement-based replication is actually a bad idea.
Resources
https://www.youtube.com/watch?v=jsWwFL_iqVM
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/
https://eng.uber.com/postgres-to-mysql-migration/
The Backend Engineering Show with Hussein Nasser