Debezium系列之:详细总结数据库binlog文件不存在的几种解决方法The connector is trying to read binlog ... but this is no longer available on the server.
一、背景
- mysql数据库binlog文件一般有设置保存的时间,当数据库不经常更新,历史binlog文件从数据库服务器上删除后,debezium connector可能会出现下面的报错:
io.debezium.DebeziumException: The connector is trying to read binlog starting at SourceInfo [currentGtid=null, currentBinlogFilename=mysql-bin.003963, currentBinlogPosition=232524130, currentRowNumber=0, serverId=0, sourceTime=null, threadId=-1, currentQuery=null, tableIds=[], databaseName=null], but this is no longer available on the server. Reconfigure the connector to use a snapshot when needed.
- connector挂掉后,如果有新的数据进入数据库,则有可能造成数据丢失,需要针对数据库不经常更新和binlog文件会被删掉这种情况采取相对应的解决措施。
- 下面针对这种问题分享几种解决方法。