canal配置

最新推荐文章于 2024-01-05 23:05:31 发布

qingwufeiyang_530

最新推荐文章于 2024-01-05 23:05:31 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： canal 文章标签： canal

本文链接：https://blog.youkuaiyun.com/qingwufeiyang_530/article/details/81707797

canal 专栏收录该内容

1 篇文章

订阅专栏

这篇博客详细介绍了Canal的配置过程，包括conf目录下的实例配置文件和canal.properties配置。重点讲解了如何进行spring加载和管理，以及如何配置canal组件的多个instance。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

canal配置：

conf目录下：

canal.properties
实例名称（文件夹）
logback.xml
spring

实例中的配置文件：

h2.mv.db
instance.properties
meta.dat
rds_instance.properties

canal.properties配置:

## detecing config
canal.instance.detecting.enable = false
#canal.instance.detecting.sql = insert into retl.xdual values(1,now()) on duplicate key update x=now()
canal.instance.detecting.sql = select 1
canal.instance.detecting.interval.time = 3
canal.instance.detecting.retry.threshold = 3
canal.instance.detecting.heartbeatHaEnable = false

# support maximum transaction size, more than the size of the transaction will be cut into multiple transactions delivery
canal.instance.transaction.size =  1024
# mysql fallback connected to new master should fallback times
canal.instance.fallbackIntervalInSeconds = 60

# network config
canal.instance.network.receiveBufferSize = 16384
canal.instance.network.sendBufferSize = 16384
canal.instance.network.soTimeout = 30

# binlog filter config
canal.instance.filter.druid.ddl = true
canal.instance.filter.query.dcl = false
canal.instance.filter.query.dml = false
canal.instance.filter.query.ddl = false
canal.instance.filter.table.error = false
canal.instance.filter.rows = false

# binlog format/image check
canal.instance.binlog.format = ROW,STATEMENT,MIXED 
canal.instance.binlog.image = FULL,MINIMAL,NOBLOB

# binlog ddl isolation
canal.instance.get.ddl.isolation = false

#################################################
#########               destinations            ############# 
#################################################
canal.destinations=
# conf root dir
canal.conf.dir = ../conf
# auto scan instance dir add/remove and start/stop instance
canal.auto.scan = true
canal.auto.scan.interval = 5
canal.instance.tsdb.spring.xml=classpath:spring/tsdb/h2-tsdb.xml
#canal.instance.tsdb.spring.xml=classpath:spring/tsdb/mysql-tsdb.xml

canal.instance.global.mode = spring 
canal.instance.global.lazy = false
#canal.instance.global.manager.address = 127.0.0.1:1099
#canal.instance.global.spring.xml = classpath:spring/local-instance.xml
#canal.instance.global.spring.xml = classpath:spring/memory-instance.xml
canal.instance.global.spring.xml = classpath:spring/file-instance.xml
#canal.instance.global.spring.xml = classpath:spring/default-instance.xml

加载方式spring/manager

spring/XXXX-instance.xml :canal组件的配置定义，多个instance共享