pingcap / pingcap/tidb

TiDB-6.5.7 Merge synchronization scenarios

Open
#51,865 1 comment 0 reactions 0 assignees View on GitHub
type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

tidb版本:6.5.7
mysql版本:5.7
问题:
目前是通过dm同步mysql数据到tidb集群。现在有个需求。需要把2个不同实例的mysql库的2个表的部分字段合并同步到tidb的1个表里。比如mysql的a.t1有(a,b,c,d)4个字段,mysql的b.t1有(a,d,e)3个字段。现在要合并同步到tidb.t1(a,b,d,e)这4个字段。其中a是主键。请问dm支持这样的场景吗?如果支持,请给个配置例子。谢谢!

Contributor guide

Open the contributing guide

Research direction

Start with the issue's described DM synchronization scenario and check the DM documentation and configuration guidance for merging tables from separate MySQL instances into one TiDB table. Confirm whether this topology is supported, identify any documented configuration example, and record the limitation or example as the completed outcome.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, sql
Domain
data-engineering, databases
Issue type
Documentation
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
18/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.