加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 综合聚焦 > 服务器 > 安全 > 正文

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

发布时间：2020-12-15 09:16:12 所属栏目：安全 来源：网络整理
导读：例子：开发mysql单实例或者多实例启动脚本 已知mysql多实例启动命令为： mysqld_safe --deafaults-file=/data/3306/my.cnf 停止命令 mysqladmin -u root -p123 -S /data/3306/mysql.sock shutdown 请完成mysql单实例或者多实例启动脚本编写。 要求：用函数、i
例子：开发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,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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同