[Pacemaker] mysql resource agent

[Andreas Kurz]

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 at 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
> 





-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 222 bytes
Desc: OpenPGP digital signature
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120720/0897ebd9/attachment-0003.sig>