Presented by:

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.

No video of the event yet, sorry!

Pgpool II performance and best practises Online training Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II is the middleware product that sits between the PostgreSQL server and database clients and is developed and maintained by a committed open source Postgres community that includes HighGo employees. The most widely used features in Pgpool-II are connection pooling, statement level load balancing, replication and a high availability (HA) feature known as watchdog, which provides automatic failover between pgpool instances. The newest version of Pgpool-II v4.1, beta for pgpool II 4.1 was released recently. Pgpool is almost as old as PostgreSQL itself, and often when somebody was talking about PostgreSQL cluster, they were referring to PostgreSQL behind Pgpool and not to the PostgreSQL instance itself. Although the name may suggest as if Pgpool is just a connection pooling solution, but in actual Pgpool is a lot more than just a pooler and provides so many amazing features especially when it comes we require scalability and high availability of a PostgreSQL

The tutorial aims to provide the overview and best practices of using Pgpool-II. Join this tutotial to find out the exciting features added in pgpool II in last set of major releases. One of the main goal of pgpool II is to provide performance with read scalability, find out how to setup and configure pgpool II optimally to get he best performance. Tentative schedule: Introduction Overview of Pgpool-II and where it fits in. Options and features of Pgpool-II Load balancing and performance expectations High availability Pgpool-II in cloud How to get best performance out of pgpool II pgpool II features in last few major releases How to setup and configure pgpool II Trouble shooting with pgpool.

3 h 30 min
Postgres Digital Training Series
Requires Registration:
Yes (Registered: 4/40)