nagios 使用mysql_Nagios使用check_mysql_health插件监控Mysql主机

cd /usr/local/nagios/etc/objects

sudo touch mysql92\1.cfg && sudo chown nagios:nagios mysql91.cfg

# add

# define a host use template linux-server

define host {

uselinux-server

host_namemysql91

aliasmysql server 91

address192.168.0.91

}

# define a new hostgroup

define hostgroup {

hostgroup_namemysql-server

aliasmysql-server

membersmysql91

}

# define services with template generic-service

# mysql_conn_time

define service {

usegeneric-service

host_namemysql91

service_descriptionmysql_conn_time

check_commandcheck_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!connection-time!

}

# mysql_threads_connected

define service {

usegeneric-service

host_namemysql91

service_descriptionmysql_threads_connected

check_commandcheck_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!threads-connected!

}

# mysql_slow_queries

define service {

usegeneric-service

host_namemysql91

service_description mysql_slow_queries

check_commandcheck_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!slow-queries!

}

# mysql_encde

define service {

usegeneric-service

host_namemysql91

service_description mysql_sql

check_commandcheck_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!encode!

}

# mysql_open_files

define service {

usegeneric-service

host_namemysql91

service_description mysql_open_files

check_commandcheck_mysql_health!192.168.0.91!db!MysqlPasswd2019!3306!open-files!

}