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.correia@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
