Advertisement
Guest User

Untitled

a guest
May 9th, 2019
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.39 KB | None | 0 0
  1. [root@localhost conf]# cat canal.properties
  2. #################################################
  3. ######### common argument #############
  4. #################################################
  5. #canal.manager.jdbc.url=jdbc:mysql://127.0.0.1:3306/canal_manager?useUnicode=true&characterEncoding=UTF-8
  6. #canal.manager.jdbc.username=root
  7. #canal.manager.jdbc.password=121212
  8. canal.id = 1
  9. canal.ip =
  10. canal.port = 11111
  11. canal.metrics.pull.port = 11112
  12. #canal.zkServers = 192.168.10.245:2181
  13. # flush data to zk
  14. canal.zookeeper.flush.period = 1000
  15. canal.withoutNetty = false
  16. # tcp, kafka, RocketMQ
  17. canal.serverMode = tcp
  18. # flush meta cursor/parse position to file
  19. canal.file.data.dir = ${canal.conf.dir}
  20. canal.file.flush.period = 1000
  21. ## memory store RingBuffer size, should be Math.pow(2,n)
  22. canal.instance.memory.buffer.size = 16384
  23. ## memory store RingBuffer used memory unit size , default 1kb
  24. canal.instance.memory.buffer.memunit = 1024
  25. ## meory store gets mode used MEMSIZE or ITEMSIZE
  26. canal.instance.memory.batch.mode = MEMSIZE
  27. canal.instance.memory.rawEntry = true
  28.  
  29. ## detecing config
  30. canal.instance.detecting.enable = false
  31. #canal.instance.detecting.sql = insert into retl.xdual values(1,now()) on duplicate key update x=now()
  32. canal.instance.detecting.sql = select 1
  33. canal.instance.detecting.interval.time = 3
  34. canal.instance.detecting.retry.threshold = 3
  35. canal.instance.detecting.heartbeatHaEnable = false
  36.  
  37. # support maximum transaction size, more than the size of the transaction will be cut into multiple transactions delivery
  38. canal.instance.transaction.size = 1024
  39. # mysql fallback connected to new master should fallback times
  40. canal.instance.fallbackIntervalInSeconds = 60
  41.  
  42. # network config
  43. canal.instance.network.receiveBufferSize = 16384
  44. canal.instance.network.sendBufferSize = 16384
  45. canal.instance.network.soTimeout = 30
  46.  
  47. # binlog filter config
  48. canal.instance.filter.druid.ddl = true
  49. canal.instance.filter.query.dcl = false
  50. canal.instance.filter.query.dml = false
  51. canal.instance.filter.query.ddl = false
  52. canal.instance.filter.table.error = false
  53. canal.instance.filter.rows = false
  54. canal.instance.filter.transaction.entry = false
  55.  
  56. # binlog format/image check
  57. canal.instance.binlog.format = ROW,STATEMENT,MIXED
  58. canal.instance.binlog.image = FULL,MINIMAL,NOBLOB
  59.  
  60. # binlog ddl isolation
  61. canal.instance.get.ddl.isolation = false
  62.  
  63. # parallel parser config
  64. canal.instance.parser.parallel = true
  65. ## concurrent thread number, default 60% available processors, suggest not to exceed Runtime.getRuntime().availableProcessors()
  66. #canal.instance.parser.parallelThreadSize = 16
  67. ## disruptor ringbuffer size, must be power of 2
  68. canal.instance.parser.parallelBufferSize = 256
  69.  
  70. # table meta tsdb info
  71. canal.instance.tsdb.enable = true
  72. canal.instance.tsdb.dir = ${canal.file.data.dir:../conf}/${canal.instance.destination:}
  73. canal.instance.tsdb.url = jdbc:h2:${canal.instance.tsdb.dir}/h2;CACHE_SIZE=1000;MODE=MYSQL;
  74. canal.instance.tsdb.dbUsername = canal
  75. canal.instance.tsdb.dbPassword = canal
  76. # dump snapshot interval, default 24 hour
  77. canal.instance.tsdb.snapshot.interval = 24
  78. # purge snapshot expire , default 360 hour(15 days)
  79. canal.instance.tsdb.snapshot.expire = 360
  80.  
  81. # aliyun ak/sk , support rds/mq
  82. canal.aliyun.accessKey =
  83. canal.aliyun.secretKey =
  84.  
  85. #################################################
  86. ######### destinations #############
  87. #################################################
  88. canal.destinations = tcpip
  89. # conf root dir
  90. canal.conf.dir = ../conf
  91. # auto scan instance dir add/remove and start/stop instance
  92. canal.auto.scan = true
  93. canal.auto.scan.interval = 5
  94.  
  95. canal.instance.tsdb.spring.xml = classpath:spring/tsdb/h2-tsdb.xml
  96. #canal.instance.tsdb.spring.xml = classpath:spring/tsdb/mysql-tsdb.xml
  97.  
  98. canal.instance.global.mode = spring
  99. canal.instance.global.lazy = false
  100. #canal.instance.global.manager.address = 127.0.0.1:1099
  101. #canal.instance.global.spring.xml = classpath:spring/memory-instance.xml
  102. canal.instance.global.spring.xml = classpath:spring/file-instance.xml
  103. #canal.instance.global.spring.xml = classpath:spring/default-instance.xml
  104.  
  105. ##################################################
  106. ######### MQ #############
  107. ##################################################
  108. canal.mq.servers = 192.168.10.245:9092
  109. canal.mq.retries = 0
  110. canal.mq.batchSize = 16384
  111. canal.mq.maxRequestSize = 1048576
  112. canal.mq.lingerMs = 1
  113. canal.mq.bufferMemory = 33554432
  114. canal.mq.canalBatchSize = 50
  115. canal.mq.canalGetTimeout = 100
  116. canal.mq.flatMessage = true
  117. canal.mq.compressionType = none
  118. canal.mq.acks = all
  119. # use transaction for kafka flatMessage batch produce
  120. canal.mq.transaction = false
  121. #canal.mq.properties. =
  122.  
  123.  
  124.  
  125.  
  126.  
  127.  
  128.  
  129.  
  130.  
  131.  
  132.  
  133.  
  134.  
  135. [root@localhost conf]# cat tcpip/instance.properties
  136. #################################################
  137. ## mysql serverId , v1.0.26+ will autoGen
  138. # canal.instance.mysql.slaveId=0
  139.  
  140. # enable gtid use true/false
  141. canal.instance.gtidon=false
  142.  
  143. # position info
  144. canal.instance.master.address=192.168.10.245:3306
  145. canal.instance.master.journal.name=
  146. canal.instance.master.position=
  147. canal.instance.master.timestamp=
  148. canal.instance.master.gtid=
  149.  
  150. # rds oss binlog
  151. canal.instance.rds.accesskey=
  152. canal.instance.rds.secretkey=
  153. canal.instance.rds.instanceId=
  154.  
  155. # table meta tsdb info
  156. canal.instance.tsdb.enable=true
  157. #canal.instance.tsdb.url=jdbc:mysql://127.0.0.1:3306/canal_tsdb
  158. #canal.instance.tsdb.dbUsername=canal
  159. #canal.instance.tsdb.dbPassword=canal
  160.  
  161. #canal.instance.standby.address =
  162. #canal.instance.standby.journal.name =
  163. #canal.instance.standby.position =
  164. #canal.instance.standby.timestamp =
  165. #canal.instance.standby.gtid=
  166.  
  167. # username/password
  168. canal.instance.dbUsername=canal
  169. canal.instance.dbPassword=canal
  170. canal.instance.connectionCharset = UTF-8
  171. canal.instance.defaultDatabaseName =
  172. # enable druid Decrypt database password
  173. canal.instance.enableDruid=false
  174. #canal.instance.pwdPublicKey=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALK4BUxdDltRRE5/zXpVEVPUgunvscYFtEip3pmLlhrWpacX7y7GCMo2/JM6LeHmiiNdH1FWgGCpUfircSwlWKUCAwEAAQ==
  175.  
  176. # table regex
  177. canal.instance.filter.regex=tianjin\\..*
  178. # table black regex
  179. canal.instance.filter.black.regex=
  180.  
  181. # mq config
  182. canal.mq.topic=tianjin
  183. # dynamic topic route by schema or table regex
  184. #canal.mq.dynamicTopic=mytest1.user,mytest2\\..*,.*\\..*
  185. canal.mq.partition=0
  186. # hash partition config
  187. #canal.mq.partitionsNum=4
  188. #canal.mq.partitionHash=test.table:id^name,.*\\..*
  189. #################################################
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement