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 [email protected]
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
