DTS MySQL日志Reader日志内容校验失败

DTS-1051005 MySQL Server xx.xx.xx.xx:xx select binlog list is empty, Please use sql: SHOW BINARY LOGS; vaild binlog list.

DTS报错信息

DTS-1051005 MySQL Server xx.xx.xx.xx:xx select binlog list is empty, Please use sql: SHOW BINARY LOGS; vaild binlog list.

其中, DTS 报错code为: DTS-1051005

DTS的报错语句格式为: DTS-1051005 MySQL Server xx.xx.xx.xx:xx select binlog list is empty, Please use sql: SHOW BINARY LOGS; vaild binlog list. 其中:xx.xx.xx.xx:xx为对应的MySQL连接信息

失败原因

1. MySQL 源库Binlog列表为空,可能为开启Binlog

解决方案

1. 检查源库MySQL是否开启了Binlog, 可以通过SQL: SHOW BINARY LOGS; 查看对应的Binlog列表