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