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
patroni
Explore articles on patroni
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 10: Replication Management
Learn how to manage PostgreSQL replication in a Patroni cluster including synchronous vs asynchronous replication, monitoring replication lag, configuring replication settings, and handling replication issues.
#PostgreSQL#replication#synchronous
Lesson 16: Backup and Point-in-Time Recovery PITR
Comprehensive guide to PostgreSQL backup strategies, WAL archiving, and Point-in-Time Recovery PITR with Patroni.
#PostgreSQL#Backup#PITR
Lesson 17: Monitoring Patroni Cluster
Setting up a comprehensive monitoring stack for PostgreSQL and Patroni using Prometheus, Grafana, and Alertmanager.
#PostgreSQL#Monitoring#Prometheus
Lesson 22: Patroni on Kubernetes
Deploying and managing Patroni High Availability clusters on Kubernetes using StatefulSets and Operators.
#PostgreSQL#Kubernetes#Patroni
Lesson 23: Patroni Configuration Management
Mastering dynamic configuration management for Patroni clusters, including zero-downtime updates and DCS storage.
#PostgreSQL#Patroni#Configuration
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 4: Infrastructure Preparation for PostgreSQL HA
Setting up the infrastructure for PostgreSQL High Availability with Patroni and etcd, including hardware requirements, network configuration, firewall, SSH keys, and time synchronization.
#Database#PostgreSQL#Infrastructure
Building a Highly Available PostgreSQL Cluster with Patroni, etcd, and PgBouncer
Running PostgreSQL in production isn't just about having a single server — it's about High Availability (HA), Automatic Failover, and Connection Pooling. With the right setup, you can ensure your databases survive node failures without downtime.
#Database#PostgreSQL#Highly Available
Page 1 of 3