色婷五一,精品亚洲欧美一区二区三区日产 ,精选国产AV剧情,无码丰满少妇2在线观看

18600329666

咨詢技術(shù)專家

掃一掃
與技術(shù)專家在線溝通

Menu
mysql在線保持腳本

來(lái)源：未知　時(shí)間：2019-54-18　瀏覽次數(shù)：234次

一、mysql不定時(shí)宕機(jī)問(wèn)題接口
1.寫一腳本檢測(cè)mysql狀態(tài)，若宕機(jī)則重啟
#!/bin/bash
pgrep -x mysqld &> /dev/null
if [ $? -ne 0 ]
then
echo "At time: `date` :MySQL is stop .">> /var/log/mysql_messages
source /etc/profile
service mysqld restart
else
echo "MySQL server is running ."
fi
 
2.加入定時(shí)任務(wù)，定時(shí)監(jiān)聽(tīng)
*/5 * * * * /usr/local/shell-gmq-bash/mysql_monitor.sh >>/usr/local/shell-gmq-bash/log/log_status_$(date +%Y-%m-%d).log 2>&1
二、mysql不定時(shí)讀取不到數(shù)據(jù)源（數(shù)據(jù)庫(kù)文件存在但加載不到，所以找不到數(shù)據(jù)庫(kù)）
1.編寫腳本鏈接數(shù)據(jù)庫(kù)讀取該數(shù)據(jù)庫(kù)，若該數(shù)據(jù)庫(kù)不存在則重啟并重新加載，腳本內(nèi)容如下
STNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD="xxxxx"
DBNAME="xxxxxxxxx"
TABLENAME="test"
use_db_sql="use ${DBNAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${use_db_sql}"
if [ $? -eq 0 ];then
echo mysql wh_expo is ok
else
echo "At time: `date` :MySQL is stop .">> /var/log/mysql_dbcheck.log
source /etc/profile
service mysqld restart
fi
2.設(shè)置定時(shí)任務(wù)，定時(shí)檢測(cè)并執(zhí)行腳本
*/2 * * * * /usr/local/shell-gmq-bash/mysql_checkdb.sh >>/usr/local/shell-gmq-bash/log/log_dbcheck_$(date +%Y-%m-%d).log 2>&1