Understanding High availability options for PostgreSQL
Dharshan is the founder & CEO of ScaleGrid.io which helps customers run large database workloads on public clouds. He has extensive hands on experience with both SQL and NoSQL databases on various cloud platforms. Before founding ScaleGrid Dharshan was a Principal Lead Engineer on the Azure cloud platform.
Madan is a Member of the Technical Staff at ScaleGrid.
Configuring High availability is critical for any production PostGres deployment. High availabilty goes beyond the setup of streaming replication. You need to understand the implications of process failures, node failures & network partitions on your cluster. In this talk we will present in detail three popular options to setup high availability using PostGres replication.
- PostGres Automatic Failover (PAF) using Pacemaker & corosync
- Replication Manager
We will compare and contrast each of the three options and finally share the results of the detailed testing we have done on each of the three options
- 2018 October 15 13:00 PDT
- 50 min
- Silicon Valley