Supporting multi-active replication with geosharding in PostgreSQL

Опубликовано: 11 Октябрь 2024
на канале: Southern California Linux Expo
292
0

Talk by Denis Lussier

https://www.socallinuxexpo.org/scale/...

We will discuss the work we've done to bring back multi-active logical replication (MMR) in a new derivative of pgLogical. We'll also cover how we implement geosharding in support of low latency, cross-region scale-out and data residency use cases. For the latter we'll focus on enhancements we've made to ensure PII doesn't cross national or regional borders. Finally we'll show a demonstration of multi-active bidirectional replication across 3 continents and 2 clouds, showcasing low latency for database users across multiple geographies.