Nagios监控数据库的方法

Nagios监控数据库的方法：

check_mysql_health监控数据库

1、check_mysql_health安装

在监控服务器上安装

1. #cd/usr/local/src/tarbag
3. #wgethttp://labs.consol.de/wp-content/uploads/2010/03/check_mysql_health-2.1.1.tar.gz
5. #tarzxvfcheck_mysql_health-2.1.1.tar.gz-C../software/
7. #./configure\
9. –prefix=/usr/local/nagios/\
11. –with-nagios-user=nagios\
13. –with-nagios-group=nagios\
15. –with-perl=/usr/bin/perl\
17. –with-statefiles-dir=/usr/local/nagios/var/tmp\
19. –with-perlperl\程序运行路径
21. –with-statefiles-dir状态信息文件路径
23. #make
25. #makeinstall

2、check_mysql_health选项

1. Options:
3. –hostname
5. thedatabaseserver’shostname
7. –port
9. thedatabase’sport.(default:3306)
11. –socket
13. thedatabase’sunixsocket.
15. –username
17. themysqldbuser
19. –password
21. themysqldbuser’spassword
23. –database
25. thedatabase’sname.(default:information_schema)
27. –warning
29. thewarningrange
31. –critical
33. thecriticalrange
35. –mode
37. themodeoftheplugin.selectoneofthefollowingkeywords:
39. connection-time连接到服务器上的时间
41. uptime服务器运行的时间
43. threads-connected当前连接到数据库的连接数
45. threadcache-hitrate线程缓存命中率
47. slave-lagslave落后master多少时间
49. slave-io-runningslave复制是否正常
51. slave-sql-runningslave复制是否正常
53. qcache-hitrate查询缓存命中率
55. qcache-lowmem-prunes(Querycacheentriesprunedbecauseoflowmemory)
57. keycache-hitrate(MyISAMkeycachehitrate)
59. bufferpool-hitrate(InnoDBbufferpoolhitrate)
61. bufferpool-wait-free(InnoDBbufferpoolwaitsforcleanpageavailable)
63. log-waits(InnoDBlogwaitsbecauseofatoosmalllogbuffer)
65. tablecache-hitrate表缓存命中率
67. table-lock-contention表锁率
69. index-usage索引使用情况
71. tmp-disk-tables(Percentoftemptablescreatedondisk)
73. slow-queries慢查询
75. long-running-procs长时间运行的进程
77. cluster-ndbd-runningndb节点运行状况
79. sql返回一个数字的任何SQL语句

3、check_mysql_health监控配置

监控服务器：10.59.97.42

MySQL数据授权：

在要监控的MySQL数据库服务器上

1. mysql>grantusageon*.*tohonyho@10.59.97.42identifiedby“honyho@8123“;
3. mysql>flushprivileges;

在监控服务器上

1》查看当前连接到数据库的连接数

1. #./check_mysql_health–hostname10.59.97.57–usernamehonyho–passwordhonyho@8123–modethreads-connected
3. OK–3clientconnectionthreads|threads_connected=3;10;20
5. threads_connected=3;10;20

3表示连接数

10 表示warning阀值(默认)

20 表示critical阀值(默认)

Nagios相关配置

1》配置commands.cfg文件

1. definecommand{
3. command_namecheck_mysql_health
5. command_line$USER1$/check_mysql_health–hostname$ARG1$–username$ARG2$–password$ARG3$–warning$ARG4$–critical$ARG5$–mode$ARG6$
7. }

2》配置121_207_231_17.cfg文件

1. defineservice{
3. uselocal-service
5. host_name121.207.231.17
7. service_descriptionthreads-connected
9. check_commandcheck_mysql_health!10.59.97.57!honyho!honyho@8123!1000!1500!threads-connected
11. }