您好,登錄后才能下訂單哦!
這篇文章給大家分享的是重寫啟動腳本的方法,相信大部分人都還沒學(xué)會這個技能,為了讓大家學(xué)會,給大家總結(jié)了以下內(nèi)容,話不多說,一起往下看吧。
user=root
port=3306
CmdPath=/opt/mysql/bin
password=xxxxxxxxxxbase_dir=/opt/mysql
inst_dir=/data/3306
alive="00"
sMysqld=0
sMysqldSafe=0
fSock=0
fPID=0check_alive()
{
echo "running check_alive..."
if [ps -ef | grep $port | grep -v grep | grep 'mysqld ' |awk '{print $2}'
];then
echo "Process mysqld is running!"
sMysqld=1
else
echo "Process mysqld is not running!"
sMysqld=0
fi
if [ `ps -ef | grep 3306 | grep -v grep | grep 'mysqld_safe' |awk '{print $2}'` ];then
echo "Process mysqld_safe is running!" sMysqldSafe=1 else echo "Process mysqld_safe is not running!" sMysqldSafe=0 fi if [ -e ${inst_dir}/mysql.sock ];then echo "socked file exists!" fSock=1 else echo "socked file not exists!" fSock=0 fi if [ -e ${inst_dir}/mysql.pid ];then echo "pid file exists!" fPID=1 else echo "pid file not exists!" fPID=0 fi if [ $sMysqld -eq 1 ];then if [ $fPID -eq 0 ];then echo "PID is missing, tring to recreate..." ps -ef | grep $port | grep -v grep | grep 'mysqld ' |awk '{print $2}' > ${inst_dir}/mysql.pid if [ -e ${inst_dir}/mysql.pid ]; then echo "pid file is created!" else echo "can not create PID file, please have a check!" fi fi if [ $sMysqldSafe -eq 0 ];then echo "Process mysqld_safe is missing, please have a check! May cause mysqld crash!" fi if [ $fSock -eq 1 ];then echo "MySQL running fine!!!" alive="11" else echo "socket file is missing, you may have to login without socket!" alive="10" fi else echo "process mysqld is missing, mysql is stopped!" if [ $fSock -eq 1 ] | [ $fPID -eq 1 ];then echo "mysql was stopped abnormality!" echo "cleaning socket file and pid file" alive="01" else alive="00" fi
fi
}
start_mysql()
{
check_alive
printf "MySQL is starting ... \n"
if [ $alive == "00" ]; then
${CmdPath}/mysqld_safe --defaults-file=${inst_dir}/my.cnf --user=${user} 2>&1 >/dev/null &
else
if [ $alive == "11" ]; then
echo "MySQL is runnig!"
else
if [ $alive == "01" ]; then
echo "MySQL was stopped but pid or sock file still exits!"
echo "Cleanning pid or sock files!"
if [ $fSock -eq 1 ];then
rm -f ${inst_dir}/mysql.sock
fi
if [ $fPID -eq 1 ];then
rm -f ${inst_dir}/mysql.pid
fi
echo "Tring to start MySQL again!!!"
${CmdPath}/mysqld_safe --defaults-file=${inst_dir}/my.cnf --user=${user} 2>&1 >/dev/null &
fi
fi
fi
}stop_mysql()
{
check_alive
printf "MySQL is Stopping...\n"
if [ $alive == "11" ]; then
${CmdPath}/mysqladmin -u root -p${password} -S ${inst_dir}/mysql.sock shutdown 2>&1 >/dev/null &
else
if [ $alive == "10" ]; then
${CmdPath}/mysqladmin -u root -p${password} -h $HOSTNAME -P $port --protocol tcp shutdown 2>&1 >/dev/null &
else
echo "MySQL is not running, no need stop!"
fi
fi
}restart_mysql()
{
stop_mysql
sleep 5
if [ $? == 0 ];then
start_mysql
else
echo "stop mysql failed!"
fi
}case $1 in
start)
start_mysql
;;
stop)
stop_mysql
;;
restart)
restart_mysql
;;
status)
status_mysql
;;
alive)
check_alive
;;
*)
printf "Please in put start|stop|restart|status as input"
;;
esac
}
以上就是重寫啟動腳本的方法,代碼示例簡單明了,如果在日常工作遇到此問題。通過這篇文章,希望你能有所收獲,更多詳情敬請關(guān)注億速云行業(yè)資訊頻道!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。