Another option is to handle this at the db layer using something like sqlrelay. I haven't used it personally but have heard some good thing about it from others. You can set it up to filter queries between different sets of database hosts: http://sqlrelay.sourceforge.net/sqlrelay/router.html
-- -Scott McWhirter- | -Technology Consultant- [ Cloudtone Studios - http://www.cloudtone.ca ] On Sun, Oct 4, 2009 at 04:19, Chris Grafham <[email protected]> wrote: > > > Im looking for some advice for best practice for the following situation - > > > 1. HTTP Request arrives. > 2. Determine if a database connection is required for either a MySQL > read-only slave or write master (via a piece of custom code based on request > URL). > 3. Connect to chosen database ($schema->connect). > 4. Disconnect at end of request (no persistent db connections). > > Thanks in advance. > > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > >
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
