Setup and Deploy Enterprise-Grade High Availability for PostgreSQL Clusters
Critical business applications require their backend database cluster to be availableat all times. 2ndQuadrant provides an enterprise-grade solution for Single and Multi-Master architectures that allows deployment of Highly Available PostgreSQL with Rolling Upgrades, Fast Failovers, Point-in-Time Recovery, and more. Our Single Master architecture provides High Availability of up to four 9s, while our BDR-based architecture provides AlwaysOn Availability of up to six 9s.
These architectures are designed based on industry best practices and provide high levels of reliability for production use.
AlwaysOn PostgreSQL with BDR
AlwaysOn PostgreSQL with BDR offers up to six 9s of availability and is designed for geographically distributed databases, minimizing latency and providing geo-fencing capabilities. Based on ground-breaking BDR technology, it allows Advanced Clustering & Scaling of the database cluster as well as Automatic Conflict Resolution for DDL and DML replication.
The Highly Available PostgreSQL cluster provides up to four 9s of availability. Whether a planned switchover or unplanned failure, the failover solution ensures the database cluster remains available for your application. In addition, the Highly Available PostgreSQL cluster comes with a built-in backup strategy and recovery plan.
‘Achieving High Availability with PostgreSQL’ Webinar
This webinar covered: Overview of High Availability concepts, High Availability with PostgreSQL streaming replication, Setting up a streaming replication cluster, best practices, Failover and switchover – Reconfiguring application setup, Pros & Cons of Automatic vs Manual failover, Backups and High Availability.
Next-Generation PostgreSQL Replication by Peter Eisentraut
This presentation talks about PostgreSQL replication solutions that provide asynchronous bi-directional multi-master replication (BDR) through publish/subscribe models, that work exceptionally-well for geographically distributed databases.
This course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; Advanced Development and Performance; and Backup & Disaster Recovery