Monit MySQL and ssh on AWS

[Stanislav Pogrebnyak]

Hi!

I'm using monit 5.0.3 on Ubuntu 10.04 LTS on aws EC2 extra large
memory instance, for monitoring everal services, besides them are sshd
and mysql.

Here are my configs for those:

check process mysql with pidfile /var/run/mysqld/mysqld.pid
   group database
   start program = "/etc/init.d/mysql start"
   stop program = "/etc/init.d/mysql stop"
   if failed host 127.0.0.1 port *port*protocol mysql then alert
   #f 5 restarts within 5 cycles then timeout

check process sshd with pidfile /var/run/sshd.pid
start program "/etc/init.d/ssh start"
stop program "/etc/init.d/ssh stop"
if failed port *port* protocol ssh then restarts
if 5 restarts within 5 cycles then timeout

those *port*s are approriated ports of the services TCP/IP protocols

Any way the issue is that some times once a day or some times a few
times a day monit reports me an tcp checks errors, With munin netstats
i c that for a some reasons conncetions was reseted. First i was
thinking about huge load to services, changed ports and configured
some firewals and started to monitoring ports usage, but it seems not
the case, since nothing changed. Next i thought that its hardware
problems, but as u can see checks are over localhost, those should go
ok.

In general errors messages looks like:

Connection failed Service mysql

       Date:        Mon, 23 May 2011 09:04:43 +0000
       Action:      alert
       Host:        *host*
       Description: failed protocol test [MYSQL] at INET[127.0.0.1:3306] via TCP

Your faithful employee,
monit

And in 2 mins (next checks i suppose):

Connection succeeded Service mysql

       Date:        Mon, 23 May 2011 09:06:51 +0000
       Action:      alert
       Host:        *host*
       Description: connection succeeded to INET[127.0.0.1:3306] via TCP

Your faithful employee,
monit


Does any one got those errors as well? Its quite annoying since i'm
using monit for monitoring other services on other instances as well
and it works perfect.

Thnx.

wbr, Stanislav O. Pogrebnyak
------------------------------------------
ICQ: 242-267-649
Skype: stanislav.o.pogrebnyak
cell-phone: +380663966659