设为首页 加入收藏

TOP

case语句编写mysql启动脚本
2017-11-23 08:31:50 】 浏览:58
Tags:case 语句 编写 mysql 启动 脚本

例子:开发mysql单实例或者多实例启动脚本

已知mysql多实例启动命令为:

mysqld_safe --deafaults-file=/data/3306/my.cnf &

停止命令

mysqladmin -u root -p123 -S /data/3306/mysql.sock shutdown

请完成mysql单实例或者多实例启动脚本编写。

要求:用函数、case语句等实现。

[root@node01 day10]# vi start_db.sh

#!/bin/sh

# chkconfig: 2345 35 67

# description: start rsync and stop rsync scripts.

. /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

}

case "$1" in

start)

start_mysql

RETVAL=$?

;;

stop)

stop_mysql

RETVAL=$?

;;

restart)

stop_mysql

sleep 2

start_mysql

RETVAL=$?

;;

*)

usage

esac

[root@node01 day10]# sh start_db01.sh start

start mysql [ OK ]

[root@node01 day10]# sh start_db01.sh stop

stop mysql [ OK ]

[root@node01 day10]# sh start_db01.sh restart

stop mysql [FAILED]

start mysql [ OK ]

[root@node01 day10]# 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>

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇mysql和JDBC的常用语句、Update操.. 下一篇pg数据库查询重复数据并可识别空..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目