[Dbix-class] master slave databases.

[John Napiorkowski]

--- 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.

--John Napiorkowki


> 
> _______________________________________________
> 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/dbix-class@lists.rawmode.org