mysql主从脚本--从

标题mysql主从脚本–从

#!/bin/bash


echo "关闭防火墙"
systemctl stop firewalld.service
setenforce 0
#判断防火墙是否关闭
if [ $? -eq 0 ];then
        echo "防火墙关闭成功"
else
        echo "防火墙关闭失败"
fi


#查看数据库是否安装
rpm -qa | grep mariadb &> /dev/null
#判断返回值是否等于0
if [ $? -eq 0 ];then
        echo "已安装mariadb"
        yum -y remove mariadb mariadb-libs-5.5.64-1.el7.x86_64 mariadb-server-5.5.64-1.el7.x86_64 mariadb-5.5.64-1.el7.x86_64 &> /dev/null
        if [ $? -eq 0 ];then
                echo "已经删除数据库 安装数据库"
                yum -y install mariadb mariadb-server &> /dev/null
        fi
else
        echo "没有安装数据库，正在安装数据库"
        yum -y install mariadb mariadb-server &> /dev/null   # 安装数据库
        if [ $? -eq 0 ];then     #判断是否安装成功
                echo "安装成功"
        else
                echo "安装失败 重新安装"
                yum -y install mariadb mariadb-server &> /dev/null
        fi
fi

#修改从mysql配置文件
echo "编写my.cnf文件"
sed -i '10aserver-id=2' /etc/my.cnf
sed -i '11alog-bin=mysql-bin' /etc/my.cnf
sed -i '12arelay-log=relay-log' /etc/my.cnf


echo "启动数据库"
systemctl start mariadb
if [ $? -eq 0 ];then
        echo "数据库启动成功"
else
        echo "数据库启动失败 请检查配置文件文件"
fi

#过滤日志文件和pos
file=`mysql -utom -p123456 -h192.168.116.195 -e "show master status;" | awk '/mysql-bin/{print $1}'`
file=`mysql -utom -p123456 -h192.168.116.195 -e "show master status;" | awk '/mysql-bin/{print $1}'`

echo "关闭slave"
mysql -e "stop slave"

mysql -e "change master to master_host='192.168.116.195',master_user='tom',master_password='123456',master_log_file='${file}',master_log_pos=${pos};"

echo "启动slave"
mysql -e 'start slave;'

echo "查看双YES"
#过滤出双YES
mysql -e 'show slave status \G' | grep 'Yes'
if [ $? -eq 0 ];then
        echo "mysql主从搭建成功"
else
        echo "mysql主从搭建失败检查配置"
fi