shell学习二十一--使用if编写mysql启动脚本

ゞ浴缸里的玫瑰 2022-06-05 04:50 226阅读 0赞

例子：开发mysql单实例或者多实例启动脚本  
已知mysql多实例启动命令为：  
mysqld\_safe --deafaults-file=/data/3306/my.cnf &  
停止命令  
mysqladmin -u root -p123 -S /data/3306/mysql.sock shutdown  
请完成mysql单实例或者多实例启动脚本编写。  
要求：用函数、if语句等实现。  
解答：单实例  
1、启动：mysql\_safe --user=mysql &  
2、停止：mysqladmin -u root -p123  shutdown  
\[root@node01 day7\]\# mysql -uroot -p123  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 2  
Server version: 5.1.73 Source distribution  
  
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql>  
\[root@node01 day7\]\# mysqladmin -uroot -p123  shutdown   
\[root@node01 day7\]\# ps -ef|grep mysql                  
root       6689  93648  0 02:18 pts/5    00:00:00 grep mysql  
\[root@node01 day7\]\#   
\[root@node01 day7\]\# lsof -i :3306  
  
实际脚本  
\[root@node01 day8\]\# cat start\_db.sh   
\#!/bin/sh  
  
function usage()\{  
   echo "$0 \{start|stop|restart\}"  
   exit 1  
\}  
\[ $\# -ne 1 \] && usage  
  
  
  
function start\_mysql()\{  
   mysqld\_safe --user=mysql &  
   if \[ $? -eq 0 \]  
     then  
       action "start mysql" /bin/true  
   else  
       action "start mysql" /bin/false  
   fi  
\}  
function stop\_mysql()\{  
   mysqladmin -u root -p123  shutdown  
   if \[ $? -eq 0 \]  
     then  
       action "stop mysql" /bin/true  
   else  
       action "stop mysql" /bin/false  
   fi  
\}  
  
if \[ "$1" == "start" \]  
  then  
     start\_mysql  
elif \[ "$1"  == "stop" \]  
  then  
     stop\_mysql  
elif \[ "$1" == "restart" \]  
  then  
    stop\_mysql  
    start\_mysql  
else  
  usage  
fi  
\[root@node01 day8\]\# sh start\_db.sh stop         
170803 02:39:44 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended  
start\_db.sh: line 23: action: command not found  
\[1\]+  Done                    mysqld\_safe --user=mysql  
\[root@node01 day8\]\# ps -ef|grep mysql  
root       7017  93648  0 02:39 pts/5    00:00:00 grep mysql  
\[root@node01 day8\]\# lsof -i :3306  
\[root@node01 day8\]\# sh start\_db.sh start  
start\_db.sh: line 14: action: command not found  
\[root@node01 day8\]\# 170803 02:40:02 mysqld\_safe Logging to '/var/log/mysqld.log'.  
170803 02:40:02 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
  
\[root@node01 day8\]\#   
\[root@node01 day8\]\#   
\[root@node01 day8\]\#   
\[root@node01 day8\]\#   
\[root@node01 day8\]\#   
\[root@node01 day8\]\# lsof -i :3306         
COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME  
mysqld  7107 mysql   10u  IPv4 962425      0t0  TCP \*:mysql (LISTEN)  
\[root@node01 day8\]\# ps -ef|grep mysql     
root       7022      1  0 02:40 pts/5    00:00:00 /bin/sh /usr/bin/mysqld\_safe --user=mysql  
mysql      7107   7022  0 02:40 pts/5    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock  
root       7130  93648  0 02:40 pts/5    00:00:00 grep mysql  
\[root@node01 day8\]\# mysql -uroot -p123    
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 1  
Server version: 5.1.73 Source distribution  
  
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql>   
带入路径（生产中带上路径）  
\[root@node01 day8\]\# vi start\_db.sh   
\#!/bin/sh  
. /etc/init.d/functions  
path=/usr/bin/  
function usage()\{  
   echo "$0 \{start|stop|restart\}"  
   exit 1  
\}  
\[ $\# -ne 1 \] && usage  
  
function start\_mysql()\{  
   $path/mysqld\_safe --user=mysql &  
   if \[ $? -eq 0 \]  
     then  
       action "start mysql" /bin/true  
   else  
       action "start mysql" /bin/false  
   fi  
\}  
function stop\_mysql()\{  
   mysqladmin -u root -p123  shutdown  
   if \[ $? -eq 0 \]  
     then  
       action "stop mysql" /bin/true  
   else  
       action "stop mysql" /bin/false  
   fi  
\}  
  
if \[ "$1" == "start" \]  
  then  
     start\_mysql  
elif \[ "$1"  == "stop" \]  
  then  
     stop\_mysql  
elif \[ "$1" == "restart" \]  
  then  
    stop\_mysql  
    start\_mysql  
"start\_db.sh" 43L, 678C written                                                                                                                        
You have new mail in /var/spool/mail/root  
\[root@node01 day8\]\# sh start\_db.sh stop  
170803 02:44:23 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended  
stop mysql                                                 \[  OK  \]  
\[root@node01 day8\]\# ps -ef|grep mysql     
root       7175  93648  0 02:44 pts/5    00:00:00 grep mysql  
\[root@node01 day8\]\# sh start\_db.sh start  
start mysql                                                \[  OK  \]  
\[root@node01 day8\]\# 170803 02:44:32 mysqld\_safe Logging to '/var/log/mysqld.log'.  
170803 02:44:32 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
  
\[root@node01 day8\]\#   
\[root@node01 day8\]\# ps -ef|grep mysql     
root       7179      1  0 02:44 pts/5    00:00:00 /bin/sh /usr/bin//mysqld\_safe --user=mysql  
mysql      7264   7179  0 02:44 pts/5    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock  
root       7278  93648  0 02:44 pts/5    00:00:00 grep mysql  
  
优化脚本  
\[root@node01 day8\]\# vi start\_db.sh sart  
2 files to edit  
\#!/bin/sh  
. /etc/init.d/functions  
path=/usr/bin/  
pass=123  
user=root  
function usage()\{  
   echo "$0 \{start|stop|restart\}"  
   exit 1  
\}  
\[ $\# -ne 1 \] && usage  
  
function start\_mysql()\{  
   $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\_mysql()\{  
   mysqladmin -u$user -p$pass shutdown >/dev/null 2>&1  
   if \[ $? -eq 0 \]  
     then  
       action "stop mysql" /bin/true  
   else  
       action "stop mysql" /bin/false  
   fi  
\}  
  
if \[ "$1" == "start" \]  
  then  
     start\_mysql  
elif \[ "$1"  == "stop" \]  
  then  
     stop\_mysql  
elif \[ "$1" == "restart" \]  
  then  
    stop\_mysql  
    start\_mysql  
\[root@node01 day8\]\# sh start\_db.sh start  
start mysql                                                \[  OK  \]  
You have new mail in /var/spool/mail/root  
\[root@node01 day8\]\# 170803 02:46:55 mysqld\_safe Logging to '/var/log/mysqld.log'.  
170803 02:46:55 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
  
去除启动时的log  
\[root@node01 day8\]\# cat start\_db.sh   
\#!/bin/sh  
. /etc/init.d/functions  
path=/usr/bin/  
pass=123  
user=root  
function usage()\{  
   echo "$0 \{start|stop|restart\}"  
   exit 1  
\}  
\[ $\# -ne 1 \] && usage  
  
function start\_mysql()\{  
   $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\_mysql()\{  
   mysqladmin -u$user -p$pass  shutdown >/dev/null 2>&1  
   if \[ $? -eq 0 \]  
     then  
       action "stop mysql" /bin/true  
   else  
       action "stop mysql" /bin/false  
   fi  
\}  
  
if \[ "$1" == "start" \]  
  then  
     start\_mysql  
elif \[ "$1"  == "stop" \]  
  then  
     stop\_mysql  
elif \[ "$1" == "restart" \]  
  then  
    stop\_mysql  
    start\_mysql  
else  
  usage  
fi  
把脚本copy 到/etc/init.d/下  
mv start\_db.sh mysqld  
chmod +x mysqld  
实现/etc/init.d/mysql01 start启动，并且通过chkconfig设置开机自启动和关闭。  
\#!/bin/sh  
\# chkconfig: 2345 21 60   （启动顺序不要和已有的冲突）  
\# description: start mysql and stop mysql scripts.  
  
\[root@node01 day8\]\# cp start\_db.sh /etc/init.d/mysql01  
\[root@node01 day8\]\# chkconfig --add mysql01  
\[root@node01 day8\]\# chkconfig --list mysql01  
mysql01         0:off   1:off   2:on    3:on    4:on    5:on    6:off  
\[root@node01 day8\]\# ll /etc/rc.d/rc3.d/ |grep mysql01  
lrwxrwxrwx  1 root root 17 Aug  3 03:26 S21mysql01 -> ../init.d/mysql01