shell脚本实现mariadb主从复制

mariadb主从复制

#!/bin/bash
# by author:Ryan
# 一键部署mariadb主从复制

MYSQL_SOFT="mariadb-server"
NUM=`rpm -qa | grep -i $MYSQL_SOFT | wc -l`
MASTER_MYSQL_IP=192.168.30.165
BACKUP_MYSQL_IP=192.168.30.195

#配置数据库yum源
config_mariadb_yum() {
cat>/etc/yum.repos.d/mariadb.repo<<EOF
[mariadb]
name=MariaDB
enabled=1
gpgcheck=1
gpgkey=http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
baseurl=http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64/
EOF
if [ $? -eq 0 ] ;then
        echo -e "********MariaDB yum源配置完毕！********\n"
fi
}

#下载并启动数据库函数
yum_install_mariadb(){
if [ -f "etc/yum.repos.d/mariadb.repo" -o $NUM -ne 0 ];then
        echo -e "*****yum源文件已存在！开始下载mariadb*****\n" 
        yum install $MYSQL_SOFT -y
else
        echo -e "********yum源文件不存在！********\n"
        echo "正在配置MariaDB yum源......"
        config_mariadb_yum