Shulou(Shulou.com)06/01 Report--

! / bin/bash

User=root

Port=3306

CmdPath=/opt/mysql/bin

Password=xxxxxxxxxx

Base_dir=/opt/mysql

Inst_dir=/data/3306

Alive= "00"

SMysqld=0

SMysqldSafe=0

FSock=0

FPID=0

Check_alive ()

{

Echo "running check_alive..."

If [ps-ef | grep $port | grep-v grep | grep 'mysqld' | awk'{print $2}']; then

Echo "Process mysqld is running!"

SMysqld=1

Else

Echo "Process mysqld is not running!"

SMysqld=0

Fi

If [`ps-ef | grep 3306 | grep-v grep | grep 'mysqld_safe' | awk' {print $2}'`]; then echo "Process mysqld_safe is running!" SMysqldSafe=1 else echo "Process mysqld_safe is not running!" SMysqldSafe=0 fi if [- e ${inst_dir} / mysql.sock]; then echo "socked file exists!" FSock=1 else echo "socked file not exists!" FSock=0 fi if [- e ${inst_dir} / mysql.pid]; then echo "pid file exists!" FPID=1 else echo "pid file not exists!" FPID=0 fi if [$sMysqld-eq 1]; then if [$fPID-eq 0]; then echo "PID is missing, tring to recreate..." Ps-ef | grep $port | grep-v grep | grep 'mysqld' | awk'{print $2}'> ${inst_dir} / mysql.pid if [- e ${inst_dir} / mysql.pid]; then echo "pid file is created!" Else echo "can not create PID file, please have a check!" Fi fi if [$sMysqldSafe-eq 0]; then echo "Process mysqld_safe is missing, please have a check! May cause mysqld crash!" Fi if [$fSock-eq 1]; then echo "MySQL running fineholders!" Alive= "11" else echo "socket file is missing, you may have to login without socket!" Alive= "10" fi else echo "process mysqld is missing, mysql is stopped!" If [$fSock-eq 1] | [$fPID-eq 1]; then echo "mysql was stopped abnormality!" Echo "cleaning socket file and pid file" alive= "01" else alive= "00" fi fi

}

Start_mysql ()

{

Check_alive

Printf "MySQL is starting...\ n"

If [$alive = = "00"]; then

${CmdPath} / mysqld_safe-- defaults-file=$ {inst_dir} / my.cnf-- user=$ {user} 2 > & 1 > / dev/null &

Else

If [$alive = = "11"]; then

Echo "MySQL is runnig!"

Else

If [$alive = = "01"]; then

Echo "MySQL was stopped but pid or sock file still exits!"

Echo "Cleanning pid or sock files!"

If [$fSock-eq 1]; then

Rm-f ${inst_dir} / mysql.sock

Fi

If [$fPID-eq 1]; then

Rm-f ${inst_dir} / mysql.pid

Fi

Echo "Tring to start MySQL the kids!"

${CmdPath} / mysqld_safe-- defaults-file=$ {inst_dir} / my.cnf-- user=$ {user} 2 > & 1 > / dev/null &

Fi

Fi

Fi

}

Stop_mysql ()

{

Check_alive

Printf "MySQL is Stopping...\ n"

If [$alive = = "11"]; then

${CmdPath} / mysqladmin-u root-p ${password}-S ${inst_dir} / mysql.sock shutdown 2 > & 1 > / dev/null &

Else

If [$alive = = "10"]; then

${CmdPath} / mysqladmin-u root-p ${password}-h $HOSTNAME-P $port-- protocol tcp shutdown 2 > & 1 > / dev/null &

Else

Echo "MySQL is not running, no need stop!"

Fi

Fi

}

Restart_mysql ()

{

Stop_mysql

Sleep 5

If [$? = = 0]; then

Start_mysql

Else

Echo "stop mysql failed!"

Fi

}

Case $1 in

Start)

Start_mysql

Stop)

Stop_mysql

Restart)

Restart_mysql

Status)

Status_mysql

Alive)

Check_alive

*)

Printf "Please input start | stop | restart | status as input"

Esac

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.