[Pgpool-general] multiple slaves

[Tatsuo Ishii]

> Hello,
> 
> This is what I'm trying to accomplish:
> 
> - Replication with Slony-I: single master, multiple slaves.
> - Connection caching, pooling and load balancing with pgpool.
> 
> I've picked pgpool as the load balancing solution mainly for one  
> reason: it says in the docs that in master/slave mode writes/updates  
> go to the master and selects go to the slaves. This is very important  
> to me because I don't want to have to modify my application to make  
> it aware of the difference between master db and slaves.
> 
> My questions is this: how do I configure pgpool to make it aware that  
> I have multiple slaves?
> 
> This is not very well documented so any help with this will be  
> greatly appreciated.

Single pgpool installation handles up to 1 slave. To handle multiple
slaves, you need to "cascading" pgpool.

pgpool(1) -+-> master
           |
           +-> pgpool(2) -+-> slave(1)
                          |
                          +-> slave(2)

Applications connect to pgpool(1). pgpool(2) could operate in either
master/slave mode or replication mode.
--
Tatsuo Ishii
SRA OSS, Inc. Japan