- 查看是否开启了binlog
show variables like 'log_bin';
- 需要在my.cfg(/etc/my.cnf)里添加:
[mysqld]
# log_bin
log-bin = mysql-bin #开启binlog
binlog-format = ROW #选择row模式
server_id = 1 #配置mysql replication需要定义,不能喝canal的slaveId重复
- 查看binlog日志
show binlog events;
阴鸦
文章:102
关注:0 粉丝:5
show variables like 'log_bin';
[mysqld]
# log_bin
log-bin = mysql-bin #开启binlog
binlog-format = ROW #选择row模式
server_id = 1 #配置mysql replication需要定义,不能喝canal的slaveId重复
show binlog events;