PgPool II Performance and best practices

Описание: 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.