编写mysql多实例启动脚本 - 重庆思庄Oracle、Redhat认证学习论坛

55995d4f8bc2752f2.png (9.04 KB, 下载次数: 359)

下载附件

2019-8-11 11:30 上传

脚本：

#!/bin/sh
#init
port=3306
mysql_user="root"
mysql_pwd="test"
CmdPath="/usr/local/mysql-5.5.62/bin/"
mysql_sock="/data/${port}/mysqld.sock"
pid_file="/data/${port}/mysqld.pid"
service_startup_timeout=900
PATH=/sbin:/usr/sbin:/bin:/usr/bin:$CmdPath:$PATH
export PATH
#print faild
echo_info_false(){
echo -e "[\e[0;31;1m failed \e[0;31;0m]"
}
#wait for pid
wait_for_pid(){
verb="$1" # created | removed
pid="$2" # process ID of the program operating on the pid-file
pid_file_path="$3" # path to the PID file.
i=0
flag="by checking again"
while test $i -ne $service_startup_timeout;do
case "$verb" in
'created')
# wait for a PID-file to pop into existence.
test -s "$pid_file_path" && i='' && break
;;
'removed')
# wait for this PID-file to disappear
test ! -s "$pid_file_path" && i='' && break
;;
*)
echo "wait_for_pid () usage: wait_for_pid created|removed pid pid_file_path"
exit 1
;;
esac
# if server isn't running, then pid-file will never be updated
if test -n "$pid"; then
if kill -0 "$pid" 2>/dev/null; then
: # the server still runs
else
# The server may have exited between the last pid-file check and now.
if test -n "$avoid_race_condition"; then
flag=""
continue # Check again.
fi
return 1 # not waiting any more.
fi
fi
sleep 1
done
}
#startup function
function_start_mysql(){
if [ ! -e "$mysql_sock" ];then
printf "Starting MySQL..."
/bin/sh ${CmdPath}/mysqld_safe --defaults-file=/data/${port}/my.cnf 2>&1 > /dev/null &
wait_for_pid created "$!" "$pid_file"
if [ $? -eq 0 ];then
echo_info_ok
else
echo_info_false
fi
else
printf "MySQL is running...\n"
exit
fi
}
#stop function
function_stop_mysql(){
if [ ! -e "$mysql_sock" ];then
printf "MySQL is stopped...\n"
exit
else
printf "Stoping MySQL..."
${CmdPath}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown
wait_for_pid removed "$!" "$pid_file"
if [ $? -eq 0 ];then
echo_info_ok
else
echo_info_false
fi
fi
}
#restart function
function_restart_mysql(){
if [ ! -e $mysql_sock ];then
printf "Restarting MySQL..\n"
function_start_mysql
else
printf "Restarting MySQL...\n"
function_stop_mysql
if [ $? -eq 0 ];then
function_start_mysql
else
printf "Starting MySQL"
echo_info_false
fi
done
fi
}
#main
case $1 in
start)
function_start_mysql
;;
stop)
function_stop_mysql
;;
restart)
function_restart_mysql
;;
*)
printf "Usage: /data/${port}/mysql {start|stop|restart}\n"
esac

复制代码

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)