Room: Room 1
Full support of multi-master logical replication in pgLogical has gone unsupported for many years. In this talk we will discuss the work we have done to bring back multi-master replication in a new derivative of pgLogical we call Spock. Spock is available as an open source PostgreSQL extension under a community open source license.
High performance web applications increasingly need presentation, compute and data hosted at or near the network edge. To date being able to place read/write copies of databases at the network edge has been problematic. At a minimum placing data and databases in a handful of cloud regions closer to end users can deliver a superior experience for the end user. We describe how Spock makes this possible.
Additionally we will cover how we implement geosharding in support of cross-region scale-out and data residency use cases. Finally, time permitting, we will show a demonstration of multi-master bidirectional replication across three continents and multiple clouds, showcasing ultra-high availability and low latency for database users across multiple geographies.