mysql canal配置及canal是否开启验证

1.在/etc/my.cmf文件下添加以下三句话:

log-bin = mysql-bin
binlog-format=Row
server-id=1

2.验证是否开启

mysql> show variables like 'binlog_format';

binlog_format ROW 开启成功

mysql> show variables like 'log_bin';

log_bin ON 开启成功

mysql> show variables like '%server_id%';

server_id有值说明有配置