mysql复制的配置

# 78服务器

server-id=78

# 从哪个数开始

auto_increment_offset=1 

# 每次增加多少

auto_increment_increment=2

log-bin=mysql-bin

master-host=10.65.0.79

master-user=root

master-password=123456

master-port=3306

log-slave-updates=1

slave-skip-errors=all

replicate-do-db=rep

replicate-ignore-db=mysql

master-connect-retry=60

# 79服务器

server-id=79

auto_increment_offset=2

auto_increment_increment=2

log-bin=mysql-bin

master-host=10.65.0.78

master-user=root

master-password=123456

master-port=3306

log-slave-updates=1

slave-skip-errors=all

replicate-do-db=rep

replicate-ignore-db=mysql

master-connect-retry=60

转载于:https://www.cnblogs.com/nzbbody/p/4320570.html