MySQL单实例、多实例服务脚本

#!/bin/sh
. /etc/init.d/functions
path="/application/mysql/bin"
user="root"
pass="123456"

# 传递参数错误执行的函数
function usage(){
    echo "$0 {start|stop|restart}"
}

# 启动服务的函数
function start(){
    $path/mysqld_safe --user=mysql > /dev/null 2>&1 &
    if [ $? -eq 0 ]
      then
         action "start mysql" /bin/true
      else
         action "start mysql" /bin/false
    fi
}

# 停止服务的函数
function stop(){
    mysqladmin --user$user -p$pass shuntdown > /dev/null 2>&1 
    if [ $? -eq 0 ]
      then
         action "stop mysql" /bin/true
      else
         action "stop mysql" /bin/false
    fi
}

case $1 in
  start)
    start
  ;;
  stop)
    stop
  ;;
  restart)
    stop
    sleep 2
    start
  ;;
  *)
    usage
  ;;
esac

#!/bin/sh
port=3306
user="root"
pass=123456
path="/application/mysql/bin"
sock_path="data/$port/mysql.sock"



function usage(){
    printf "Usage:/data/$port/mysql {start|stop|restart}
"
}


# start
function start(){
  if [ ! -e "$sock_path" ]
    then
      printf "Starting MySQL...
"
      $path/mysqld_safe --defaults-file=/data/$port/my.cnf > /dev/null 2>&1 &   
    else
      printf "MySQL is running...
"
      exit  
 fi
}

# stop
function stop(){
  if [ ! -e "$sock_path" ]
    then
      printf "MySQL is stoped...
"
      exit
 else
      printf "Stoping MySQL...
"
      $path/mysqladmin -u$user -p$pass -S /data/$port/mysql.sock shutdown 
 fi
}

# restart
function restart(){
     printf "Restart MySQL...
"
     stop
     sleep 2
     start
}

case $1 in
  start)
    start
  ;;
  stop)
    stop
  ;;
  restart)
    restart
  ;;
  *)
    usage
  ;;
esac