logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: Replication: msg#00146

Subject: Re: Replication
On 10/24/07, Frank Speiser <frank@xxxxxxxxxx> 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


Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>