Lesson 0: PostgreSQL High Availability with Patroni & etcd
Complete course on deploying PostgreSQL High Availability clusters using Patroni and etcd with automated failover and monitoring.
#Database#PostgreSQL#High Availability
failover
Explore articles on failover
Lesson 1: Overview of PostgreSQL High Availability
Understanding the fundamentals of PostgreSQL High Availability, including why HA is critical, different HA methods, and comparing Patroni vs Repmgr vs Pacemaker solutions.
#Database#PostgreSQL#High Availability
Lesson 3: Introduction to Patroni and etcd
Understanding Patroni and etcd for PostgreSQL High Availability, including DCS, Raft consensus algorithm, leader election, and split-brain prevention mechanisms.
#Database#PostgreSQL#Patroni
Lesson 12: Patroni REST API
Learn about Lesson 12: Patroni REST API in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 13: Automatic Failover
Learn about Lesson 13: Automatic Failover in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 14: Planned Switchover
Learn about Lesson 14: Switchover - Planned Switchover in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 15: Recovering Failed Nodes
Learn about Lesson 15: Recovering Failed Nodes in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 19: Logging và Troubleshooting
Learn about Lesson 19: Logging và Troubleshooting in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 20: Security Best Practices
Learn about Lesson 20: Security Best Practices in PostgreSQL HA clusters with Patroni and etcd.
#Patroni#PostgreSQL#high availability
Lesson 9: Bootstrap PostgreSQL Cluster
Learn how to bootstrap a Patroni cluster including starting Patroni for the first time on 3 nodes, verifying cluster status with patronictl, checking replication, troubleshooting common issues, and testing basic failover.
#Patroni#bootstrap#cluster