vi source1.yaml
source-id: “mysql-207”
enable-gtid: false
from:
host: “10.0.0.207”
port: 3306
user: “root”
password: “xxx”
vi source2.yaml
source-id: “mysql-208”
enable-gtid: false
from:
host: “10.0.0.208”
port: 3306
user: “root”
password: “xxx”
vi task.yaml
# 2个分库的mysql表(库名表名一致) 合并到tidb
name: "mysql_merge_to_center"
task-mode: all
shard-mode: "pessimistic"
meta-schema: "dm_meta"
ignore-checking-items: ["auto_increment_ID"]
target-database:
host: 10.x.x.x
port: 4000
user: "root"
password: "xxxxx"
mysql-instances:
-
source-id: "mysql-207"
block-allow-list: "listA"
-
source-id: "mysql-208"
block-allow-list: "listA"
block-allow-list:
listA:
do-dbs: ["db_to_sync"]
do-tables:
- db-name: "db_to_sync"
tbl-name: "table1"