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
etcd
Explore articles on etcd
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
Series
PostgreSQL HA Cluster - Monitoring Stack
Full monitoring stack with Prometheus and Grafana for PostgreSQL HA cluster. Includes pre-configured dashboards, alerting rules, and exporter configurations.
#Database#PostgreSQL#Monitoring
Series
PostgreSQL Security Hardening Guide
Essential security features and hardening measures for PostgreSQL HA cluster deployment with Patroni, etcd, and PgBouncer. Follow this guide for production security best practices.
#Database#PostgreSQL#Security
Series
Automating PostgreSQL High Availability with Ansible, Patroni, and etcd
Learn how to deploy a production-ready PostgreSQL High Availability cluster using Patroni and etcd with fully automated Ansible playbooks for seamless failover and connection pooling.
#Database#PostgreSQL#High Availability
Lesson 6: Installing and Configuring etcd Cluster
Learn how to install and configure etcd cluster for use with Patroni, including understanding etcd's role in Patroni architecture, setting up 3-node cluster with Raft consensus, creating systemd services, and testing cluster health.
#etcd#Raft#DCS
Lesson 7: Installing Patroni
Learn how to install Patroni, including setting up Python dependencies, installing via pip, understanding the patroni.yml configuration structure, creating systemd service, and configuring Patroni on 3 nodes for PostgreSQL high availability.
#Patroni#installation#configuration