Re: Question about load balance - Mailing list pgsql-general

From René Romero Benavides
Subject Re: Question about load balance
Date
Msg-id 4FD22281.6070209@gmail.com
Whole thread Raw
In response to Re: Question about load balance  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Marc Watson"
Date:
Subject: Re: Postgres 9.2 beta2 one-click installer on windows
Next
From: Keith Fiske
Date:
Subject: Extension table data