MySQL Server Monitor With Nagios

Can any one tell how to monitor mysql using nagios and how configure plugins.

Have you installed nagios yet? Have you read the instructions?

What platform? What version? Which plugin(s)? Where are you having trouble?

I have Instaled nagios and configured with pluins.I strucked at
Check_mysql

My command.cfg contains

‘check_mysql’ command defination

define command{

command_name check_mysql

Command_line $USER1$/check_mysql -u $ARG1$ -p $ARG2$ -H$HOSTADDRESS$

}

In my service defination it

define service{

use local-service ; Name of service template to use

host_name localhost

is_volatile 0

check_period 24x7

max_check_attempts 4

normal_check_interval 5

retry_check_interval 1

notification_interval 960

notification_period 24x7

service_description MySQL Running

check_command mysql_check!root!toyota

}

When I start nagios I got error Service check command ‘mysql_check’ specified in service ‘MySQL Running’ for host ‘localhost’ not defined anywhere

Can any one tell me solution.

Here are the steps to follow in order to achieve what you want:

http://kedar.nitty-witty.com/blog/10-steps-mysql-monitoring- nagios-installation-configuration