Today, I’d like to cover pooler high availability as this is one aspect of connection pooling I’ve never focused on. Due in large part because my previous attempts were based on PgBouncer, and it standing up PgBouncer is not easy. Luckily, it’s been an absolute pleasure working with PgCat as it has a lightweight installation process.

High-Level Steps

Start CockroachDB, PgCat, and HAProxy in Docker
Run a workload
Demonstrate fault tolerance
Conclusion

Step-By-Step Instructions

Start CockroachDB, PgCat, and HAProxy in Docker

I have a Docker Compose environment with all of the necessary services here. Primarily, we have to set up two instances of PgCat.

Leave a Reply

Your email address will not be published. Required fields are marked *