使用Shell脚本高效部署MHA高可用集群

#!/bin/bash
#AUTHOR:AN
#VERSION&＃xff1a;1.1.1
#DATE:2019-05-21
#MODIFY:2019-05-24 2019-05-31
#FUNCTION:MHA高可用集群#加载配置文件
source /cloud_nsd/conf/mysql.conf
#加载函数库
if [ -f "$Script_Path/myfunction.lib" ];thensource $Script_Path/myfunction.lib
elseecho -e "\033[31m函数库不存在\033[0m"exit $NOEXIST
fi
###############################################################初始化环境(50秒)
INIT(){#实现免密登陆bash $Script_Path/Pssh.sh -p#安装Perl依赖包yum -y install perl-DBD-mysql perl-DBIyum -y install $Soft_Path/mysql/mha-soft-student/perl-*.rpmrpm -ivh $Soft_Path/mysql/mha-soft-student/mha4mysql-node-0.56-0.el6.noarch.rpm #node节点
}#修改配置文件&＃xff0c;设置半同步&＃xff0c;开启binlog日志
CONFIG(){cp $Mysql_Conf $Mysql_Conf.bak #备份配置文件sed -i &＃39;/\[mysqld\]/a relay_log_purge&＃61;off&＃39; $Mysql_Conf #关闭中继日志自动清除sed -i &＃39;/\[mysqld\]/a binlog-format&＃61;"mixed"&＃39; $Mysql_Conf sed -i "/\[mysqld\]/a log-bin&＃61;$HOSTNAME" $Mysql_Confsed -i "/\[mysqld\]/a server_id&＃61;$Server_Id" $Mysql_Confsed -i &＃39;/\[mysqld\]/a rpl-semi-sync-slave-enabled&＃61;1&＃39; $Mysql_Conf #从库半同步sed -i &＃39;/\[mysqld\]/a rpl-semi-sync-master-enabled&＃61;1&＃39; $Mysql_Conf #主库半同步sed -i &＃39;/\[mysqld\]/a plugin-load&＃61;"rpl_semi_sync_master&＃61;semisync_master.so;rpl_semi_sync_slave&＃61;semisync_slave.so"&＃39; $Mysql_Conf #加载主从半同步模块
}#选择主库
SELECT_MASTER(){ mysql -uroot -p$Mysql_Pwd -e "change master to master_host&＃61;$Master_Slave_Ip,master_user&＃61;$Master_User,master_password&＃61;$Master_Passwd,master_log_file&＃61;$Master_Log,master_log_pos&＃61;$Master_Pos"mysql -uroot -p$Mysql_Pwd -e "start slave"Io_Thread&＃61;&＃96;mysql -uroot -p$Mysql_Pwd -e "show slave status\G" |grep &＃39;Slave_IO_Running&＃39; |awk &＃39;{print $2}&＃39;&＃96;Sql_Thread&＃61;&＃96;mysql -uroot -p$Mysql_Pwd -e "show slave status\G" |grep &＃39;Slave_SQL_Running:&＃39; |awk &＃39;{print $2}&＃39;&＃96;if [ "$Io_Thread" &＃61;&＃61; "Yes" -a "$Sql_Thread" &＃61;&＃61; "Yes" ];thencecho 36 "主从同步成功"else cecho 31 "主从同步失败"exit $ISERRORfi
}##############################################################
#配置主服务器&＃xff08;17秒&＃xff09;
MASTER(){ Float_Ip&＃61;&＃96;echo $Vip |sed -r &＃39;s/(.)(.*)(.)/\2/&＃39;&＃96; #浮动IP&＃xff08;192.168.4.100/24&＃xff09;ifconfig $Nic:1 $Float_Ip #在主服务器上配置VIP CONFIGsystemctl restart mysqld#添加客户端访问账户mysql -uroot -p$Mysql_Pwd -e "grant insert,select on *.* to $Client_User&＃64;$Grant_Net identified by $Client_Pwd"#添加管理主机远程连接数据库的用户(监控用户)mysql -uroot -p$Mysql_Pwd -e "grant all on *.* to $Moni_User&＃64;$Grant_Net identified by $Moni_Passwd"#添加主从同步授权用户mysql -uroot -p$Mysql_Pwd -e "grant all on *.* to $Master_User&＃64;$Grant_Net identified by $Master_Passwd"mysql -uroot -p$Mysql_Pwd -e "show grants for $Moni_User" && cecho 36 "监控用户添加成功"mysql -uroot -p$Mysql_Pwd -e "show grants for $Master_User" && cecho 36 "同步授权用户添加成功"[ $? -ne 0 ] && ERROR MASTER && exit $CONFERROR
}#配置备用主服务器&＃xff08;9秒&＃xff09;
BACKUP_MASTER(){CONFIGsystemctl restart mysqldSELECT_MASTER && cecho 36 "备用主服务器配置成功"
}#配置数据备份服务器&＃xff08;9秒&＃xff09;
DATA_BACKUP(){cp $Mysql_Conf $Mysql_Conf.bak #备份配置文件sed -i &＃39;/\[mysqld\]/a relay_log_purge&＃61;off&＃39; $Mysql_Conf sed -i "/\[mysqld\]/a server_id&＃61;$Server_Id" $Mysql_Confsed -i &＃39;/\[mysqld\]/a rpl-semi-sync-slave-enabled&＃61;1&＃39; $Mysql_Confsed -i &＃39;/\[mysqld\]/a plugin-load&＃61;"rpl_semi_sync_slave&＃61;semisync_slave.so"&＃39; $Mysql_Confsystemctl restart mysqldSELECT_MASTER && cecho 36 "数据备份服务器配置成功"
}#配置管理主机(35)
MANAGER(){ Master_Host&＃61;&＃96;echo $Master_Slave_Ip |sed -r &＃39;s/(.)(.*)(.)/\2/&＃39;&＃96;yum -y install perl-ExtUtils-* perl-CPAN-*CA_TAR $Soft_Path/mysql/mha-soft-student/mha4mysql-manager-0.56.tar.gz #manager节点cd /opt/mha4mysql-manager-0.56cecho 32 "安装MHA....."perl Makefile.PL && make && make install MKDIR &＃96;dirname $Mha_Conf&＃96; #创建目录/etc/mha_managertouch $Mha_Conf#故障切换脚本cp $Soft_Path/mysql/mha-soft-student/master_ip_failover &＃96;dirname $Mha_Conf&＃96;sed -i "35c my \$vip &＃61; $Vip; \# Virtual IP" &＃96;dirname $Mha_Conf&＃96;/master_ip_failover #修改Vip地址#写入管理主机的配置文件cat >> $Mha_Conf << EOF
[server default]
manager_workdir&＃61;&＃96;dirname $Mha_Conf&＃96;
manager_log&＃61;&＃96;dirname $Mha_Conf&＃96;/manager.log
master_ip_failover_script&＃61;&＃96;dirname $Mha_Conf&＃96;/master_ip_failoverssh_port&＃61;22
ssh_user&＃61;root
repl_user&＃61;$Master_User
repl_password&＃61;$Master_Passwd
user&＃61;$Moni_User
password&＃61;$Moni_Passwd[server$Master_ID]
hostname&＃61;$Master_Host
candidate_master&＃61;1[server$Bk_Mst1_ID]
candidate_master&＃61;1
hostname&＃61;$Bk_Mst_Host_1[server$Bk_Mst2_ID]
candidate_master&＃61;1
hostname&＃61;$Bk_Mst_Host_2[server$Data_Bk1_ID]
hostname&＃61;$Data_Bk_1
no_master&＃61;1
EOF
}#测试MHA集群
TEST(){masterha_check_ssh --conf&＃61;$Mha_Conf && masterha_check_repl --conf&＃61;$Mha_Conf[ $? -eq 0 ] && OK MHA
# masterha_manager --conf&＃61;/etc/mha_manager/app1.cnf --remove_dead_master_conf --ignore_last_failover #启动管理服务
# masterha_check_status --conf&＃61;/etc/mha_manager/app1.cnf #查看状态
}#帮助信息
HELP(){cat << EOF
MHA version 1.1.1
Usage: MHA [optional]
&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;&＃61;
optional arguments:-h 提供帮助信息-I 初始化环境-M 部署主服务器-B 部署备用主服务器-D 部署数据备份服务器-m 部署管理集群主机-T 测试集群
EXAMPLE:MHA.sh -I
EOF
}#############################主程序#############################
[ $# -eq 0 ] && HELP
while getopts :hIMBDmT ARGS
docase $ARGS inh)HELP;;I)INIT;;M)MASTER;;B)BACKUP_MASTER;;D)DATA_BACKUP;;m)MANAGER;;T)TEST;; \?)cecho 31 "Invalid option:bash &＃96;basename $0&＃96; [-h]"esac
done