On 04/03/2011 03:37, detorresrc wrote:
I'm playing with pgpoolII is this possible? Please see link at my subject area.
Thanks.
No, by loadbalancing at the first tier of Pgpool each of the lower
masters will receive only ~half the INSERT/UPDATE
So each of the lower groups will contain half a dataset.
To make this scenario work, you will need to have pgpool-II perform
parallel UPDATE/INSERT to each group (multi master mode)
and the lower groups will have single master & streaming replica slaves.
Why the extra level of indirection?
Rb
--
Rob Shepherd BEng PhD - Director / Senior Engineer - DataCymru Ltd
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
