mysql双主双从 搭建配置

192.168.8.51 （M1）

192.168.8.50 （S1）

192.168.8.131 （M1）

192.168.8.132 （S1）

双主双从

M1  192.168.8.51
server-id=1
log-bin=mysql-bin
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-do-db=testdb
binlog_format=STATEMENT
log-slave-updates
auto-increment-increment=2
auto-increment-offset=1

M2 192.168.8.131  

server-id=3
log-bin=mysql-bin
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-do-db=testdb
binlog_format=STATEMENT
log-slave-updates
auto-increment-increment=2
auto-increment-offset=2

192.168.8.50  S1（从）
server-id=2
relay-log=mysql-relay

192.168.8.132  S2（从）
server-id=4
relay-log=mysql-relay

## ================ 之前192.168.8.50和192.168.8.51搭建过主从========
stop slave
reset master

192.168.8.50 (S1复制M1)
change master to master_host='192.168.8.51',master_port=3306,master_user='qiao',master_password='12345678',master_log_file='mysql-bin.000001',master_log_pos=154;

192.168.8.132 （S2复制M2)
change master to master_host='192.168.8.131',master_port=3306,master_user='qiao',master_password='12345678',master_log_file='mysql-bin.000001',master_log_pos=154;

192.168.8.51 和 192.168.8.131 搭建主从（相互复制）

M1 192.168.8.51 （M1复制M2)

change master to master_host='192.168.8.131',master_port=3306,master_user='qiao',master_password='12345678',master_log_file='mysql-bin.000001',master_log_pos=154;

M2  192.168.8.131(M2复制M1)
change master to master_host='192.168.8.51',master_port=3306,master_user='qiao',master_password='12345678',master_log_file='mysql-bin.000001',master_log_pos=154;

本作品采用《CC 协议》，转载必须注明作者和本文链接