编写mysql多实例启动脚本

梅钟园 · 发表于 2019-8-11 11:31:00

本帖最后由梅钟园于 2019-8-11 11:50 编辑

脚本原理：
　启动MySQL动作：
　　　mysqld_safe来执行启动
　停止MySQL动作：
　　　使用mysqladmin来执行停止动作
　重启的MySQL动作：
　　原理就是先停止，然后再启动
　　　但是要注意：简单的sleep来等待停止和启动过程极可能出现在短时间内重复运行重启，mysqld_safe报错提示已经启动了一个实例的问题
　　　这里可以参考MySQL提供的默认启动脚本mysqld.service中的wait_for_pid()这个函数。

以下是启动脚本，效果如图：

登录/注册后可看大图

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

下载附件

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

复制代码

帐号		自动登录	找回密码
密码			注册

[系统管理] 编写mysql多实例启动脚本