In this example, we add the plugin to check MySQL replication status [source]
This is the method that worked for me.
Assuming we are running Slackware, do the following;
NOTE: We can run the command from the command line as below;
./check_mysql_slavestatus.sh -H 23.128.29.24 -P 3306 -u xxxx -p xxxx -w 60 -c 120
1) download the source and add it to /usr/libexec/monitoring-plugins
So in our example, /usr/libexec/monitoring-plugins/check_mysql_slavestatus.sh
-rwxr-xr-x 1 root root 14160 Mar 6 08:37 check_mysql_slavestatus.sh
2) Add the command to /etc/nagios/servers/mysql.cfg (this could be done as a seperate file, probably under objects, but this worked for me.
define command{
command_name check_mysql_slavestatus
command_line $USER1$/check_mysql_slavestatus.sh -H $HOSTADDRESS$ -P $ARG1$ -u $ARG2$ -p $ARG3$ -w $ARG4$ -c $ARG5$
}
3) Add the service under /etc/nagios/servers/fec.cfg
# check MySQL Slave Delay
define service{
use generic-service ; Name of service template to use
host_name FEC-B
service_description MySQL Replication Delay FEC B
check_command check_mysql_slavestatus!3306!xxxxl!xxxx!300!7200
notification_interval 3600
notification_period 24x7
}
No comments:
Post a Comment
Note: only a member of this blog may post a comment.