实现目标:
master1数据变换,自动同步到master2上,master2上数据变换,自动同步到master1上
提示:先了解主从配置
简单记录:
1. master1: 192.168.2.109 端口3306
2. master2: 192.168.2.109 端口3326
3. 与主从复制类似,区别在于 ,配置my.ini或my.cnf,多添加如下配置
# Master-Master结构必须的 ,双方互设置为slave
log-slave-updates
slave-skip-errors = all
sync_binlog = 1
read_only = 0
4. 互连接主服务器
master1上运行:
stop slave;
CHANGE MASTER TO
MASTER_HOST='192.168.2.109',
MASTER_PORT=3326,
MASTER_USER='reply',
MASTER_PASSWORD='reply123',
MASTER_LOG_FILE='mysql-bin.000004',
MASTER_LOG_POS=107;
start slave;
show slave status
master2上运行:
stop slave;
CHANGE MASTER TO
MASTER_HOST='192.168.2.109',
MASTER_PORT=3306,
MASTER_USER='reply',
MASTER_PASSWORD='reply123',
MASTER_LOG_FILE='mysql-bin.000003',
MASTER_LOG_POS=107;
start slave;
show slave status