Re: [monit] Testing mysql for more than connectivity?

[Martin Pala]

Hi,

monit's mysql protocol test can perform mysql ping. The usage is (for 
example):


  if failed port 3306 protocol mysql then alert


The "protocol mysql" option performs following test sequence:

1.) TCP connect to 3306
2.) if connect succeeded, perform anonymous login to mysql
3.) if login succeeded, perform mysql ping


Any response to mysql login (allow or deny) is handled as protocol 
success, since when the login was rejected, monit assumes that anonymous 
login is not allowed and since mysql responded, it's working.

The mysql ping is used only if anonymous login passed.


From praxis these tests are sufficient to see whether mysql responds to 
queries.



Martin




Phillip B Oldham wrote:
> We're finding problems with the way monit is bringing mysql back up 
> after restarting.
>
> Occasionally, our mysql server will hit >98% CPU time for a sustained 
> period. We have a rule in monit which will restart mysql after any odd 
> behaviour, and when this happens we find that occasionally mysql is 
> brought up and accepts connections but not queries.
>
> I'm wondering whether there's any way to test with monit that mysql is 
> executing queries properly? From the command-line I can execute the 
> following:
>
> mysql -e "show databases"
>
> which will return a result if mysql is ok, or will return a string 
> starting with "ERROR" if there's a problem.
>
> Based on this information, would it be possible to test if mysql is 
> accepting queries with monit?
> --
>
> *Phillip B Oldham*
> The Activity People
> address@hidden <mailto:address@hidden>
>
> ------------------------------------------------------------------------
>
> *Policies*
>
> This e-mail and its attachments are intended for the above named 
> recipient(s) only and may be confidential. If they have come to you in 
> error, please reply to this e-mail and highlight the error. No action 
> should be taken regarding content, nor must you copy or show them to anyone.
>
> This e-mail has been created in the knowledge that Internet e-mail is 
> not a 100% secure communications medium, and we have taken steps to 
> ensure that this e-mail and attachments are free from any virus. We must 
> advise that in keeping with good computing practice the recipient should 
> ensure they are completely virus free, and that you understand and 
> observe the lack of security when e-mailing us.
>
> ------------------------------------------------------------------------
>
> --
> To unsubscribe:
> http://lists.nongnu.org/mailman/listinfo/monit-general