{"id":2588,"date":"2020-04-17T10:13:59","date_gmt":"2020-04-17T02:13:59","guid":{"rendered":"https:\/\/sumju.net\/?p=2588"},"modified":"2020-04-17T10:13:59","modified_gmt":"2020-04-17T02:13:59","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%e4%be%8b%e5%ad%90%e4%b8%80%e4%b8%aa","status":"publish","type":"post","link":"https:\/\/sumju.net\/?p=2588","title":{"rendered":"MySQL \u4e3b\u4ece\u540c\u6b65\u76d1\u63a7\u811a\u672c\u4f8b\u5b50\u4e00\u4e2a"},"content":{"rendered":"<p>shell\u811a\u672c\uff0c\u6ce8\u610f\u4fee\u6539\u4e0b\u9762mysql\u6570\u636e\u5e93\u5bc6\u7801\uff0c\u8fd8\u6709\u5982\u679c\u9700\u8981\u53d1\u9001\u62a5\u8b66\u90ae\u4ef6\uff0c\u9700\u8981\u670d\u52a1\u5668\u914d\u7f6e\u597d\u5916\u53d1\u90ae\u4ef6\uff0c\u4e5f\u5c31\u662f\u8bf4\u7528mail\u547d\u4ee4\u53ef\u4ee5\u5916\u53d1\u90ae\u4ef6\uff0c\u5982\u679c\u6ca1\u6709\u5916\u53d1\u90ae\u4ef6\u9700\u8981\u8bf7\u6ce8\u91ca\u6389\u5e26\u6709 xxx@163.com\u5b57\u6837\u7684\u8bed\u53e5\u3002\u811a\u672c\u8981\u7ed9\u4e8e\u6267\u884c\u6743\u9650 chomd +x xxx.sh \uff0c\u53ef\u4ee5\u6dfb\u52a0\u5230crontab\u91cc\u81ea\u52a8\u95f4\u9694\u8fd0\u884c\uff0c\u65e5\u5fd7\u4f4d\u7f6e\u5728\/data\u76ee\u5f55\u4e0b\u3002<\/p>\n<pre>\r\n<code>#!\/bin\/bash\r\n#check MySQL_Slave Status\r\n#crontab time 00:10\r\nMYSQLPORT=`netstat -na|grep \"LISTEN\"|grep \"3306\"|awk -F[:\" \"]+ '{print $4}'`\r\nMYSQLIP=`ifconfig eth0|grep \"inet addr\" | awk -F[:\" \"]+ '{print $4}'`\r\nSTATUS=$(mysql -u root -ppassword -e \"show slave status\\G\" | grep -i \"running\")\r\nIO_env=`echo $STATUS | grep IO | awk  ' {print $2}'`\r\nSQL_env=`echo $STATUS | grep SQL | awk  '{print $2}'`\r\nDATA=`date +\"%y-%m-%d %H:%M:%S\"`\r\nif [ \"$MYSQLPORT\" == \"3306\" ]\r\nthen\r\n  echo \"mysql is running\"\r\nelse\r\n  mail -s \"warn!server: $MYSQLIP mysql is down\" xxx@163.com\r\nfi\r\nif [ \"$IO_env\" = \"Yes\" -a \"$SQL_env\" = \"Yes\" ]\r\nthen\r\n  echo \"Slave is running!\"\r\nelse\r\n  echo \"####### $DATA #########\">> \/data\/check_mysql_slave.log\r\n  echo \"Slave is not running!\" >>    \/data\/check_mysql_slave.log\r\n  echo \"Slave is not running!\" | mail -s \"warn! $MYSQLIP MySQL Slave is not running\" xxx@163.com\r\nfi<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>shell\u811a\u672c\uff0c\u6ce8\u610f\u4fee\u6539\u4e0b\u9762mysql\u6570\u636e\u5e93\u5bc6\u7801\uff0c\u8fd8\u6709\u5982\u679c\u9700\u8981\u53d1\u9001\u62a5\u8b66\u90ae\u4ef6\uff0c\u9700\u8981\u670d\u52a1\u5668\u914d\u7f6e\u597d\u5916\u53d1\u90ae\u4ef6&hellip; <a href=\"https:\/\/sumju.net\/?p=2588\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">MySQL \u4e3b\u4ece\u540c\u6b65\u76d1\u63a7\u811a\u672c\u4f8b\u5b50\u4e00\u4e2a<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":{"0":"post-2588","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-uncategorized","7":"h-entry","9":"h-as-article"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/2588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2588"}],"version-history":[{"count":1,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/2588\/revisions"}],"predecessor-version":[{"id":2590,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/2588\/revisions\/2590"}],"wp:attachment":[{"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}