Alexander Kukushkin

Patroni is widely recognized as a premier high-availability solution for PostgreSQL, but what really makes it tick? In this talk, as the Patroni maintainers, we’ll dive deep into its architecture, core principles, and the engineering decisions that keep it running smoothly.

Logical Replication in PostgreSQL is a tool that can be leveraged to encompass multiple critical data integration and movement scenarios, including moving all or a portion of your data in and out, from and to fully managed database services in the cloud like Azure Database for PostgreSQL. From creating an exact copy of your original data in a different environment to applying vertical and...

Upgrading a database cluster can be a complex and time-consuming process. While there are several methods for upgrade, such as dump/restore and logical replication, pg_upgrade is a powerful tool that allows users to upgrade a cluster with acceptable and predictable downtime.

Logical decoding and replication slots being introduced in PostgreSQL 9.4 (released in 2014) created a solid foundation for implementing built-in core logical replication in version 10 (released in 2017). Unfortunately, there are a few limitations that make logical replication not very useful in real-world scenarios.

Logical decoding and replication slots being introduced in PostgreSQL 9.4 (released in 2014) created a solid foundation for implementing built-in core logical replication in version 10 (released in 2017).

Many DBAs avoid any kind of cloud offering and prefer to run their databases on dedicated hardware. At the same time companies demand to run Postgres at scale, efficiently, automated and well integrated into the infrastructure landscape.

Being introduced in 2015, Patoni already become one of the most popular and advanced solutions for PostgreSQL high-availability. It works together with Etcd, Zookeeper, Consul or Kubernetes API to store and retrieve PostgreSQL cluster information in a consistent way ensuring that there is only one leader at a time.

At Zalando we run PostgreSQL at scale: a few hundred database clusters in sizes from a few megabytes up to 10 terabytes of data. What is a bigger challenge than running a high-OLTP multi-terabyte PostgreSQL cluster?

Patroni is a popular modern open-source automatic failover tool for PostgreSQL. It is designed to be easy to use and avoids common pitfalls of other tools, such as false-positives and split-brains, by relying on external distributed consistency layer, such as Etcd, Consul, Zookeeper or the Kubernetes API.

You can get slides at https://github.com/patroni-training/2019/raw/master/slides.pdf Postgres has a rock-solid single master physical replication, but lacks built-in failover.