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

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.

Connect with us

#postgresql #PGConfdev #mysql