Re: Postgres 9.0 Streaming Replication and Load Balancing?

Unsure you can achieve this without a read only and a read write
application set up, I've always had RW application servers separate
from RO ones.

You could disable the application connection pool completely and let
pg-pool do the pooling for you (not sure of performance impact, if
any) as the session needs to be terminated after an insert for pg-pool
to load balance correctly (see
http://www.pgpool.net/mediawiki/index.php/FAQ, 5th one down for more
details).

- Sumit

On 16 May 2012 16:34, Paulo Correia <paulo(dot)correia(at)pdmfc(dot)com> wrote:
> Hello Sumit,
>
> At the given point there are no exceptions since the tests for using
> pgPool-II with the application using a master and a slave resulted in all
> connections being done on the master and none on the slave.
>
> As the application as it's own connection pool, eventually all connections
> will have a RW operation and as so all these connections will be linked to
> the master.
>
> As so, I cannot benefit from load balancing since all my connections will be
> redirected to the master by pgPool-II, even if they are RO.
>
> Is it possible to have pgPool-II making only load balance with no connection
> pool?
>
> Best regards,
> Paulo Correia
>
> On 15/05/12 09:01, Sumit Raja wrote:
>>
>> On 14 May 2012 17:28, Paulo Correia<paulo(dot)correia(at)pdmfc(dot)com>  wrote:
>>>
>>> Hello all!
>>> Having a Postgres 9.0 with assynchronous streaming replication to a
>>> hot-standby slave, both with CentOs 5.6, how can I use both DB instances
>>> for
>>> query load balancing?
>>> I've tried with pgPool-II but the pooling mechanism is disruptive with
>>> the
>>> existing pool on the application servers.
>>
>> Is the application RW or read only? What is the disruption being
>> caused? Are you seeing specific exceptions?
>>
>> - Sumit
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Raja Consulting Ltd.
Incorporated in England and Wales No. 06454814,  Registered Office: 4
Calder Court, Shorebury Point, Amy Johnson Way, Blackpool FY4 2RH