[Pgpool-general] Replication Mode and Sequences
Jaume Sabater
jsabater at linuxsilo.net
Fri Nov 21 09:06:41 UTC 2008
----- "Tatsuo Ishii" <ishii at sraoss.co.jp> escribió:
> > pgpool-II won't do load balance when there are select and
> insert/update/delete statements in the same transaction. Instead, it
> will execute all queries against the master node and the
> insert/update/delete ones against the slave node only.
>
> No. When a client connects to pgpool-II, pgpool-II will select
> randomly one of the nodes for load balance. If the client start a
> transaction, pgpool-II sends "BEGIN" to all nodes. and if the client
> sends some DML, it will sends to all nodes as well. If the client
> then
> sends "load-balance possible"(see the attached diagram) SELECT, it
> will be sent to the node which pgpool-II chooses at the connection
> time.
I had understood from the documentation that it would always be the master node. Thanks for the clarification, Tatsuo.
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
More information about the Pgpool-general
mailing list