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

From Condor
Subject Re: Question about load balance
Date
Msg-id be5957e285d066b2113534c4dc8dbe5b@stz-bg.com
Whole thread Raw
In response to Re: Question about load balance  (Craig Ringer <ringerc@ringerc.id.au>)
Responses Re: Question about load balance  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 2012-06-08 08:39, Craig Ringer wrote:
> 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

No,
Im not sure, just looking how to make load balance. I have a small
database around 20 gb,
but I expect to join another database on different scheme and Im
looking for solution
about load balance or some cache mechanism. Bad part is one row from db
is read once
in a month, in worst scenario 3-4 times in month and I think cache is
not good option,
but I don't have idea how will work.


H.

pgsql-general by date:

Previous
From: Benson Jin
Date:
Subject: Segmentation Fault
Next
From: John R Pierce
Date:
Subject: Re: Question about load balance