PostgreSQL Connection Pooling: Part 3 – Pgpool-II
Scalegrid
MARCH 23, 2020
In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative – Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware. It supports high-availability, provides automated load balancing, and has the intelligence to balance load between masters and slaves so write loads are always directed at masters, while read loads are directed to slaves.
Let's personalize your content