http://search.cpan.org/~capttofu/DBD-mysql-4.022/lib/DBD/mysql.pm#DATABASE_HANDLES Does mysql_auto_reconnect not work?
On Thu, Aug 23, 2012 at 12:26 AM, Jorge Gonzalez <jorge.gonza...@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 _______________________________________________ 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