【 TiDB 使用环境】测试环境【 TiDB 版本】 6.1 【遇到的问题】TICDC 数据同步问题 【复现路径】做过哪些操作出现的问题`
【问题现象及影响】
你好 尝试验证数据同步功能 源端TIDB 6.1 目标端 mysql 5.5
在TIDB 上创建了changefeed后，源端和目标端都建好了同步测试表以及主键。在源端将数据插入后，在目标端并没同步过去，查看了changefeed的状态是normal.请问还有什么没有配置的吗？
下面输出是query changefeed详情
Starting component cdc: /root/.tiup/components/cdc/v6.1.1/cdc cli changefeed query --pd=http://192.168.56.103:2379 --changefeed-id=simple-replication-task
{
“info”: {
“upstream-id”: 0,
“sink-uri”: “mysql://root:xxxx@192.168.56.103:3306/”,
“opts”: {},
“create-time”: “2022-10-20T09:05:36.102187123+08:00”,
“start-ts”: 436791655858438149,
“target-ts”: 0,
“admin-job-type”: 0,
“sort-engine”: “unified”,
“sort-dir”: “”,
“config”: {
“case-sensitive”: true,
“enable-old-value”: true,
“force-replicate”: false,
“check-gc-safe-point”: true,
“filter”: {
“rules”: [
“.”
],
“ignore-txn-start-ts”: null
},
“mounter”: {
“worker-num”: 16
},
“sink”: {
“dispatchers”: null,
“protocol”: “”,
“column-selectors”: null,
“schema-registry”: “”,
“transaction-atomicity”: “table”
},
“cyclic-replication”: {
“enable”: false,
“replica-id”: 0,
“filter-replica-ids”: null,
“id-buckets”: 0,
“sync-ddl”: false
},
“consistent”: {
“level”: “none”,
“max-log-size”: 64,
“flush-interval”: 2000,
“storage”: “”
}
},
“state”: “normal”,
“error”: null,
“sync-point-enabled”: false,
“sync-point-interval”: 600000000000,
“creator-version”: “v6.1.1”
},
“status”: {
“resolved-ts”: 436793412800479234,
“checkpoint-ts”: 436793412800479234,
“admin-job-type”: 0
},
“count”: 0,
“task-status”: [
{
“capture_id”: “0b89cd6e-0f76-4eec-88d8-0600df50c7b4”,
“table_ids”: [],
“table_operations”: null
},
{
“capture_id”: “25e6ebd4-8109-4e4c-bfd8-0cff8227ed09”,
“table_ids”: [],
“table_operations”: null
}
]
}
