[Pgpool-general] multiple slaves
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Mar 1 07:46:24 GMT 2006
> 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
More information about the Pgpool-general
mailing list