[Dbix-class] Stick to single slave with Replicated? Anyone using PgBouncer?

[Bill Moseley]

I have a master and two slaves configured.  Each web server process then has
three database connections.

I've been asked if it possible to make Replicated randomly pick one of the
slave and only connect to that one slave.  The idea is that *about* 1/2 the
web server processes would use one slave and 1/2 the other to reduce number
of connections total on the slaves.

The plan now is to put PgBouncer for connection pooling in front of the
actual slaves and master.  Anyone using PgBouncer with DBIC?

Also, does/will Replicated notice (say by a ping) if a slave is unavailable
and take it out of the pool?



-- =

Bill Moseley
moseley at hank.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20101005/6d0=
80b5a/attachment.htm