[Dbix-class] master slave databases.

[Matt S Trout]

On Tue, Jun 03, 2008 at 06:49:59AM -0700, John Napiorkowski wrote:
> 
> 
> 
> --- On Tue, 6/3/08, Ian Docherty <dbix-class at iandocherty.com> wrote:
> 
> > From: Ian Docherty <dbix-class at iandocherty.com>
> > Subject: [Dbix-class] master slave databases.
> > To: "Class user and developer list" <dbix-class at lists.scsys.co.uk>
> > Date: Tuesday, June 3, 2008, 8:31 AM
> > Hi
> > How would one go about configuring DBIC to direct all
> > writes to a Master 
> > database and all reads from a Slave database?
> > 
> > I am aware of  DBIx::Class::Storage::DBI::Replication but
> > is it used by 
> > anyone in a production environment such that it would not
> > warrant the 
> > 'experimental' status?
> > 
> > Regards
> > Ian
> 
> There's a branch called "replication_redux" which is following trunk very closely and is a rewrite of the replication implementation.  We are using this (as of last Friday) on our production website and everything appears to be working correctly using mysql native replication.  Our site gets a lot of daily hits, so we feel it's shaping up solidly.
> 
> I'm writing up a more detailed overview for the mailing list, but wanted to get a few days in prod.   But if you need something like this I would enjoy collaboration and review.  Let us know more about what you are planning/needing.

How long do you need before this is ready now?

The previous vcersion of the code was already in production so there
shouldn't need to be -that- much rewriting to make it work, and 08100
should have shipped already and is being delayed for you.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/