Patroni's synchronous replication to achieve high availability while running PostgreSQL on Kubernete скачать в хорошем качестве

Patroni's synchronous replication to achieve high availability while running PostgreSQL on Kubernete

Ensuring high availability is crucial for databases to achieve resiliency and durability. However enabling high availability while running PostgreSQL on Kubernetes poses unique challenges navigating complexities such as increased write latency, node failures, leader elections, handling replication lag etc. This talk will focus on Architectural components of how at Datadog we run PostgreSQL on Kubernetes. What is High availability? Why did we want to achieve high availability and what were some of the challenges we faced. What alternative did we consider to ensure high availability? How did we test the impact of synchronous replication using Patroni to achieve high availability. How we implemented synchronous replication. How do we monitor synchronous replication and address related issues? What has been the impact of synchronous replication in our production systems?