一、构建MHA
1.ssh免密登录
所有节点配置hosts
192.168.115.128 manager
192.168.115.130 mariadb1
192.168.115.131 mariadb2
192.168.115.132 mariadb3
192.168.115.128
ssh-keygen
for i in 130 131 132;do ssh-copy-id root@192.168.115.$i;done
192.168.115.130
ssh-keygen
for i in 128 131 132;do ssh-copy-id root@192.168.115.$i;done
192.168.115.131
ssh-keygen
for i in 130 128 132;do ssh-copy-id root@192.168.115.$i;done
192.168.115.132
ssh-keygen
for i in 130 131 128;do ssh-copy-id root@192.168.115.$i;done
测试
for i in 128 130 131;do ssh 192.168.115.$i hostname;done
2.主从复制
安装mariadb数据库并启动
for i in 130 131 132;do ssh 192.168.115.$i yum install -y mariadb mariadb-server mariadb;done
配置主从复制
master