[Pacemaker] ocf:heartbeat:mysql RA: op monitor

[Dejan Muhamedagic]

Hi,

On Wed, Feb 10, 2010 at 04:19:41PM +0100, Oscar Remí­rez de Ganuza Satrústegui wrote:
> Hello list!
> 
> Lars Ellenberg escribió:
> >On Wed, Feb 10, 2010 at 10:31:52AM +0100, Oscar Remí­rez de Ganuza Satrústegui wrote:
> >
> >>So, the monitor operation is working ok if the mysql service is
> >>stopped (kill -KILL), but not if the service is "hung" (kill
> >>-SIGSTOP).
> >>And that even withouth defining the test_user on the mysql server.
> >>Very odd indeed.
> >
> >Not at all.
> >If you look at the script,
> >you will notice that for $OCF_CHECK_LEVEL = 0, a simple "exists a
> >process with that pid" check is made,
> >which of course is true for merely stopped processes.
> >
> >Only for OCF_CHECK_LEVEL != 0, the test query is done.
> >
> >
> I had no idea of the monitor's OCF_CHECK_LEVEL parameter.
> I think it is a really nice option being able of choosing different
> check levels for the monitor operation.
> 
> I have configured that option on my resources (1), and now it is
> checking the mysql service status using the SELECT!
> Everything is working as expected now!

Just note that although this is a general interface for more
thorough resource testing, only a small subset of resource agents
has such checks implemented.

Thanks,

Dejan

> Thank you very much for your invaluable help!
> 
> Regards,
> 
> (1) op monitor interval="30s" timeout="30s" OCF_CHECK_LEVEL="1" \
> 
> ---
> Oscar Remírez de Ganuza
> Servicios Informáticos
> Universidad de Navarra
> Ed. de Derecho, Campus Universitario
> 31080 Pamplona (Navarra), Spain
> tfno: +34 948 425600 Ext. 3130
> http://www.unav.es/SI
> 



> _______________________________________________
> Pacemaker mailing list
> Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker