Date: 2022-05-26
Time: 13:00–13:45
Room: Stream 2
Level: Intermediate
Pgpool-II has been around to complement PostgreSQL for over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise applications, the clients need the ability to automatically reconnect with a secondary node when the primary node goes down.
This is where the Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while, but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements that went into the watchdog, and describe how it can be used to provide PostgreSQL HA and automatic failover.
Finally, I will summarize the major features that have been added in the recent major release of Pgpool-II and what's in the pipeline for the next major release.