mysql上线脚本规范_专业规范的MySQL启动脚本

曾经终败给现在 2022-10-27 02:49 104阅读 0赞

\#!/bin/bash

\# chkconfig: 2345 64 36 \#配置系统自启动

\# description: A very fast and reliable SQL database engine.

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\# File Name: mysqld

\# Version: V1.0

\# Author: aning

\# Organization: www.ningfg.cn

\# Created Time : 2018-06-05 08:58:19

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#引入系统函数库

. /etc/init.d/functions

\#基础路径定义

basedir='/application/mysql'

bindir='/application/mysql/bin'

lockdir='/var/lock/subsys'

lock\_file\_path="$lockdir/mysql"

mysqld\_pid\_file\_path='$basedir/data/\`uname -n\`.pid'

\#成功提示函数

log\_success\_msg()\{

\#action为特殊的提示函数，$@为所有参数。

action "SUCCESS! $@" /bin/true

\#失败提示函数

log\_failure\_msg()\{

action "ERROR! $@" /bin/false

\#mysql启动函数

start()\{

echo $"Starting MySQL"

\#测试mysqld\_safe是否可执行

if test -x $bindir/mysqld\_safe

then

\#后台执行启动mysql命令

$bindir/mysqld\_safe &>/dev/null &

\#获取返回值

retval=$?

\#判断返回值是否为0

if \[ $retval -eq 0 \]

then

\#调用成功提示函数。

log\_success\_msg "mysql Startup"

if test -w "$lockdir" \#判断锁目录是否可写。

then

touch "$lock\_file\_path" \#创建锁文件。

return $retval \#给返回值是专业的表现。

else

log\_failure\_msg "MySQL Startup" \#调用失败函数提示。

return $retval

else

log\_failure\_msg "Couldn't find MySQL server ($bindir/mysqld\_safe)"

\#停止MySQL函数。

stop()\{

\#判断mysql pid file大小是否为0。

if test -s "$mysqld\_pid\_file\_path"

then

\#读取pidfile

mysqld\_pid=\`cat "$mysqld\_pid\_file\_path"\`

\#判断mysql pid对应的进程是否存在。

if (kill -0 $mysqld\_pid 2>/dev/null)

then

echo $"Shutting down MySQL"

kill $mysqld\_pid \#停止MySQL命令。

retval=$?

if \[ $retval -eq 0 \]

then

log\_success\_msg "MySQL Stop" \#调用停止成功函数。

if test -f "$lock\_file\_path"

then

rm -f "$lock\_file\_path" \#删除锁文件。

return $retval

else

log\_failure\_msg "MySQL Stop."

return $retval

else

log\_failure\_msg "MySQL server process mysqld\_pid is not running!"

rm "$mysqld\_pid\_file\_path"

else

log\_failure\_msg "MySQL server PID file is null or not exist!"

\#接收传参判断并执行相应函数。

case "$1" in

start)

start

retval=$?

;;

stop)

stop

retval=$?

;;

restart)

stop

sleep 2 \#这里很重要，要休息一下。

start

retval=$?

;;

\*)

echo $"Usage:$0 \{start|stop|restart\}"

exit 2

esac

exit $retval \#执行脚本后，有返回值才更专业。

mysql上线脚本规范_专业规范的MySQL启动脚本

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql 多实例启动脚本_MySQL 多实例启动和停止脚本

相关 MySQL规范，设计规范，索引规范，开发规范，操作规范

相关 MySQL规范

相关 Mysql规范

相关 mysql数据规范_MySql数据库规范与原则

相关 mysql上线脚本规范_专业规范的MySQL启动脚本

相关 Linux shell 脚本规范

相关 MYSQL线上审核规范

相关 mysql 规范

相关 shell_脚本之规范和变量