Turns out MySQL Statement-based Replication might not be a good idea, Lets discuss why

The Backend Engineering Show with Hussein Nasser

English - July 31, 2021 05:00 - 17 minutes - 16.5 MB - ★★★★★ - 5 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: Can Redis be used as a Primary database?

Next Episode: Partial Indexing | Backend Engineering Show

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/

---

Send in a voice message: https://anchor.fm/hnasr/message
Support this podcast: https://anchor.fm/hnasr/support