Full Auto Database

*
Proposal
Short Form
Intermediate

Excerpt

Why pay for always-on relational database service when you can deploy it yourself so easily? This demo-heavy talk will show off a deceptively simple high availability stack for PostgreSQL, using Docker, Etcd, Kubernetes, Patroni and Atomic.

Description

Why pay for always-on relational database service when you can deploy it yourself so easily? This demo-heavy talk will show off a deceptively simple high availability stack for PostgreSQL, using Docker, Etcd, Kubernetes, Patroni and Atomic. Not only is this open source solution ready to go to give you HA Postgres right now, it represents an approach which can be adapted to other relational databases with replication.

Outline:

1. Introduction
2. First demo
2.1 spin-up
2.2 connecting an application
2.3 automated failover
2.4 redeployment
3. History
3.1 Handyrep
3.2 Zalando
3.3 Compose.io
3.4 AtomicDB
4. Design
4.2 the Patroni agent
4.2 use of Etcd/Zookeeper
4.3 Kubernetes service definitions
4.4 How failover works
5. 2nd Demo
5.1 Code and configuration tour
5.2 Repeat of failover demo
5.3 Requests from audience
6. Conclusion

Tags

Docker, kubernetes, containers, PostgreSQL, database, high availability

Speaking experience

I have spoken at all of the following conferences, some of them several times: Open Source Bridge, OSCON, LCA, Linux Collab, pgCon, Postgres Open, PyDX, SCALE, SELF, and Hi-Load++.

Some video of me can be found here: http://jberkus.github.io/

Speaker

  • Headshot new small

    Josh Berkus

    Red Hat Project Atomic

    Biography

    Josh Berkus spends all day working with Linux containers in Red Hat’s Project Atomic. He was previously known for his role in the worldwide PostgreSQL database project. He also cooks and makes pottery.

    Sessions

      • Title: Bots Not Cattle
      • Track: Theory
      • Room: B201
      • Time: 4:455:30pm
      • Excerpt:

        “Cattle Not Pets” got us to the first generation of microservice infrastructures. Now it’s time for a second generation metaphor: “Bots Not Cattle.”

      • Speakers: Josh Berkus
      • Title: Kubernetes 101
      • Track: Practice
      • Room: B304
      • Time: 10:0010:45am
      • Excerpt:

        So you’ve containerized your application, and now you want to deploy it scalably across a cluster. Kubernetes is your tool for container service management; learn how to use it.

      • Speakers: Josh Berkus

Leave a private comment to organizers about this proposal