PostgreSQL High Availability Options
Yugabyte Yugabyte
3.88K subscribers
6,146 views
110

 Published On Jun 12, 2023

Let’s review several popular solutions that increase the high availability of PostgreSQL deployments and, as a result, the overall application. It is shown how to approach the high availability for the following four PostgreSQL deployment scenarios:
1. Single primary database instance
2. Single primary database instance with read replicas
3. Multi-master deployment (sharded PostgreSQL with a coordinator, e.g. CitusData)
4. Multi-master (sharded PostgreSQL without the coordinator, e.g. YugabyteDB)

To learn more, read our guide to PostgreSQL high availability options: https://www.yugabyte.com/postgresql/p...

0:00 - Intro
0:31 - Widespread PostgreSQL deployment options
1:38 - High availability (HA) vs. disaster recovery
2:23 - HA with a single PostgreSQL database instance
6:34 - HA with a single primary instance and read replicas
8:04 - Sharding and horizontal scalability
9:06 - HA with multi-master deployments with coordinator (e.g. CitusData)
12:40 - HA for multi-master deployments without coordinator (e.g. YugabyteDB)
16:08 - Summary

RESOURCES:
-YugabyteDB / Start Now: https://cloud.yugabyte.com
-Site: https://www.yugabyte.com
-GitHub: https://github.com/yugabyte

COMMUNITY:
-Slack: https://communityinviter.com/apps/yug...
-YouTube:    / yugabyte  
-Instagram:   / yugabytedb  
-Twitter:   / yugabyte  
-LinkedIn:   / yugabyte  

You can connect to all our community channels here: https://linktr.ee/yugabyte

show more

Share/Embed