PostgreSQL, the world's most advanced open-source relational database, has a world-class built-in replication but doesn't provide built-in automatic failover. Patroni, an open-source tool (github.com/zalando/patroni) written in Python, aims to fix this in a right way, by relying on a consistency layer, such as Etcd, Zookeeper or Consul to avoid split brains and false positives. In this talk, I will describe how Patroni helps Zalando to run hundreds of highly-available PostgreSQL clusters on Kubernetes and will highlight one of the newest features of Patroni, the ability to rely on the Kubernetes itself as a consistency layer without any additional 3rd-party tools. I will show the architecture of our database as a service based on Kubernetes and other open-source components.
Those are the slides from the Atmosphere Conference 2018 (https://atmosphere-conference.com) in Warsaw, Poland.