[Dbix-class] Replication

[Brandon Black]

On 10/24/07, Jim Spath <jspath at pangeamedia.com> 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