MHA部署mysql自动切换主从

关闭防火墙

systemctl stop firewalld
setenforce 0

配置ssh连接

四个节点都需要做无密码连接

ssh-keygen 
ssh-copy-id  root@192.168.181.177
ssh-copy-id  root@192.168.181.178
ssh-copy-id  root@192.168.181.179

测试是否连接成功

做mysql一主多从

1.部署master

yum -y install mariadb mariadb-server #安装mysql


vim /etc/my.cnf
[mysqld]
server-id = 1          		#集群中的各节点的id不能重复，必须唯一
log-bin = mysql-log    		#开启二进制日志
relay-log = mysql-relay   	#开启中继日志

systemctl start mariadb #启动mysql

2.部署两台slave

yum -y install mariadb mariadb-server #安装mysql
vim /etc/my.cnf
[mysqld]
server-id = 2              	 #集群中的各节点的id不能重复，必须唯一
relay-log = mysql-relay   	 #开启中继日志
log-bin = mysql-log          #开启二进制日志
read_only = ON               #启用只读属性
relay_log_purge = 0