Войти
  • 273Просмотров
  • 4 месяца назадОпубликованоAcademia DBA

Learn how to set up high availability with PostgreSQL using the powerful Patroni orchestrator

In this 100% hands-on course, you will learn how to set up high availability with PostgreSQL using the powerful Patroni orchestrator, in a modern and professional Linux environment. If you want to ensure your PostgreSQL databases remain available even in the event of failures, this course is for you. Throughout the lessons, we’ll build a fully functional and robust cluster together, using: PostgreSQL — the most advanced open-source database on the market Patroni — the orchestration tool that manages automatic failover and replication ETCD — the distributed configuration store that ensures cluster-wide consensus HAProxy — the load balancer that automatically routes connections to the primary node Keepalived — used to set up a floating virtual IP to guarantee continuous access You will learn: What quorum is and how it works in a cluster How to avoid issues like split-brain How to perform both automatic and manual failover safely How to monitor the cluster and maintain data integrity How to simulate real-world failure and recovery scenarios Best practices for production environments This course is ideal for DBAs, DevOps engineers, SREs, and Linux administrators who want to take their PostgreSQL infrastructure to the next level. Enjoy the course, everyone! Prof. Sandro Servino super coupon: