Scaling Beyond Pg-Bouncer & Pg-Pool-II: Advanced Traffic Management

Improve Postgres Scale with Database Proxies

Presented by:

09521f51a53a7883f66bd0332d577579

Erik Brandsberg

Heimdall Data, Inc.

Erik Brandsberg is CTO at Heimdall Data. He specializes in application-networking technologies for web and backend data. Whether it's coding, testing or installing, he has been involved. His diverse experience at Alteon, Citrix, and Juniper Networks gave him a solid understanding of operational complexities in a modern infrastructure, which led to the founding of Heimdall Data.

Database proxies intelligently manage Postgres connections to improve performance and scale. In this session, we will highlight deficiencies of Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include:

  • Connection pooling
  • Read/write split with Strong Consistency
  • Query caching
  • Persisted connection, automated Postgres failover
  • Active Directory / LDAP integration

Includes live demo and Q&A

Date:
2021 March 30 13:00 EDT
Duration:
1 h
Room:
Online
Conference:
2021 Postgres Conference Webinars
Language:
Track:
Ops
Difficulty:
Easy
Requires Registration:
Yes (Registered: 92)