On 07/18/2012 03:24 PM, DENNY, MICHAEL wrote: > Our current monitor action tests the availability of the mysql database. > However, the monitor fails if mysql is doing recovery processing. And the > recovery processing can take a long time. Do you know if there is a way to > programmatically determine if mysql is in recovery mode (and is processing > the log entries)? or some existing utility prog that can report that mysql > is started but in recovery mode? I want to update the monitor action to > succeed if in recovery mode. > > Backgrounder: > - We using mysql on Ubuntu servers using heartbeat/pacemaker in an > Active/Passive redundant pair configuration. > - When simulating failover, we have observed that the start action on the new > server will succeed, exit almost immediately, although mysql has actually > begun recovery processing and subsequent "service mysql status" reports that > it is not available for use. > - Our current monitor action fails if mysql is not available for use. >
You are using the LSB script of mysql? The mysql OCF resource agent returns on start only after recovery is finished ... so be sure to define a generous start timeout. Regards, Andreas -- Need help with Pacemaker? http://www.hastexo.com/now > Thanks for the help, > > mike > > > _______________________________________________ > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
