Scaling Postgres Beyond PostgreSQL PgBouncer & Postgres Pgpool-II: Advanced Traffic Management (2021)

On Friday, May 07th, 2021 Erik Brandsberg of Heimdall Data delivered the presentation entitled: “Scaling Beyond PostgreSQL PgBouncer and Postgres Pgpool-II: Advanced Traffic Management” — the description follows from below.

Database proxies intelligently manage database connections to improve performance and scale. In this session, we will highlight deficiencies of open-source PgBouncer and Pgpool-II that users should know, and propose solutions.

Scaling Postgres features to be discussed

The following list covers some of the topics that were discussed in this presentation and which are important when it comes to scaling the Postgres relational database:

  • PostgreSQL connection pooling

  • PostgreSQL read/write splitting with Strong Consistency

  • PostgreSQL query caching

  • Persisted connection and PostgreSQL automatic failover

  • Active Directory / LDAP integration

This Heimdall Data Technical Session presentation includes a live demo and Q&A section and is delivered by Erik Brandsberg, Chief Technical Officer of Heimdall Data.

Scaling Postgres Webinar References

  1. Thomas P. Fuller on LinkedIn
  2. Heimdall Data
  3. Heimdall Data on Twitter
  4. Erik Brandsberg on LinkedIn
  5. Roland Lee on LinkedIn
  6. Demo Friday: Erik Brandsberg will review the Heimdall Distributed Database Proxy (2020)
  7. Hidden Gems: Event-Driven Change Notifications in Relational Databases
Tags: , , , ,

thospfuller

I am a Technical SEO Consultant and WordPress Specialist based in Northern Virginia. I am interested in software development, content engineering, and business. I'm originally from Chicago, IL, and currently reside in Reston, VA.