canal
静湖孤子
这个作者很懒,什么都没留下…
展开
-
Canal初探 (mysql8)
1. binlog开启, 并设置为ROW格式修改my.cnf, 重点关注两个参数log_bin = ONbinlog_format = ROWselect version(); # mysql version (8.0)show master logs; # master binlogshow master status; # master 状态show global variables like原创 2021-06-18 20:21:50 · 590 阅读 · 0 评论 -
MySQL binlog格式及replication格式
1. 查看配置信息select version(); # mysql version (8.0)show master logs; # master binlogshow master status; # master 状态show global variables like '%log_bin%'; # binlog 是否开启show global variables like 'log_bin原创 2021-06-17 15:44:22 · 169 阅读 · 0 评论 -
Canal使用问题
Canal使用问题1. IOException: errno = 1236, sqlstate = HY000 errmsg = Could not find first log file name in binary log index file异常日志2021-06-15 11:40:40.548 [destination = example , address = /10.89.2.242:3306 , EventParser] ERROR c.a.o.canal.parse.inbound原创 2021-06-17 11:40:09 · 541 阅读 · 0 评论