问题
ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address /127.0.0.1:3306 has an error, retrying. caused by
com.alibaba.otter.canal.parse.exception.CanalParseException: command : 'show master status' has an error! pls check. you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation
2023-10-30 18:18:24.201 [destination = example , address = /127.0.0.1:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:example[com.alibaba.otter.canal.parse.exception.CanalParseException: command : 'show master status' has an error! pls check. you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation
]
解决
Canal抛出这个错误是因为127.0.0.1机器中的MySQL没有做主从配置。
因此,MySQL并没有开启Binlog配置,从而导致Canal无法同步到MySQL的Binlog二进制文件。
这简单,将MySQL主机开启Binlog配置然后重启即可解决。