[Dbix-class] Automatic reconnection to failed over database

Hailin Hu i at h2l.name
Mon Sep 3 15:01:46 GMT 2012

Does mysql_auto_reconnect not work?

On Thu, Aug 23, 2012 at 12:26 AM, Jorge Gonzalez
<jorge.gonzalez at daikon.es> wrote:
> Hi all,
> I am in the process of migrating several production apps using DBIx::Class
> to a clustered mysql database (HA).
> When my apps try to connect to the DB and can't, they fail (die, return
> errors, etc.). Since the cluster has a (very small) downtime during the
> failover process (node failure), I'd like that my apps just retried the
> connection in case it fails, stepping over the short downtime and
> reconnecting to the new cluster node which runs the DB after the failure.
> I have seen the DBIx::RetryOverDisconnects module and it seems it could
> serve the purpose, but I have googled and haven't seen any comments on using
> it on DBIx::Class models.
> Has anyone managed to integrate both modules (and use them!)? Or is there an
> easy way of doing what I want, that I'm missing?
> Thanks in advance
> BR
> J.
> _______________________________________________
> 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.scsys.co.uk

More information about the DBIx-Class mailing list