On 10/24/07, Jim Spath <[EMAIL PROTECTED]> wrote: > What is the current state of replicated database support in DBIx::Class? > > We are considering creating a master/slave setup with our MySQL > database, but weren't sure if it would be easy to support it in our > Catalyst/DBIx::Class applications. > > From previous discussions on the list, it seems like DBD::MultiPlex is > out of favor? > > I searched CPAN and found DBIx::Class::Storage::DBI::Replication, which > utilizes DBD::Multi. It's labeled as experimental, which makes me > nervous about using it in a production enviroment, but it sounds like > exactly what I am looking for. Is it stable? > > There must be DBIx::Class users who are setup and running a replicated > database. What solutions have you come up with? >
I'm not sure what the state of the explicit support is (like DBD::Multi/DBD::MultiPlex). I'm assuming what you want to do is send reads to the slave and writes to the master? If so, something of this nature will be required. Of course, if you don't need to send reads to the slave for performance reasons, you can just send everything to the master, and use the slave separately as your backup / data warehouse. Some people do failover between the two as well, with the slave being promoted to master on master failure. By adding a virtual floating IP (via "heartbeat" in the case of linux) you can again solve that problem with a single normal connection from DBIC. It's only the read-balancing (or even write-balancing in the case of multi-master) that needs some special support in DBIC. -- Brandon _______________________________________________ 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]
