MySQL双主（Master-Master）同步

MySQL双主同步步骤（Linux服务器）：

1.分别找到两个MySQL下的my.cnf配置文件，分别加入：

[mysqld]
server-id = 1
log-bin=/data0/mysql/3306/binlog/binlog
binlog-do-db = Master_1
binlog-ignore-db=mysql
binlog-ignore-db=obt
binlog-ignore-db=performance_schema
binlog-ignore-db=test
binlog-ignore-db=information_schema

log-slave-updates
sync_binlog=1
auto_increment_offset=1
auto_increment_increment=2
replicate-do-db = Master_1
replicate-ignore-db = mysql
replicate-ignore-db = obt
replicate-ignore-db = performance_schema
replicate-ignore-db = test
replicate-ignore-db = information_schema

[mysqld]
server-id = 2
log-bin=/data/mysql/binlog/binlog
binlog-do-db = Master_2
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema

log-slave-updates
sync_binlog=1
auto_increment_offset=2
auto_increment_increment=2
replicate-do-db = Master_2
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema

server-id，auto_increment_offset为区别处

2.分别重启两台MySQL

service mysqld restart

注意：若此