[Dbix-class] Replication

[Cory Watson]

On 10/24/07, Frank Speiser <frank at takkle.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20071024/d3e=
2ca07/attachment.htm