mysql多实例启动脚本

3212

#!/bin/bash
# function:made for start mysql for multi instance
# contact:44850823@qq.com
# Author：zhiwang.wang
# Version 1.0
. /etc/init.d/functions
port=$2
user=root
passwd='dba123'
BINDIR='/application/mysql/bin'
SocketFile=/data/$port/mysql.sock
PidFile=/data/$port/mysqld.pid
[ $# -eq 2 ]|| {
        echo "Usage: $0 {start|stop|restart|reload|help}"
        exit
}
function mysql_start() {
        [ -e "$SocketFile" ]&&  {
        action "MySQL port:$port is already running" /bin/false
        exit
        } || {
        action "MySQL is being Staring" /bin/true
        $BINDIR/mysqld_safe --defaults-file=/data/${port}/my.cnf &
        }
        [ "$?" == 0 ] && {
        action "MySQL has been Started" /bin/true
        } || {
        action "MySQL Started" /bin/false
}
}
function mysql_stop() {
        [ ! -e "$SocketFile" ]&& \
        action "MySQL port:$port was already down" /bin/false || \
        $BINDIR/mysqladmin -u $user -p$passwd -S $SocketFile shutdown &>/dev/null
        [ "$?" == 0 ]&& \
        action  "MySQL port:$port has been Stopped" /bin/true
}
case "$1" in
start)
        mysql_start
;;
stop)
        mysql_stop
;;
restart|reload)
        mysql_stop
        mysql_start
;;
*)
        echo "Usage: $0 {start|stop|restart|reload|help}"
esac