
一、先修改配置文件
服务器A(192.168.1.254)配置如下
log-bin = mysql-bin
server-id = 1
expire-logs-days = 100
replicate-do-db = test
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
auto-increment-increment = 2
auto-increment-offset = 1
服务器B(192.168.1.252)配置
log-bin = mysql-bin
server-id = 2
expire-logs-days = 100
replicate-do-db = test
binlog-i...