Martin, if the anonymous login is password protected, is there anyway to
specify that in monit config for mysql ?
On Fri, Jun 6, 2008 at 12:54 PM, Martin Pala <address@hidden
<mailto:address@hidden>> wrote:
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>
<mailto: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
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
------------------------------------------------------------------------
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general