MySql主从双向复制配置

vim /etc/my.cnf

#主(备)
server-id = 1 #（backup这台设置为2）
log-bin=mysql-bin
binlog-ignore-db = mysql,information_schema #忽略写入binglog日志的库
log-slave-updates = 1 #从库的写操作记录到bin-log
expire_logs_days = 10 #日志过期天数
auto-increment-increment = 2 #字段变化增量值
auto-increment-offset = 1 # 初始字段ID为1， （备用库为2）
slave-skip-errors = all 

service mysqld restart

mysql -u root -p

GRANT REPLICATION SLAVE ON *.* TO ‘root‘@‘从数据库IP‘ IDENTIFIED BY ‘从数据库密码‘;
flush privileges;

mysql -u root -p

GRANT REPLICATION SLAVE ON *.* TO ‘root‘@‘主数据库IP‘ IDENTIFIED BY ‘主数据库密码‘;
flush privileges;

show master status;

change master to master_host=‘从数据库IP‘, master_user=‘root‘, master_password=‘从数据库密码‘, master_log_file=‘mysql-bin.000001‘, master_log_pos=197271;

change master to master_host=‘主数据库IP‘, master_user=‘root‘, master_password=‘主数据库密码‘, master_log_file=‘mysql-bin.000001‘, master_log_pos=154;

start slave;