{"id":18215,"date":"2014-03-07T07:18:35","date_gmt":"2014-03-06T23:18:35","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/03\/07\/%e4%bb%a5-nagios-%e5%81%b5%e6%b8%ac-mysql-server\/"},"modified":"2021-03-18T17:23:51","modified_gmt":"2021-03-18T09:23:51","slug":"%e4%bb%a5-nagios-%e5%81%b5%e6%b8%ac-mysql-server","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/03\/07\/%e4%bb%a5-nagios-%e5%81%b5%e6%b8%ac-mysql-server\/","title":{"rendered":"\u4ee5 Nagios \u5075\u6e2c MySQL Server"},"content":{"rendered":"

MySQL Server\u00a0\u70ba\u4e86\u5b89\u5168\uff0c\u6240\u4ee5\u5927\u90e8\u5206\u90fd\u4e0d\u5efa\u7acb\u9023\u7dda\u57e0\uff0c\u6216\u8005\u662f\u50c5\u9650\u672c\u6a5f\u9023\u7dda\uff0c\u4e0d\u5141\u8a31\u9060\u7aef\u9023\u7dda\uff0c\u6240\u4ee5\u5075\u6e2c MySQL Server\u00a0\u5c31\u6bd4\u8f03\u6c92\u6709\u90a3\u9ebc\u5be6\u969b\uff0c\u800c\u4e14\u5728\u6aa2\u67e5\u6642\uff0c\u5bc6\u78bc\u662f\u4ee5\u660e\u78bc\u50b3\u9001\uff0c\u6703\u6709\u5b89\u5168\u6027\u4e0a\u7684\u554f\u984c\u3002<\/p>\n

1. \u6aa2\u67e5\u662f\u5426\u6709 check_mysql \u6aa2\u67e5\u6307\u4ee4
# locate check_mysql<\/span>
\/usr\/lib64\/nagios\/plugins\/check_mysql
\/usr\/lib64\/nagios\/plugins\/check_mysql_query
<\/span>
2. \u6aa2\u67e5\u4e00\u4e0b\uff0ccheck_mysql \u9808\u8981\u52a0\u5165\u7684\u53c3\u6578
# \/usr\/lib64\/nagios\/plugins\/check_mysql -h<\/span>
Options:
\u00a0-h, –help
\u00a0\u00a0\u00a0 Print detailed help screen
\u00a0-V, –version
\u00a0\u00a0\u00a0 Print version information
\u00a0–extra-opts=[section][@file]
\u00a0\u00a0\u00a0 Read options from an ini file. See http:\/\/nagiosplugins.org\/extra-opts
\u00a0\u00a0\u00a0 for usage and examples.
\u00a0-H, –hostname=ADDRESS<\/span>
\u00a0\u00a0\u00a0 Host name, IP Address, or unix socket (must be an absolute path)<\/span>
\u00a0-P, –port=INTEGER<\/span>
\u00a0\u00a0\u00a0 Port number (default: 3306)<\/span>
\u00a0-s, –socket=STRING
\u00a0\u00a0\u00a0 Use the specified socket (has no effect if -H is used)
\u00a0-d, –database=STRING<\/span>
\u00a0\u00a0\u00a0 Check database with indicated name<\/span>
\u00a0-u, –username=STRING<\/span>
\u00a0\u00a0\u00a0 Connect using the indicated username<\/span>
\u00a0-p, –password=STRING<\/span>
\u00a0\u00a0\u00a0 Use the indicated password to authenticate the connection<\/span>
\u00a0\u00a0\u00a0 ==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==<\/span>
\u00a0\u00a0\u00a0 Your clear-text password could be visible as a process table entry<\/span>
\u00a0-S, –check-slave
\u00a0\u00a0\u00a0 Check if the slave thread is running properly.
\u00a0-w, –warning
\u00a0\u00a0\u00a0 Exit with WARNING status if slave server is more than INTEGER seconds
\u00a0\u00a0\u00a0 behind master
\u00a0-c, –critical
\u00a0\u00a0\u00a0 Exit with CRITICAL status if slave server is more then INTEGER seconds
\u00a0\u00a0\u00a0 behind master<\/span><\/span>[@more@]3.\u00a0\u5efa\u7acb\u8cc7\u6599\u5eab\u548c\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u53ca\u5bc6\u78bc
# \/usr\/local\/bin\/mysqladmin -u root -p create nagiostest<\/span>
# \/usr\/bin\/mysql -u root -p -e “GRANT ALL PRIVILEGES ON nagiostest.* TO ‘ntest’@’localhost’ IDENTIFIED BY ‘123test’;”<\/span><\/p>\n

4.\u00a0\u6e2c\u8a66\u4e00\u4e0b
# \/usr\/lib64\/nagios\/plugins\/check_mysql -H 127.0.0.1 -P 3306 -u ntest -d <\/span>nagiostest -p 123test<\/span>
Uptime: 178009\u00a0 Threads: 1\u00a0 Questions: 348\u00a0 Slow queries: 0\u00a0 Opens: 16\u00a0 Flush tables: 1\u00a0 Open tables: 9\u00a0 Queries per second avg: 0.1<\/span><\/p>\n

5. \u5728 \/etc\/nagios\/objects\/commands.cfg\u00a0\u6a94\u6848\u52a0\u5165<\/p>\n

# ‘check_mysql’ command definition
define command{
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 command_name\u00a0\u00a0\u00a0 check_mysql
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 command_line\u00a0\u00a0\u00a0 $USER1$\/check_mysql -H $ARG1$ -P $ARG2$ -u $ARG3$ -d $ARG4$ -p $ARG5$
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/p>\n

6.\u00a0\u5728\u8981\u5075\u6e2c\u7684 MySQL Server \u4e3b\u6a5f\u52a0\u5165
# vim \/etc\/nagios\/objects\/localhost.cfg<\/span>
define service{
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 use\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 local-service\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ; Name of service template to use
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 host_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 service_description\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MySQL
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 check_command\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 check_mysql!127.0.0.1!3306!ntest!nagiostest!123test
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 notifications_enabled\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/p>\n

\u91cd\u65b0\u555f\u52d5 Nagios
# service nagios restart<\/span>
Running configuration check…done.<\/span>
Stopping nagios: .done.<\/span>
Starting nagios: done.<\/span><\/p>\n

\u5982\u679c\u6c92\u6709\u51fa\u73fe\u932f\u8aa4\u8a0a\u606f\uff0c\u4ee3\u8868\u8a2d\u5b9a\u6210\u529f<\/p>\n

\u9019\u6642\u5019\u61c9\u8a72\u53ef\u4ee5\u770b\u5230\u4e0b\u9762\u7684\u5716
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL Server\u00a0\u70ba\u4e86\u5b89\u5168\uff0c\u6240\u4ee5\u5927\u90e8\u5206\u90fd\u4e0d\u5efa\u7acb\u9023\u7dda\u57e0\uff0c\u6216\u8005\u662f\u50c5\u9650\u672c\u6a5f\u9023\u7dda\uff0c\u4e0d\u5141\u8a31\u9060\u7aef\u9023\u7dda\uff0c\u6240\u4ee5\u5075\u6e2c M … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008\u4ee5 Nagios \u5075\u6e2c MySQL Server\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131],"tags":[],"class_list":["post-18215","post","type-post","status-publish","format-standard","hentry","category-c-78476"],"meta_key":{"_encloseme":["1"],"lt_post_id":["471784"],"_pingme":["1"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18215"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18215"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18215\/revisions"}],"predecessor-version":[{"id":19872,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18215\/revisions\/19872"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}