1、在my.cnf中增加以下配置
log_bin=on
log_slave_updates=on
binlog_format=row
binlog_checksum=none
2、授权:
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'xxx'@'XXX' IDENTIFIED BY 'xxx';
GRANT SELECT, LOCK TABLES ON `mco_promotion`.* TO 'xxx'@'xxx';
然后重启
3、进入目录查看日志
插入一条记录,然后进入mysql数据存储路径查看是否存储
mysqlbinlog -v mysql-bin.00** -r mysql-bin.00**.sql
4、若没有同步,那么
show variables like 'log_bin'; 为on状态