mysql 两台主主复制配置

A.服务器

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

server-id=2
#master-host=10.1.50.41
#master-user=root
#master-password=abc@123456
#master-port=3306
#master-connect-retry=1
replicate-do-db=test
log-bin=log-slave-updates
binlog-ignore-db=mysql
slave-skip-errors=all
auto_increment_offset = 1
auto_increment_increment = 2

B.服务器

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
server-id=3
#master-host=10.1.50.40
#master-user=root
#master-password=abc@123456
#master-port=3306
#master-connect-retry=1
replicate-do-db=Test
log-bin=log-slave-updates
binlog-ignore-db=mysql
slave-skip-errors=all
auto_increment_offset = 2
auto_increment_increment = 2

这是2台服务器配置，一个是1，3，5，7增加 一个是2，4，6，8增加