多台机器部署MySQL脚本

shell脚本实现多机部署mysql数据库

root@localhost ~]# vim mysql_install.sh
#!/bin/bash
#mysql intall 2
#by tianyun
#Yum 
rm -rf /etc/yum.repos.d/*
wget ftp://172.16.8.100/yumrepo/centos7.repo -P /etc/yum.repos.d/
wget ftp://172.16.8.100/yumrepo/mysql57.repo -P /etc/yum.repos.d/
yum -y install lftp vim-enhanced bash-completion
 
#Firewalld & SELinux
systemctl stop firewalld; systemctl disable firewalld
setenforce 0; sed -ri '/^SELINUX/c\SELINUX=disabled' /etc/seLinux/config
 
#ntp
yum -y install chrony
sed -ri '/3.centos/a\server 172.16.8.100 iburst' /etc/chrony.conf
systemctl start chronyd; systemctl enable chronyd
 
#install mysql5.7
yum -y install mysql-community-server
systemctl start mysqld
systemctl enable mysqld
grep 'temporary password' /var/log/mysqld.log |awk '{print $NF}' > /root/mysqloldpass.txt
mysqladmin -uroot -p"`cat /root/mysqloldpass.txt`" password "(TianYunYang123)"

使用shell循环实现多台服务器安装部署mysql，具体示例代码如下所示。

[root@localhost ~]# vim ip.txt
10.0.104.5
10.0.104.27
10.0.104.34
10.0.104.136
10.0.104.108
[root@localhost ~]# vim main.sh
#!/bin/bash
#main
while read ip
do
	{
	ping -c 1 -W 2 $ip > /dev/null
	if [ $? -eq 0 ];then
	    scp -r mysql_install.sh root@$ip:/tmp/
	    ssh root@$ip "/tmp/mysql_install.sh"
	}&
done < ip.txt
wait
echo "all finish..."