[#9(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 usage:sh /etc/init.d/onesql5.6.26 {start|stop|restart|status}
详细执行效果如下：
[#2(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 statusthere is no mysqld process ! [#3(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 stopthe mysqld process is already stopped ! [#4(zhouxx_vm(node3:192.168.56.103))#root@node3~]#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))#root@node3~]#[#5(zhouxx_vm(node3:192.168.56.103))#root@node3~]#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: root@localhostssl: 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))#root@node3~]#[#6(zhouxx_vm(node3:192.168.56.103))#root@node3~]#[#6(zhouxx_vm(node3:192.168.56.103))#root@node3~]#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))#root@node3~]#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))#root@node3~]#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: root@localhostssl: 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))#root@node3~]#
详细脚本
[#10(zhouxx_vm(node3:192.168.56.103))#root@node3~]#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.cnfmysql_sock=/tmp/mysql_3307.sockfunction start(){mysqld_pid=`ps -ef|grep mysqld|grep $mysql_sock |grep -ve 'grep|mysqld_safe'|awk '{print $2}'`if [ 0 = $mysqld_pid0 ]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_pid0 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_pid0 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_pidfi}function stop(){mysqld_pid=`ps -ef|grep mysqld|grep $mysql_sock |grep -ve 'grep|mysqld_safe'|awk '{print $2}'`if [ 0 = $mysqld_pid0 ]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_pid0 ]then echo stopping mysql$pppct success! else mysqld_pid1=$mysqld_pid0 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_pid0 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_pid0 ]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 \nfi}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))#root@node3~]#