shell脚本 mysql主从搭建配置

mysql-A主

#!/bin/bash
#mysql-A
echo "开始配置mysql主..."
systemctl stop firewalld
setenforce 0
echo "防火墙关闭成功..."
rpm -qa | grep mariadb
if [ $? -eq 0 ];then
	echo "mysql/mariadb已经安装..."
	systemctl start mariadb
else
	echo "开始安装mariadb..."
	yum -y install mariadb mariadb-server
	echo "安装完成..."
fi
echo "mysql配置文件..."
#向mysql配置文件里插入数据，开启二进制日志，不同步mysql等的三个库
sed -i '10i\server-id=1' /etc/my.cnf
sed -i '11i\log-bin=mysql-bin' /etc/my.cnf
sed -i '12i\relay-log=relay-log' /etc/my.cnf
#sed -i '12i\binlog-ignore-db=information_schema' /etc/my.cnf #不同步
#sed -i '13i\binlog-ignore-db=performance_schema' /etc/my.cnf #不同步
#sed -i '14i\binlog-ignore=mysql' /etc/my.cnf #不同步
systemctl restart mariadb
if [ $? -eq 0 ];then
	echo "mysql已经,开始创建用户.."
	mysql -e "grant all on *.* to 'ja'@'%' identified by '123';"
	mysql -e "flush privileges;"
	mysql -e "show master status;" | awk 'NR==2 {print $1}' &> /etc/aaa
	mysql -e "show master status;" | awk 'NR==2 {print $2}' &> /etc/bbb
	echo "mysql配置完成..."
	read -ep "请输入传送的用户:" user
	read -ep "请输入传送的ip地址:" ip
	if [ $? -eq 0 ];then
		scp /etc/aaa $user@$ip:/root
		scp /etc/bbb $user@$ip:/root
		echo "传送完成..."
	else
		echo "传送失败.."
	fi
else
	echo "mysql配置失败"
fi

mysql-B从

#!/bin/bash
#mysql-B
echo "开始配置mysql主..."
systemctl stop firewalld
setenforce 0
echo "防火墙关闭成功..."
rpm -qa | grep mariadb-server
if [ $? -eq 0 ];then
        echo "mysql/mariadb已经安装..."
else
        echo "开始安装mariadb..."
        yum -y install mariadb mariadb-server
        echo "安装完成..."
fi
echo "修改mysql配置文件..."
#修改mysql从的配置文件
sed -i '10i\server-id=3' /etc/my.cnf 
sed -i '11i\log-bin=mysql-bin' /etc/my.cnf #开启二进制日志
sed -i '12i\relay_log=relaylogs' /etc/my.cnf #开启中继日志
read -ep "请输入master_host地址:" host
read -ep "请输入master_user用户:" user
read -ep "请输入master_password密码:" passwd
find -name aaa &>/etc/rz
if [ $? -eq 0 ];then
	echo "mysql主日志文件传送成功开始配置..."
	echo "配置完成"
else
	echo "没有mysql主的日志文件.."
fi
file=$(awk '{print $1}' aaa)
pos=$(awk '{print $1}' bbb)
systemctl start mariadb
if [ $? -eq 0 ];then
	echo "mysql已经启动.."
	mysql -e "stop slave;"
	mysql -e "change master to master_host='$host',master_user='$user',master_password='$passwd',master_log_file='$file',master_log_pos=$pos;"
	mysql -e "start slave;"
	sleep 20
	mysql -e "show slave status \G;"
else
	echo "配置失败..."
fi