[Catalyst] DBIx::HA

[clara resende]

On Sat, Oct 15, 2011 at 2:54 PM, Oleg Kostyuk <cub.uanic at gmail.com> wrote:

> 2011/10/13 clara resende <clrrsnd at gmail.com>:
> >
> >
> > On Thu, Oct 13, 2011 at 4:31 PM, Peter Edwards <peter at dragonstaff.co.uk>
> > wrote:
> >>
> >> >I need to be able to failover between two database backends.
> >> If you are using DBIx::Class it will reconnect stale database handles,
> so
> >> as long as your failover uses the same DSN hostname it should just wor=
k.
> >
> > That would be nice, but unfortunately it does not work like that over
> here
> 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 wi=
th
> >>> 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
> the
> > HA module does?
>
> May be, DBIx::Class::Storage::DBI::Replicated ?...
>
>
That looks promising, thanks for the suggestion.

Meindert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20111015/e2b5c=
38e/attachment.htm