On 10/24/07, Frank Speiser <[EMAIL PROTECTED]> wrote: > > How would I go about directing slow reads to one server, writes to the > master and fast-reads to the master as well? > > Is there something in DBIC that can work like this, or do we have to go > one level up to the app to solve it? >
Assuming you are using catalyst... Since Model::DBIC::Schema allows you to setup multiple schemas, couldn't you just wrap the use of $c->model() to specify different schemas? Then you could implement a $c->rw_model() or a $c->ro_model() or something of that nature. Might not be as fancy as the stuff being discussed, but it's a simple solution. :/ -- Cory 'G' Watson http://www.onemogin.com
_______________________________________________ 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]
