clrrsnd at gmail
Oct 15, 2011, 10:42 AM
Post #5 of 13
On Sat, Oct 15, 2011 at 2:54 PM, Oleg Kostyuk <cub.uanic [at] gmail> wrote:
> 2011/10/13 clara resende <clrrsnd [at] gmail>:
> > On Thu, Oct 13, 2011 at 4:31 PM, Peter Edwards <peter [at] dragonstaff>
> > wrote:
> >> >I need to be able to failover between two database backends.
> >> If you are using DBIx::Class it will reconnect stale database handles,
> >> as long as your failover uses the same DSN hostname it should just work.
> > That would be nice, but unfortunately it does not work like that over
> Why? Impropely configured DNS?
> > (and I cannot do anything about that).
> It's not true. Even if your DNS server working not as you need - you
> always can setup your own local BIND, configure it to use round-robin,
> configure new zone in it, add all your database hosts under same
> hostname, and everything will be fine. But I think such details are
> out of scope this mailing list.
I'm a mere appplication developer, I don't even have access to the
production boxes (unfortunately ...).
> >>> The DBIx::HA seems to be the right tool to that, but how to use it with
> >>> Catalyst?
> >> You can use any database backend you like with Catalyst, check out the
> >> Model configuration part of the Catalyst manual.
> >> That particular module needs Apache::DBI so won't be compatible with
> >> DBIx::Class though.
> > Isn't there another way achieve this, with DBIx-Class, similar to what
> > HA module does?
> May be, DBIx::Class::Storage::DBI::Replicated ?...
That looks promising, thanks for the suggestion.