Scaling 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 presentation 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. Features to be discussed include: * Connection pooling * Read / write split with Strong Consistency * SQL Query caching * Persisted connection and automated postgressql failover * Active Directory / LDAP integration Includes a live demo and Q&A section. This Heimdall Data Technical Session is delivered by Erik Brandsberg, Chief Technical Officer of Heimdall Data -- learn more and connect with Erik on LinkedIn: https://www.linkedin.com/in/erikbrandsberg/ Learn more about Heimdall Data here: https://www.heimdalldata.com/ ----- Consider also joining the Washington DC Metro Area Chief Technical Officer Group: - Meetup: https://www.meetup.com/Washington-DC-CTO-Meetup-Group/ - LinkedIn: https://www.linkedin.com/groups/12301178/ - Slack: https://coherentlogic.com/for-ctos/dc-cto-slack-group-signup-form References * Thomas P. Fuller on LinkedIn, https://www.linkedin.com/in/thomasfuller/ * Heimdall #Data, https://www.heimdalldata.com/ * Heimdall Data on Twitter, https://twitter.com/heimdalldata * Erik Brandsberg on LinkedIn, https://www.linkedin.com/in/erikbrandsberg/ * Roland Lee on LinkedIn, https://www.linkedin.com/in/leeroland/ * Demo Friday: Erik Brandsberg will review the Heimdall Distributed Database Proxy (2020), https://www.youtube.com/watch?v=w5xDpAtJMvc Hidden Gems: Event-Driven Change Notifications in Relational Databases, https://thospfuller.com/2020/09/18/event-driven-change-notifications-relational-databases/