mysql5.5多实例安装
#3307数据库启动脚本#!/bin/bash
#author:sqw 2015年6月5日
mysql_port=3307
mysql_username="root"
mysql_password="123qwe"
mysql_safe="/data/3307mysql/server/bin/mysqld_safe"
mysql_cnf="/data/3307mysql/server/my.cnf"
mysql_sock="/data/3307mysql/mysql.sock"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh ${mysql_safe} --defaults-file=${mysql_cnf} 2>&1 > /dev/null &
printf "Starting MySQL...success!\n"
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/data/3307mysql/server/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S ${mysql_sock} shutdown 2>/dev/null
printf "Stoping MySQL...success!\n"
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep '3307mysql/server' |grep -v grep| grep -v mysqld_safe|awk '{print $2}')
kill -9 $(ps -ef | grep '3307mysql/server' |grep -v grep|awk '{print $2}')
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/3307mysql/my3307.sh {start|stop|restart|kill}
------start 启动
------stop 停止
------restart重启
------kill 强制杀掉进程
";;
esac
#mysql3308启动脚本
#!/bin/bash
#author:sqw 2015年6月5日
mysql_port=3308
mysql_username="root"
mysql_password="123qwe"
mysql_safe="/data/3308mysql/server/bin/mysqld_safe"
mysql_cnf="/data/3308mysql/server/my.cnf"
mysql_sock="/data/3308mysql/mysql.sock"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh ${mysql_safe} --defaults-file=${mysql_cnf} 2>&1 > /dev/null &
printf "Starting MySQL...success!\n"
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/data/3308mysql/server/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S ${mysql_sock} shutdown 2>/dev/null
printf "Stoping MySQL...success!\n"
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep '3308mysql/server' |grep -v grep| grep -v mysqld_safe|awk '{print $2}')
kill -9 $(ps -ef | grep '3308mysql/server' |grep -v grep|awk '{print $2}')
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/3308mysql/my3308.sh {start|stop|restart|kill}
------start 启动
------stop 停止
------restart重启
------kill 强制杀掉进程
";;
esac
#mysql3309数据库启动脚本
#!/bin/bash
#author:sqw 2015年6月5日
mysql_port=3309
mysql_username="root"
mysql_password="123qwe"
mysql_safe="/data/3309mysql/server/bin/mysqld_safe"
mysql_cnf="/data/3309mysql/server/my.cnf"
mysql_sock="/data/3309mysql/mysql.sock"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh ${mysql_safe} --defaults-file=${mysql_cnf} 2>&1 > /dev/null &
printf "Starting MySQL...success!\n"
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/data/3309mysql/server/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S ${mysql_sock} shutdown 2>/dev/null
printf "Stoping MySQL...success!\n"
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep '3309mysql/server' |grep -v grep| grep -v mysqld_safe|awk '{print $2}')
kill -9 $(ps -ef | grep '3309mysql/server' |grep -v grep|awk '{print $2}')
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/3309mysql/my3309.sh {start|stop|restart|kill}
------start 启动
------stop 停止
------restart重启
------kill 强制杀掉进程
";;
esac
页:
[1]