{"id":546,"date":"2023-05-28T02:09:26","date_gmt":"2023-05-27T18:09:26","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=546"},"modified":"2023-05-28T02:09:26","modified_gmt":"2023-05-27T18:09:26","slug":"mysql%e4%b8%bb%e4%bb%8e%e5%90%8c%e6%ad%a5%e7%9b%91%e6%8e%a7%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/mysql\/mysql%e4%b8%bb%e4%bb%8e%e5%90%8c%e6%ad%a5%e7%9b%91%e6%8e%a7%e8%84%9a%e6%9c%ac\/","title":{"rendered":"MySQL\u4e3b\u4ece\u540c\u6b65\u76d1\u63a7\u811a\u672c"},"content":{"rendered":"
\n
\n

\n
<\/mp-common-profile><\/section>\n

MySQL\u4e3b\u4ece\u540c\u6b65\u76d1\u63a7\u811a\u672c<\/span><\/h1>\n

<\/span>#!\/bin\/bash<\/span>\nmysql_user='root'<\/span>\nmysql_pass=\"oppoujuju564qaz\"<\/span>\ndata=$(\/bin\/date +%Y-%m-%d-%H:%M)\n\/bin\/netstat -lntup|egrep \":3306\"<\/span>|grep -v grep>\/dev\/null0\nif<\/span> [ $? -eq 0 ];then<\/span>\n Slave_IO=`\/data\/mysql\/bin\/mysql -u${mysql_user}<\/span> -p${mysql_pass}<\/span> -e \"show slave statusG\"<\/span>|grep \"Slave_IO_Running:\"<\/span>|awk -F\": \"<\/span> '{print $2}'<\/span>`\n Slave_SQL=`\/data\/mysql\/bin\/mysql -u${mysql_user}<\/span> -p${mysql_pass}<\/span> -e \"show slave statusG\"<\/span>|grep \"Slave_SQL_Running:\"<\/span>|awk -F\": \"<\/span> '{print $2}'<\/span>`\n  if<\/span> [ \"$Slave_IO<\/span>\"<\/span> == \"Yes\"<\/span> ] && [ \"$Slave_SQL<\/span>\"<\/span> == \"Yes\"<\/span> ];then<\/span>\n   STAT=1 && echo<\/span> \"$data<\/span> mysql-status is ok\"<\/span>>>\/var\/log<\/span>\/mysql-status.log\n  else<\/span>\n   STAT=0 && echo<\/span> \"$data<\/span> mysql-status is error\"<\/span>>>\/var\/log<\/span>\/mysql-status.log\n  fi<\/span>\nelse<\/span>\n STAT=0 && echo<\/span> \"$data<\/span> mysql-status is error\"<\/span>>>\/var\/log<\/span>\/mysql-status.log\nfi<\/span>\n\/usr\/bin\/zabbix_sender -z 101.227.67.205 -s \"DaoDaEr-mysql-status\"<\/span> -k mysql -o $STAT<\/span>\n<\/code><\/pre>\n<\/section>\n
<\/mp-common-profile><\/section>\n
\u4f7f\u7528\u65b9\u6cd5\uff1a\u4fee\u6539\u5bf9\u5e94\u6570\u636e\u5bc6\u7801\u53ca IP\u5730\u5740\u4fe1\u606f\u3002<\/p>\n
<\/mp-style-type><\/p>\n
\u672c\u7bc7\u6587\u7ae0\u6765\u6e90\u4e8e\u5fae\u4fe1\u516c\u4f17\u53f7:                 \u4e91\u539f\u751f\u77e5\u8bc6\u6808<\/p><\/blockquote>\n<\/div>\n","raw":"","protected":false},"excerpt":{"rendered":"
MySQL\u4e3b\u4ece\u540c\u6b65\u76d1\u63a7\u811a\u672c #!\/bin\/bash mysql_user=’root’ mysql_pass=”oppoujuju …<\/p>\n","protected":false},"author":1,"featured_media":544,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[3,8],"tags":[],"class_list":["post-546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-spring-cloud"],"post_thumbnail_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990-150x150.jpeg","content_first_image":null,"post_medium_image_300":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990-300x127.jpeg","post_thumbnail_image_624":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990.jpeg","post_frist_image":null,"post_medium_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990-300x127.jpeg","post_large_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990.jpeg","post_full_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230528010555990.jpeg","post_all_images":[],"videoAdId":"","listAd":"0","listAdId":"","listAdEvery":6,"total_comments":0,"category_name":"MySQL","post_date":"2023-05-27","like_count":"0","praiseWord":"\u9f13\u52b1","copyright_state":"","excitationAd":"0","rewardedVideoAdId":"","detailAdId":"","detailAd":"0","enterpriseMinapp":"0","audios":[],"postImageUrl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230519082947553.jpg","avatarurls":[],"related_posts":null,"pageviews":231,"next_post_id":528,"next_post_title":"\u6570\u636e\u5e93\u6162\u67e5\u8be2\u7684\u5177\u4f53\u539f\u56e0\uff0c\u4f18\u5316\u7b56\u7565\u64ad","previous_post_id":623,"previous_post_title":"MySQL\u5141\u8bb8\u5b57\u6bb5\u4e3anull\u4f1a\u5bfc\u81f45\u4e2a\u95ee\u9898\uff0c\u4e2a\u4e2a\u81f4\u547d\uff01","_links":{"self":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/comments?post=546"}],"version-history":[{"count":0,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/546\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media\/544"}],"wp:attachment":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media?parent=546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/categories?post=546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/tags?post=546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}