MySQL multi-instance MySQL service script

1.

 #initport =3306mysql_user= "root" mysql_pwd= "cancer" cmdpath= "/application/ Mysql/bin "mysql_sock="/data/${port}/mysql.sock "#startup functionfunction_start_mysql () {if [!-e" $mysql _sock "]; Then printf "Starting mysql...\n"/bin/sh ${cmdpath}/mysqld_safe--defaults-file=/data/${port}/my.cnf 2>&1 > /dev/null & Else printf "MySQL is running...\n" Exit fi} #stop Functionfunction_stop_mysql () {if [!-e "$mysql _s Ock "];then printf" MySQL is stopped...\n "exit else printf" stoping mysql...\n "${cmdpat H}/mysqladmin-u ${mysql_user}-p${mysql_pwd}-s/data/${port}/mysql.sock shutdown fi} #restart Functionfunction_resta Rt_mysql () {printf "restarting mysql...\n" Function_stop_mysql sleep 2 Function_start_mysql}case "in start) function _start_mysql;; stop) Function_stop_mysql;; restart) Function_restart_mysql;; *) printf "Usage:/data/${port}/mysql {start|stop|restart}\n" Esac 

http://blog.csdn.net/u011364306/article/details/47814409

2.

#!/bin/bashmysql_port=3307mysql_username= "admin" mysql_password= "password" function_start_mysql () {printf " Starting mysql...\n "/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/dbdata_${mysql_port}/my.cnf 2 >&1 >/dev/null &}function_stop_mysql () {printf "stoping mysql...\n"/usr/local/mysql/bin/mysqladmin-u $ {mysql_username}-p${mysql_password}-s/data/dbdata_${mysql_port}/mysql.sock Shutdown}function_restart_mysql () { printf "Restarting mysql...\n" Function_stop_mysqlfunction_start_mysql}function_kill_mysql () {kill-9 $ (ps-ef | grep ') Bin/mysqld_safe ' | grep ${mysql_port} | awk ' {printf} ') kill-9 $ (ps-ef | grep ' Libexec/mysqld ' | grep ${mysql_port} | awk ' {printf} ')}case $ instart) funct Ion_start_mysql;; stop) Function_stop_mysql;; Kill) Function_kill_mysql;; restart) Function_stop_mysqlfunction_start_mysql;; *) echo "Usage:/data/dbdata_${mysql_port}/mysqld {start|stop|restart|kill}";; Esac

　　

Http://blog.csdn.net/zhoufoxcn/article/details/73065655?utm_source=tuicool&utm_medium=referral

MySQL multi-instance MySQL service script