Date: 2023-10-03
Time: 12:00–12:50
Room: The Forum
Level: Intermediate
Feedback: Leave feedback
The way to distribute data from PostgreSQL has evolved over the past decade, making it simpler to build systems for high availability, move data to other locations, or manage independent shards. Much of this is due to logical replication, which allows users to define exactly how they want to stream data between different databases.
In this talk, I will explore how logical replication has evolved over the past decade. We will explore different use cases for logical replication and how PostgreSQL solves them. I'll also review current and planned features for logical replication, including new and ongoing features such as bidirectional replication, parallel apply of transactions, and DDL replication.
Finally, I will propose a roadmap for logical replication to solve more high availability and scalability problems, and how we can build towards active-active replication.