I have written a tutorial to pgpool-II using PostgreSQL 9.0's streaming replication. The tutorial is designed to use minimum resource: a Linux box. On the box, pgpool-II, pgpoolAdmin(a PHP based pgpool-II GUI admin tool) and two PostgreSQL 9.0 instances.
Though the tutorial system is surprisingly simple, you could learn:
- How pgpool-II detects PostgreSQL failure and automatically promote a standby server to primary server
- How pgpool-II re-sync the failed node by using "online recovery" capability
Please enjoy!
Subscribe to:
Posts (Atom)
Dynamic spare process management in Pgpool-II
Pre-fork architecture in Pgpool-II Pgpool-II uses fixed number of pre-forked child process which is responsible for accepting and handling e...
-
There are several timeout parameters in Pgpool-II. In this blog I will explain those parameters used for connection management. Below is...
-
Recently I got questions on pgpool-II's health check parameters. In this article I will try to explain them. "Health check" ...