Upgrade to Pro — share decks privately, control downloads, hide ads and more …

pg_auto_failover: Postgres extension for automated failover & HA | PGCon 2019 | Ozgun Erdogan

pg_auto_failover: Postgres extension for automated failover & HA | PGCon 2019 | Ozgun Erdogan

Citus Data

May 30, 2019
Tweet

More Decks by Citus Data

Other Decks in Technology

Transcript

  1. Saurabh Modi | Citus Data Confidential
    pg_auto_failover:
    Postgres extension for
    automated failover & HA

    View Slide

  2. Saurabh Modi | Citus Data Confidential
    Lukas was going to present this talk
    • Asked me to present in his place and keep the lightning talk modest

    View Slide

  3. Saurabh Modi | Citus Data Confidential
    pg_auto_failover: Best HA solution ever
    • pg_auto_failover is the best thing to happen since
    sliced bread (TOAST).
    • If you don’t like the positioning, please share your
    feedback with Lukas. J

    View Slide

  4. Saurabh Modi | Citus Data Confidential
    pg_auto_failover: Auto failover solution for Postgres
    • Simple, robust, and open source solution for auto failover and
    high availability (HA) in Postgres
    • Simple: No external dependencies. Set up and run in 8 steps
    • Robust: Finite state machine to manage state transitions. Solid
    test suite
    • Open source: PostgreSQL License
    • v1.0 released (very new). Looking for your feedback

    View Slide

  5. Saurabh Modi | Citus Data Confidential
    pg_auto_failover: Architecture Diagram (1)

    View Slide

  6. Saurabh Modi | Citus Data Confidential
    pg_auto_failover: Architecture Diagram (2)

    View Slide

  7. Saurabh Modi | Citus Data Confidential
    pg_auto_failover: Resources
    • Simple way to set up auto-failover for Postgres
    • First version is just out. We take high availability seriously; and
    we welcome your feedback!
    • https://github.com/citusdata/pg_auto_failover
    • https://cloudblogs.microsoft.com/opensource/2019/05/06/introd
    ucing-pg_auto_failover-postgresql-open-source-extension-
    automated-failover-high-availability/

    View Slide