Achieving High Availability (HA) in PostgreSQL: Strategies, Tools, and Best Practices
Presented by:
Ibrar Ahmed
Ibrar Ahmed, Principal Engineer at pgEdge, brings 25 years of experience in software design and open-source development, particularly PostgreSQL. With a strong background in system-level embedded development, Ibrar has made impactful contributions during his tenure at companies like EnterpriseDB, Percona, and Bitnine. Since 2006, he's been instrumental in enhancing PostgreSQL's core engine, driving performance improvements, and refining essential modules.
His expertise spans MySQL, Oracle, and NoSQL solutions like MongoDB and Hadoop, alongside tools like Hive, HBase, and Spark. A prolific author and blogger, Ibrar shares deep insights into PostgreSQL with several authoritative books. Over the past year, he’s delivered over fifteen talks worldwide at PostgreSQL conferences, further cementing his reputation. His dedication to advancing data management technology continues to shape
In the continuously evolving landscape of digital enterprises, ensuring uninterrupted service and data availability is not just a luxury, but a mandate. PostgreSQL, celebrated for its robustness and flexibility, offers myriad ways to implement High Availability (HA) and fault tolerance. However, with options comes complexity. This talk aims to demystify HA for PostgreSQL, guiding attendees through its intricate pathways.
Key Takeaways:
Introduction to HA: A concise introduction to what High Availability means in the context of PostgreSQL. We’ll cover its importance, challenges, and the primary objectives one should aim for when configuring an HA system.
Architectural Foundations: An exploration of the foundational concepts underlying HA in PostgreSQL, including replication techniques, failover strategies, and connection pooling.
Dive into Tools & Solutions: A deep dive into the tools and solutions that make HA possible in PostgreSQL: Physical Replication: Streaming Replication and WAL Shipping. Logical Replication: Understand its benefits and use-cases. External Tools: Dive into tools like Patroni, Pgpool-II, and Stolon, and evaluate their features, advantages, and ideal scenarios of application.
Failover and Switchover Mechanisms: Delve into the mechanisms that ensure seamless transition during unplanned outages and planned maintenance events, ensuring minimal service disruption.
Monitoring and Maintenance: Unpack the essentials of monitoring HA setups, detecting potential issues before they escalate, and the routine maintenance practices that ensure long-term stability.
Case Studies: Real-world scenarios illustrating the challenges faced and solutions employed by enterprises to ensure HA in their PostgreSQL setups. Join us for a comprehensive journey into the world of High Availability in PostgreSQL. Whether you're a database novice striving for uninterrupted services or an experienced professional aiming for perfection, this session will offer a combination of theoretical foundations, practical insights, and industry best practices.
- Date:
- 2024 April 17 16:10 PDT
- Duration:
- 50 min
- Room:
- San Pedro
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Ops
- Difficulty:
- Intermediate