Re: Question about load balance

Am 08.06.2012 00:39, schrieb Craig Ringer:

On 06/07/2012 10:26 PM, Condor wrote:

Hello ppl,

I read in internet and in this mailing list, when some one asking about load balance,
most of the answers is: pgpool.
I want to asking how stable is pgpool ? How much query can handle ? What load average ?
Im looking for something multi master solution.

PgPool-II doesn't offer mutli-master operation. Not much does.

Multi-master is very difficult to get right, and even harder to make fast.

Are you really sure it's what you want? Failover is often a much, MUCH simpler and more efficient approach.

--
Craig Ringer

The only multimaster replication solution for PostgreSQL I know of, is Bucardo.
http://bucardo.org/wiki/Bucardo
Though I second what Craig Ringer wisely says; it's difficult to get it right and fast.
Best Regards.

http://pglearn.blogspot.mx/
twitter: @sqlhotfix