Nagios監(jiān)控?cái)?shù)據(jù)庫的方法
Nagios監(jiān)控?cái)?shù)據(jù)庫的方法：
check_mysql_health監(jiān)控?cái)?shù)據(jù)庫
1、check_mysql_health安裝
在監(jiān)控服務(wù)器上安裝
- # cd /usr/local/src/tarbag
- # wget http://labs.consol.de/wp-content/uploads/2010/03/check_mysql_health-2.1.1.tar.gz
- # tar zxvf check_mysql_health-2.1.1.tar.gz -C ../software/
- # ./configure \
- –prefix=/usr/local/nagios/ \
- –with-nagios-user=nagios \
- –with-nagios-group=nagios \
- –with-perl=/usr/bin/perl \
- –with-statefiles-dir=/usr/local/nagios/var/tmp \
- –with-perl perl\ 程序運(yùn)行路徑
- –with-statefiles-dir 狀態(tài)信息文件路徑
- # make
- # make install
2、check_mysql_health選項(xiàng)
- Options:
- –hostname
- the database server’s hostname
- –port
- the database’s port. (default: 3306)
- –socket
- the database’s unix socket.
- –username
- the mysql db user
- –password
- the mysql db user’s password
- –database
- the database’s name. (default: information_schema)
- –warning
- the warning range
- –critical
- the critical range
- –mode
- the mode of the plugin. select one of the following keywords:
- connection-time 連接到服務(wù)器上的時(shí)間
- uptime 服務(wù)器運(yùn)行的時(shí)間
- threads-connected 當(dāng)前連接到數(shù)據(jù)庫的連接數(shù)
- threadcache-hitrate 線程緩存命中率
- slave-lag slave落后master多少時(shí)間
- slave-io-running slave復(fù)制是否正常
- slave-sql-running slave復(fù)制是否正常
- qcache-hitrate 查詢緩存命中率
- qcache-lowmem-prunes (Query cache entries pruned because of low memory)
- keycache-hitrate (MyISAM key cache hitrate)
- bufferpool-hitrate (InnoDB buffer pool hitrate)
- bufferpool-wait-free (InnoDB buffer pool waits for clean page available)
- log-waits (InnoDB log waits because of a too small log buffer)
- tablecache-hitrate 表緩存命中率
- table-lock-contention 表鎖率
- index-usage 索引使用情況
- tmp-disk-tables (Percent of temp tables created on disk)
- slow-queries 慢查詢
- long-running-procs 長(zhǎng)時(shí)間運(yùn)行的進(jìn)程
- cluster-ndbd-running ndb節(jié)點(diǎn)運(yùn)行狀況
- sql 返回一個(gè)數(shù)字的任何SQL語句
3、check_mysql_health監(jiān)控配置
監(jiān)控服務(wù)器：10.59.97.42
MySQL數(shù)據(jù)授權(quán)：
在要監(jiān)控的MySQL數(shù)據(jù)庫服務(wù)器上
- mysql> grant usage on *.* to honyho@10.59.97.42 identified by “honyho@8123“;
- mysql> flush privileges;
在監(jiān)控服務(wù)器上
1》查看當(dāng)前連接到數(shù)據(jù)庫的連接數(shù)
- #./check_mysql_health –hostname 10.59.97.57 –username honyho –password honyho@8123 –mode threads-connected
- OK – 3 client connection threads | threads_connected=3;10;20
- threads_connected=3;10;20
3表示連接數(shù)
10 表示warning閥值(默認(rèn))
20 表示critical閥值(默認(rèn))
#p#
Nagios相關(guān)配置
1》配置commands.cfg文件
- define command{
- command_name check_mysql_health
- command_line $USER1$/check_mysql_health –hostname $ARG1$ –username $ARG2$ –password $ARG3$ –warning $ARG4$ –critical $ARG5$ –mode $ARG6$
- }
2》配置121_207_231_17.cfg文件
- define service{
- use local-service
- host_name 121.207.231.17
- service_description threads-connected
- check_command check_mysql_health!10.59.97.57!honyho!honyho@8123!1000!1500!threads-connected
- }
———————————————————–
#p#
nagios-mysql-plugins插件監(jiān)控?cái)?shù)據(jù)庫
一、安裝此插件
- #wget 北北沒有給地址
- #tar zxvf nagios-mysql-plugins-0.3.tar.gz -C ../software/
- #cd nagios-mysql-plugins-0.3
- #chmod +x *mysql*
二、插件內(nèi)容
check_db_mysql.pl 檢測(cè)mysql是否運(yùn)行
check_errorlog_mysql.pl 檢測(cè)mysql數(shù)據(jù)庫錯(cuò)誤日志
check_repl_mysql_cnt_slave_hosts.pl 統(tǒng)計(jì)連接到從主機(jī)數(shù)
check_repl_mysql_heartbeat.pl 檢測(cè)心跳 (安裝完默認(rèn)名字是check_repl_mysql_hearbeat.pl)
check_repl_mysql_io_thread.pl 檢測(cè)IO線程
check_repl_mysql_read_exec_pos.pl
check_repl_mysql_readonly.pl 檢測(cè)從是否設(shè)置為只讀
check_repl_mysql_seconds_behind_master.pl檢測(cè)從多少時(shí)間與主同步
check_repl_mysql_sql_thread.pl 檢測(cè)SQL線程
perf_mysql.pl 收集性能數(shù)據(jù)
- perf_mysql.pl -m
- connections,
- thread_cache,
- network_traffic,
- queries,query_cache,
- myisam_key_buffer,
- table_cache,
- temporary_tables,
- tables,
- slow_queries,
- bin_log,uptime,
- innodb_buffer_pool,
- innodb_buffer_pool_io,
- innodb_io,innodb_data,
- innodb_logfile,
- innodb_row_locking,
- innodb_queries
【編輯推薦】
Nagios飛信Linux系統(tǒng)免費(fèi)短信報(bào)警配置
