MySQL replication deep dive, and ideas for PostgreSQL (PGConf.dev 2024)

A talk presented at PGConf.dev 2024 (https://2024.pgconf.dev) Jagdeep Sidhu presents: MySQL replication deep dive, and ideas for PostgreSQL PostgreSQL originally supported physical replication, and built in support for logical replication was added in PostgreSQL 10. On the other hand, MySQL only supports logical replication. In this talk, we will cover implementation details of MySQL replication - How MySQL writes the binary log, and ensures that it is consistent with storage engine? How the binary log is applied on the replica, and various optimization techniques? Finally we will discuss some pros and cons of this implementation, and compare it to other engines like PostgreSQL. https://www.pgevents.ca/events/pgconfdev2024/schedule/session/110-mysql-replication-deep-dive-and-ideas-for-postgresql/ 🎬 See more PGConf.dev 2024 videos https://www.youtube.com/playlist?list=PLTw6f6dqzO1tTW6Ka_bou9rs5YTNxD8Xr Connect with us X https://twitter.com/pgconfdev Mastodon: https://mastodon.social/@pgconfdev Web: https://2024.pgconf.dev #postgresql #PGConfdev #mysql