O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Load balancing with pgpool-II 3.0

Pgpool-II is middleware that can perform the following major functions:

  • Connection pooling
  • Load balancing
  • Replication management
  • Parallel query

The only aspect of pgpool we cover here is load-balancing mode, which is designed to work with the other forms of replication discussed in this chapter. Pgpool is actively developed and contains many new features for PostgreSQL 9.0. Load balancing mode allows an application to connect to pgpool once, and then spread certain kinds of work across multiple nodes. As a result, it is possible to use pgpool with an existing application with minimal changes. There are other ways of load balancing across multiple servers, though those utilize features of non-PostgreSQL related software, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required