PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II lately....
Muhammad Usama is a database architect / PostgreSQL consultant at HighGo Software and also Pgpool-II core committer. Usama has been involved with database development (PostgreSQL) since 2006, he is the core committer for open source middleware project Pgpool-II and has played a pivotal role in driving and enhancing the product. Prior to coming to open source development, Usama was doing software design and development with the main focus on system-level embedded development. After joining the EnterpriseDB, an Enterprise PostgreSQL’s company in 2006 he started his career in open source development specifically in PostgreSQL and Pgpool-II. He is a major contributor to the Pgpool-II project and has contributed to many performance and high availability related features.
Ahsan Hadi is a VP of Development with HighGo Software Inc. Prior to HighGo Software, Ahsan had worked at EnterpriseDB as a Senior Director of Product Development, Ahsan worked with EDB for 15 years. Ahsan has vast experience with Postgres and has lead the development team at EDB for building Oracle compatible layer for EDB's Postgres Advanced server. Ahsan has also spent number of years working with development team for adding Horizontal scalability and sharding to Postgres.
Prior to EDB, Ahsan worked for Fusion Tech as a Senior Project Manager. Ahsan lead the team that developed java based job factory responsible for placing items on shelfs at big stores. Prior to Fusion, Ahsan worked at British Telecom as a Analyst/Programmer and developed web based database application.
Ahsan joined HighGo Software Inc in April 2019 and is leading the development teams based in multiple Geo’s, the primary responsibility is community based Postgres development and also developing HighGo Postgres server.
No video of the event yet, sorry!
Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down.
This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This watchdog feature has been around for a while but it went through major overhauling and enhancements in recent releases. This talk aims to explain the watchdog feature, the recent enhancements went into the watchdog and describe how it can be used to provide PostgreSQL HA and automatic failover.
Finally we will summarise the major features that have been added in the recent major release of Pgpool-II and whats in the pipeline for the next major release.
- 2019 July 5 14:50 CST
- 40 min
- JINGGE HALL TRACK1 - English Track
- Beijing 2019
- English Speaker Track