Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@localhost conf]# cat canal.properties
- #################################################
- ######### common argument #############
- #################################################
- #canal.manager.jdbc.url=jdbc:mysql://127.0.0.1:3306/canal_manager?useUnicode=true&characterEncoding=UTF-8
- #canal.manager.jdbc.username=root
- #canal.manager.jdbc.password=121212
- canal.id = 1
- canal.ip =
- canal.port = 11111
- canal.metrics.pull.port = 11112
- #canal.zkServers = 192.168.10.245:2181
- # flush data to zk
- canal.zookeeper.flush.period = 1000
- canal.withoutNetty = false
- # tcp, kafka, RocketMQ
- canal.serverMode = tcp
- # flush meta cursor/parse position to file
- canal.file.data.dir = ${canal.conf.dir}
- canal.file.flush.period = 1000
- ## memory store RingBuffer size, should be Math.pow(2,n)
- canal.instance.memory.buffer.size = 16384
- ## memory store RingBuffer used memory unit size , default 1kb
- canal.instance.memory.buffer.memunit = 1024
- ## meory store gets mode used MEMSIZE or ITEMSIZE
- canal.instance.memory.batch.mode = MEMSIZE
- canal.instance.memory.rawEntry = true
- ## 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
- canal.instance.filter.transaction.entry = 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
- # parallel parser config
- canal.instance.parser.parallel = true
- ## concurrent thread number, default 60% available processors, suggest not to exceed Runtime.getRuntime().availableProcessors()
- #canal.instance.parser.parallelThreadSize = 16
- ## disruptor ringbuffer size, must be power of 2
- canal.instance.parser.parallelBufferSize = 256
- # table meta tsdb info
- canal.instance.tsdb.enable = true
- canal.instance.tsdb.dir = ${canal.file.data.dir:../conf}/${canal.instance.destination:}
- canal.instance.tsdb.url = jdbc:h2:${canal.instance.tsdb.dir}/h2;CACHE_SIZE=1000;MODE=MYSQL;
- canal.instance.tsdb.dbUsername = canal
- canal.instance.tsdb.dbPassword = canal
- # dump snapshot interval, default 24 hour
- canal.instance.tsdb.snapshot.interval = 24
- # purge snapshot expire , default 360 hour(15 days)
- canal.instance.tsdb.snapshot.expire = 360
- # aliyun ak/sk , support rds/mq
- canal.aliyun.accessKey =
- canal.aliyun.secretKey =
- #################################################
- ######### destinations #############
- #################################################
- canal.destinations = tcpip
- # 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/memory-instance.xml
- canal.instance.global.spring.xml = classpath:spring/file-instance.xml
- #canal.instance.global.spring.xml = classpath:spring/default-instance.xml
- ##################################################
- ######### MQ #############
- ##################################################
- canal.mq.servers = 192.168.10.245:9092
- canal.mq.retries = 0
- canal.mq.batchSize = 16384
- canal.mq.maxRequestSize = 1048576
- canal.mq.lingerMs = 1
- canal.mq.bufferMemory = 33554432
- canal.mq.canalBatchSize = 50
- canal.mq.canalGetTimeout = 100
- canal.mq.flatMessage = true
- canal.mq.compressionType = none
- canal.mq.acks = all
- # use transaction for kafka flatMessage batch produce
- canal.mq.transaction = false
- #canal.mq.properties. =
- [root@localhost conf]# cat tcpip/instance.properties
- #################################################
- ## mysql serverId , v1.0.26+ will autoGen
- # canal.instance.mysql.slaveId=0
- # enable gtid use true/false
- canal.instance.gtidon=false
- # position info
- canal.instance.master.address=192.168.10.245:3306
- canal.instance.master.journal.name=
- canal.instance.master.position=
- canal.instance.master.timestamp=
- canal.instance.master.gtid=
- # rds oss binlog
- canal.instance.rds.accesskey=
- canal.instance.rds.secretkey=
- canal.instance.rds.instanceId=
- # table meta tsdb info
- canal.instance.tsdb.enable=true
- #canal.instance.tsdb.url=jdbc:mysql://127.0.0.1:3306/canal_tsdb
- #canal.instance.tsdb.dbUsername=canal
- #canal.instance.tsdb.dbPassword=canal
- #canal.instance.standby.address =
- #canal.instance.standby.journal.name =
- #canal.instance.standby.position =
- #canal.instance.standby.timestamp =
- #canal.instance.standby.gtid=
- # username/password
- canal.instance.dbUsername=canal
- canal.instance.dbPassword=canal
- canal.instance.connectionCharset = UTF-8
- canal.instance.defaultDatabaseName =
- # enable druid Decrypt database password
- canal.instance.enableDruid=false
- #canal.instance.pwdPublicKey=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALK4BUxdDltRRE5/zXpVEVPUgunvscYFtEip3pmLlhrWpacX7y7GCMo2/JM6LeHmiiNdH1FWgGCpUfircSwlWKUCAwEAAQ==
- # table regex
- canal.instance.filter.regex=tianjin\\..*
- # table black regex
- canal.instance.filter.black.regex=
- # mq config
- canal.mq.topic=tianjin
- # dynamic topic route by schema or table regex
- #canal.mq.dynamicTopic=mytest1.user,mytest2\\..*,.*\\..*
- canal.mq.partition=0
- # hash partition config
- #canal.mq.partitionsNum=4
- #canal.mq.partitionHash=test.table:id^name,.*\\..*
- #################################################
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement