一.安装部署
1.数据的迁移:先导库,(将master1中的所有库导入到master2中)
master1上备份: mysqldump -uroot -p123 -A >/opt/mysql.sql
master2上导入: mysql -uroot -p123 </root/mysql.sql
2.更改两台master的主配置文件:
log-bin = mysql-bin
binlog_format = mixed
server-id = 1 :此处两台服务器id不能相同
relay-log = relay-bin
relay-log-index = slave-relay-bin.index
auto-increment-increment = 2
auto-increment-offset = 1 :此处有不同,具体可以看最下面的介绍
3.重启两台mysql服务
4.两台master都创建授权用户:
grant replication slave on *.* to rep@'192.168.164.%' identified by '123';
mysql> flush privileges;
5.查看master1的当前binlog状态信息
show master status;
6.在master2上将master1设为自已的主服务器并开启slave功能
mysql> ch