Shell篇之编写MySQL启动脚本

Shell篇之编写MySQL启动脚本

1. 脚本内容

vim mysql_ctl.sh

#!/bin/bashmysql_port=3306
mysql_username="root"
mysql_password="molinker"
mysql_conf="/opt/lanmp/mysql/etc/my.cnf"
mysql_sock="/opt/lanmp/mysql/var/mysql.sock"function_start_mysql(){printf "Starting MySQL ...\n"/bin/sh /opt/lanmp/mysql/bin/mysqld_safe --defaults-file=${mysql_conf} 2>&1 > /dev/null &
}function_status_mysql(){
mysql_stat=0
mysql_tmpa=`ps -ef | grep mysql | grep -v root | awk '{print $2}'`
name="`hostname`.pid"
mysql_tmpb=`cat /opt/lanmp/mysql/var/$name`
if [ `lsof -i:20036 | wc -l` -gt 0 ]; thenif [ `ps -ef | grep mysql | grep -v grep | wc -l` -gt 0 ]; thenif [ $mysql_tmpa -eq $mysql_tmpb ]; thenmysql_stat=1fifi
fiif [ $mysql_stat -eq 1 ]; thenecho "mysql(pid $mysql_tmpb) is runing!"
elif [ $mysql_stat -eq 0 ]; thenecho "mysql is not runing!"
fi
}function_stop_mysql(){printf "Stopping MySQL ...\n"/opt/lanmp/mysql/bin/mysqladmin --port=${mysql_port} --user=${mysql_username} --password=${mysql_password} --socket=${mysql_sock} shutdown
}function_restart_mysql(){printf "Restarting MySQL ...\n"function_stop_mysqlsleep 1function_start_mysql
}function_kill_mysql(){ps -ef | grep "mysqld_safe" | grep -v grep | awk '{print "kill -9 " $2}' | /bin/shps -ef | grep "mysqld" | grep -v grep | awk '{print "kill -9 " $2}' | /bin/sh
}if [ "$1" = "start" ]; thenfunction_start_mysql
elif [ "$1" = "stop" ]; thenfunction_stop_mysql
elif [ "$1" = "status" ]; thenfunction_status_mysql
elif [ "$1" = "restart" ]; thenfunction_restart_mysql
elif [ "$1" = "kill" ]; thenfunction_kill_mysql
elseprintf "Usage: mysql {start|stop|restart|kill|status}\n"
fi

注意事项

mysql_conf：为MySQL对应配置文件路径
mysql_sock：为MySQL对应socket文件

2. 赋权

chmod +x mysql_ctl.sh

3. 命令

./mysql_ctl start
./mysql_ctl status
./mysql_ctl restart