otter版本4.2.18
java版本1.8
linux系统版本centos6.8
建议MySQL版本为5.6以上,达到与canal兼容,避免有异常信息,5.1.x的话可能会有一些报错异常,测试过5.1.7的会报异常,本次测试安装5.7.29,暂无发现bug
典型的是网络超时异常:
pid:1 nid:1 exception:canal:example:java.net.SocketTimeoutException: Timeout occurred, failed to read total 4 bytes in 25000 milliseconds, actual read only 0 bytes
at com.alibaba.otter.canal.parse.driver.mysql.socket.BioSocketChannel.read(BioSocketChannel.java:124)
at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch0(DirectLogFetcher.java:174)
at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:77)
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:169)
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:279)
at java.lang.Thread.run(Thread.java:748)