Achieving High Availability with PostgreSQL
Setup and Deploy Enterprise-Grade High Availability for PostgreSQL Clusters
Critical business applications require availability of their backend database cluster at all times. 2ndQuadrant provides enterprise-grade solutions for both Single Master and Multi-Master architectures. These solutions allow deployment of Highly Available PostgreSQL with Rolling Upgrades, Fast Failovers, Point-in-Time Recovery, and more.
The Single Master architecture provides High Availability of up to four 9s, while the 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.
High Availability Options
1. 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 geofencing capabilities. Based on ground-breaking BDR technology, it allows Advanced Clustering and Scaling of a database cluster as well as Automatic Conflict Resolution for DDL and DML replication.
Download Whitepaper: Multi-Master Replication in PostgreSQL
2. Highly Available PostgreSQL
Highly Available PostgreSQL clusters provide 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. Additionally, the Highly Available PostgreSQL cluster comes with a built-in backup strategy and recovery plan.
Download Whitepaper: Highly Available PostgreSQL
High Availability Features
Disaster Recovery to Ensure Continued Availability
To maximize the availability of business-critical solutions, a comprehensive Disaster Recovery Strategy is crucial. Planning for Disaster Recovery preempts data loss. Achieve your Recovery Time and Recovery Point Objectives with solutions built in to our High Availability architectures. Barman – Backup & Recovery Manager from 2ndQuadrant – is the best tool to ensure continued availability. Discover how Barman can help you secure your business critical PostgreSQL databases.
Rapid Switchover And Load Balancing
Load balancing is essential in achieving enterprise-grade High Availability with PostgreSQL. It ensures that no single node is overwhelmed with data traffic, resulting in optimal performance across all available nodes. Our AlwaysOn solution also provides the ability for Rapid Switchover by using load balancing tools to quickly promote a Shadow Node attached to a Master that may no longer be available.
Database Security
Hardening your database is essential in order to comply with regulations such as GDPR, PCI, and DSS. 2ndQuadrant provides high availability environments with protection against vulnerabilities, covering your PostgreSQL from operating system to schema level. The trusted architectures cover security aspects such as user management, network, data encryption, and more. A Security Audit by 2ndQuadrant will identify and address security threats to harden your PostgreSQL database and infrastructure.
24/7 Production Support
Database downtime can cost a business millions of dollars.. To minimize business risk and ensure peace of mind that if an issue arises it will be handled quickly, 2ndQuadrant provides 24/7 Production Support for its high availability architectures. Our world-renowned support is a cost-effective and scalable solution with a guaranteed response time of 15 minutes and bug fix of 24 hours. 2ndQuadrant provides different plans for 24/7 Production Support, all guaranteeing fast response and resolution times.
What Our Customers Say
“We can certainly attribute help in our growth to Postgres-BDR (high availability) since we now have consistent performance globally and are able to grow our business in multiple regions.”
– Alex Yurkowski, CTO, ClickUp
High Availability Knowledge Base
Whitepapers
Multi-Master Replication in PostgreSQL
A deeper look into the scenarios when designing an ‘Always On’ architecture for PostgreSQL in a business environment.
Highly Available PostgreSQL Whitepaper
This whitepaper discusses the scenarios when designing a high availability architecture for PostgreSQL, including failover and switchover.
Videos
‘Enhancing Postgres High Availability’ Webinar
Postgres High Availability is not just about putting together the right pieces. This webinar answers questions such as choosing HA components and what can go wrong, how to prevent edge cases and build a cluster that is “Always On” in the face of Network Partitions, Split Brain and other looming specters, and what role Multi Master can play.
‘Achieving High Availability with PostgreSQL’ Webinar
This webinar covers 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 and 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.
Books
PostgreSQL High Availability Cookbook – Second Edition
Master over 100 recipes to design, implement, and manage a highly available database with the advanced features of PostgreSQL. This book will teach you all the tips and tricks of creating high availability clusters that are robust, secure, scalable, and resistant to data-corruption.
How Tos
Automated rapid switchover with a BDR database cluster in Kubernetes
Explore this tutorial on how BDR and Kubernetes allow you to reach very high uptimes for a PostgreSQL database solution with rapid switchover capability.
How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
Learn how repmgr and the repmgrd daemon can automate High Availability and Failover of a three-node PostgreSQL12 cluster.
How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
See how a multi-node PostgreSQL cluster can be made to auto recover its High Availability after Failover.
High Availability Tools
Training
Replication, Backup & Disaster Recovery
This course covers the basics of replication, backup, and recovery through administration and application of design.
PostgreSQL Database Administration
This course covers the tasks that a database administrator faces daily, from basic operations to managing critical 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.
Webinar: Enhancing Postgres High Availability [Follow Up]
/0 Comments/in Webinars /by Adnan NazarPostgres High Availability is not just about putting together the right pieces. We should also consider the following: Why did we choose those components? What can go wrong? How do we prevent edge cases from ruining our day? Can we possibly build a cluster that is “Always On” in the face of Network Partitions, Split […]
Failover slots for PostgreSQL
/8 Comments/in Craig's PlanetPostgreSQL /by craig.ringerLogical decoding and logical replication is getting more attention in the PostgreSQL world. This means we need it working well alongside production HA systems – and it turns out there’s a problem there. Replication slots are not themselves synced to physical replicas so you can’t continue to use a slot after a master failure results […]
How to deploy a multi-master BDR cluster in Kubernetes
/0 Comments/in Cloud Native /by Gabriele BartoliniDiscover in this article and video how BDR can be easily and quickly deployed on Kubernetes thanks to our Cloud Native BDR Operator. BDR is a full mesh replication solution for PostgreSQL databases developed by 2ndQuadrant that provides both high availability and multi-master capabilities. It is now available for Kubernetes on Public and Private environments, thanks to 2ndQuadrant’s Cloud Native BDR Operator and […]