报错"/>
mysql+canal启动报错
1.当删除binlog.00000x 日志可能mysql再启动不了,需要把binlog.index清空
2.Mysql重新安装或者安装高版本的时候,canal启动报错
2020-07-06 07:10:39.236 [destination = example , address = bigdata101/192.168.1.96:3306 ,EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address bigdata101/192.168.1.96:3306 has an error, retrying. caused by
java.io.IOException: Received error packet: errno = 1236,
sqlstate = HY000 errmsg = Could not find first log file name in binary log index file
解决办法:/opt/module/canal/conf/example/ meta.dat 删除
Mysql8 默认开启binlog和format=row
使用Canal需要在mysql my.conf中增添 service-id
3.Canal HA 第二台机器报错
1.提高允许的max_connection_errors数量(治标不治本):
① 进入Mysql数据库查看max_connection_errors:
show variables like '%max_connection_errors%';
② 修改max_connection_errors的数量为1000:
set global max_connect_errors = 1000;
2.第二步可以在数据库中进行,命令如下:
flush hosts;
附加:Canal HA配置
修改canal.properties文件
canal.zkServers=192.168.207.141:2181,192.168.207.142:2181,192.168.207.143:2181
修改instance.properties文件
canal.instance.mysql.slaveId = 1234 #两台不一样
position info
canal.instance.master.address = 192.168.207.141:3306
canal.instance.dbUsername = root
canal.instance.dbPassword = 123456
canal.instance.defaultDatabaseName = canal
canal.instance.connectionCharset = UTF-8
更多推荐
mysql+canal启动报错
发布评论