启停onesql，总共四个参数{start|stop|restart|status}，只要稍微改一下头部的三个文件路径，即可完成mysql单实例的启停。
[#9(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 Usage:sh /etc/init.d/onesql5.6.26 {start|stop|restart|status}
详细执行效果如下：
[#2(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 statusThere is no mysqld process ! [#3(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 stopThe mysqld process is already stopped ! [#4(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 startStarting MySQL.150830 13:15:06 mysqld_safe Logging to '/data/mysql/mysql_3307/logs/error3307.log'.150830 13:15:06 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3307/dataStarting MySQL.. SUCCESS! [#5(zhouxx_vm(node3:192.168.56.103))[email protected]~]#[#5(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 statusroot 2319 1 2 13:15 pts/0 00:00:00 /bin/sh /usr/local/onesql5.6/bin/mysqld_safe --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --basedir=/usr/local/onesql5.6mysql 3163 2319 44 13:15 pts/0 00:00:02 /usr/local/onesql5.6/bin/mysqld --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --basedir=/usr/local/onesql5.6 --datadir=/data/mysql/mysql_3307/data --plugin-dir=/usr/local/onesql5.6/lib/plugin --user=mysql --log-error=/data/mysql/mysql_3307/logs/error3307.log --open-files-limit=58000 --pid-file=/data/mysql/mysql_3307/logs/mysql_3307.pid --socket=/tmp/mysql_3307.sock --port=3307MySQL(pid=3163) Status --------------/usr/local/onesql5.6/bin/mysql Ver 14.14 Distrib 5.6.25, for Linux (x86_64) using EditLine wrapperConnection id: 4Current database:Current user: [email protected]SSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.26-log (OneSQL) Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /tmp/mysql_3307.sockUptime: 5 secThreads: 4 Questions: 5 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11 Queries per second avg: 1.000--------------[#6(zhouxx_vm(node3:192.168.56.103))[email protected]~]#[#6(zhouxx_vm(node3:192.168.56.103))[email protected]~]#[#6(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 stop150830 13:15:19 mysqld_safe mysqld from pid file /data/mysql/mysql_3307/logs/mysql_3307.pid endedStopping MySQL SUCCESS! [#7(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 restartThe mysqld process is already stopped ! 150830 13:15:32 mysqld_safe Logging to '/data/mysql/mysql_3307/logs/error3307.log'.150830 13:15:32 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3307/dataStarting MySQL. SUCCESS! [#8(zhouxx_vm(node3:192.168.56.103))[email protected]~]#service onesql5.6.26 statusroot 3266 1 3 13:15 pts/0 00:00:00 /bin/sh /usr/local/onesql5.6/bin/mysqld_safe --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --basedir=/usr/local/onesql5.6mysql 4107 3266 63 13:15 pts/0 00:00:02 /usr/local/onesql5.6/bin/mysqld --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --basedir=/usr/local/onesql5.6 --datadir=/data/mysql/mysql_3307/data --plugin-dir=/usr/local/onesql5.6/lib/plugin --user=mysql --log-error=/data/mysql/mysql_3307/logs/error3307.log --open-files-limit=58000 --pid-file=/data/mysql/mysql_3307/logs/mysql_3307.pid --socket=/tmp/mysql_3307.sock --port=3307MySQL(pid=4107) Status --------------/usr/local/onesql5.6/bin/mysql Ver 14.14 Distrib 5.6.25, for Linux (x86_64) using EditLine wrapperConnection id: 4Current database:Current user: [email protected]SSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.26-log (OneSQL) Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /tmp/mysql_3307.sockUptime: 4 secThreads: 4 Questions: 5 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11 Queries per second avg: 1.250--------------[#9(zhouxx_vm(node3:192.168.56.103))[email protected]~]#
详细脚本
[#10(zhouxx_vm(node3:192.168.56.103))[email protected]~]#cat /etc/init.d/onesql5.6.26 #!/bin/sh##source /etc/profile#MYSQL_HOME=/usr/local/mysql5.6.26MYSQL_HOME=/usr/local/onesql5.6datadir=/data/mysql/mysql_3307/datamysql_cnf="/data/mysql/mysql_3307/my_3307.cnf"mysql_sock="/tmp/mysql_3307.sock"function start(){mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'`if [ "0" = "$mysqld_pid"0 ]then $MYSQL_HOME/bin/mysqld_safe --defaults-file="$mysql_cnf" --user=mysql --datadir="$datadir" --basedir="$MYSQL_HOME" & sleep 1 mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'` mysqld_pid1="$mysqld_pid"0 pppct="." while [[ $mysqld_pid1 -lt 1 ]] do mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'` mysqld_pid1="$mysqld_pid"0 if [ $mysqld_pid1 -gt 1 ] then #clear echo "Starting MySQL$pppct SUCCESS! " else #clear echo "Starting MySQL$pppct" fi pppct="$pppct." sleep 1 doneelse echo "A mysqld process already exists ! pid:$mysqld_pid"fi}function stop(){mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'`if [ "0" = "$mysqld_pid"0 ]then echo "The mysqld process is already stopped ! "else#/usr/local/mysql/bin/mysqladmin –S "$mysql_sock" shutdown &$MYSQL_HOME/bin/mysqladmin -S "$mysql_sock" shutdown &sleep 2mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'`if [ "0" = "$mysqld_pid"0 ]then echo "Stopping MySQL$pppct SUCCESS! "else mysqld_pid1="$mysqld_pid"0 pppct="." while [ "$mysqld_pid1" != "0" ] do mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'` mysqld_pid1="$mysqld_pid"0 if [ "$mysqld_pid1" = "0" ] then #clear echo "Stopping MySQL$pppct SUCCESS! " else #clear echo "Stopping MySQL$pppct" fi pppct="$pppct." sleep 1 donefifi}function status(){mysqld_pid=`ps -ef|grep mysqld|grep "$mysql_sock" |grep -vE 'grep|mysqld_safe'|awk '{print $2}'`if [ "0" = "$mysqld_pid"0 ]then echo "There is no mysqld process ! "else echo -e "\n" ps -ef|grep mysqld|grep "$mysql_cnf"|grep -v grep echo -e "MySQL(pid=$mysqld_pid) Status \n " #mysqladmin -S "$mysql_sock" status $MYSQL_HOME/bin/mysql -S "$mysql_sock" -e "\s;" echo -e "\n"fi}case "$1" instart) start ;;stop) stop ;;status) status ;;restart) stop start ;;*) echo "Usage:sh $0 {start|stop|restart|status}" esacexit[#11(zhouxx_vm(node3:192.168.56.103))[email protected]~]#
版权声明：声明：本文档可以转载，须署名原作者。 作者：无为 qq:490073687