CentOS7-MySQL

MySQL启动脚本（start-mysql）

cd /usr/local/bin
sudo vi start-mysql

脚本内容如下：

#!/bin/bash
echo "start MySQL-------------------------------------------------"
for i in LTSR001
do 
ssh $i "source /etc/profile;service mysql start"
done
sleep 5s
echo "MySQL status------------------------------------------------"
for i in LTSR001
do 
echo ------------------- $i -------------- 
ssh $i "source /etc/profile;service mysql status"
done
exit 0

设置脚本执行权限：

sudo chmod +x start-mysql
sudo chown bigdata:bigdata start-mysql

MySQL停止脚本（stop-mysql）

cd /usr/local/bin
sudo vi stop-mysql

脚本内容如下：

#!/bin/bash
echo "stop MySQL-------------------------------------------------"
for i in LTSR001
do 
ssh $i "source /etc/profile;service mysql stop"
done
sleep 5s
echo "MySQL status------------------------------------------------"
for i in LTSR001
do 
echo ------------------- $i --------------
ssh $i "source /etc/profile;service mysql status"
done
exit 0

设置脚本执行权限：

sudo chmod +x stop-mysql
sudo chown bigdata:bigdata stop-mysql

MySQL状态查看脚本（status-mysql）

cd /usr/local/bin
sudo vi status-mysql

脚本内容如下：

#!/bin/bash
echo "MySQL status------------------------------------------------"
for i in LTSR001
do 
echo "${i}------------------------------------" 
ssh $i "source /etc/profile;service mysql status"
done
exit 0

设置脚本执行权限：

sudo chmod +x status-mysql
sudo chown bigdata:bigdata status-mysql