alibaba / canal

阿里巴巴 MySQL binlog 增量订阅&消费组件
Apache License 2.0
28.41k stars 7.59k forks source link

mysql 是否会有影响投递顺序性的参数? #2058

Open ZSH9053 opened 5 years ago

ZSH9053 commented 5 years ago

我用的1.1.3投递kafka,目前遇到一个奇怪的问题,我设置了hash分区投递,但是同一个主键的update数据却进入了不同的partition,11.3这么设置不是可以保证有序性的嘛? 我的instance文件如下 #################################################

mysql serverId , v1.0.26+ will autoGen

canal.instance.mysql.slaveId=1

enable gtid use true/false

canal.instance.gtidon=false

position info

canal.instance.master.address=XXXXXX:3307

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

enable druid Decrypt database password

canal.instance.enableDruid=false

canal.instance.pwdPublicKey=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALK4BUxdDltRRE5/zXpVEVPUgunvscYFtEip3pmLlhrWpacX7y7GCMo2/JM6LeHmiiNdH1FWgGCpUfircSwlWKUCAwEAAQ==

table regex

table black regex

canal.instance.filter.regex=.\..

canal.instance.filter.black.regex=db_oms4_im\.inv_customer_inventory_log.*

mq config

canal.mq.topic=TP_test01

dynamic topic route by schema or table regex

canal.mq.dynamicTopic=TP_oms4_im_prod:db_oms4_im

canal.mq.partition=8

hash partition config

canal.mq.partitionsNum=8 canal.mq.partitionHash=.\..:$pk$ #################################################

agapple commented 5 years ago

最好能有复现的步骤和测试数据