Schedule - PGDay Chicago 2023

    Making pgLogical great again with Spock

    Date: 2023-04-20
    Time: 10:50–11:40
    Room: Kinzie Forum
    Level: Intermediate
    Feedback: Leave feedback

    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.


    Phillip Merrick