On Wed, May 21, 2008 at 7:32 PM, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > personally, i think one should always architect applications with separate > DB handles for read/write/log/session at the outset. you can essentially > make them 'one' handle until necessary... but it takes barely any time to > program with that paradigm from the start... vs trying to retrofit in > clustering to an app when its too late.
The module I'm presenting at YAPC::NA and OSCON this year, DBIx::Router, will make it easier to add this kind of partitioning after the fact. It lets you set up rules to choose which database to send a query to. When I have a public prototype on CPAN, I'll announce it on this list and ask for testing help. - Perrin