linux ssh 集群 mysql脚本

创建脚本文件

[root@mihaoyu151 opt]# vi ./opmysql.sh

脚本内容

#!/bin/bash
case $1 in
"start")
	for host in mihaoyu151 mihaoyu152 mihaoyu153 mihaoyu154 mihaoyu155
	do
				ssh $host "systemctl start mysqld"
	done
;;
"stop")
        for host in mihaoyu151 mihaoyu152 mihaoyu153 mihaoyu154 mihaoyu155
	do
                ssh $host "systemctl stop mysqld"
	done
;;
"status")
        for host in mihaoyu151 mihaoyu152 mihaoyu153 mihaoyu154 mihaoyu155
	do
                ssh $host "systemctl status mysqld"
	done
;;
"restart")
        for host in mihaoyu151 mihaoyu152 mihaoyu153 mihaoyu154 mihaoyu155
	do
                ssh $host "systemctl stop mysqld"
                ssh $host "systemctl start mysqld"
	done
;;
esac

赋予执行权限

[root@mihaoyu151 opt]# chmod +x ./opmysql.sh

执行脚本

[root@mihaoyu151 opt]# ./opmysql.sh status