为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.0
- 【dm 版本】:v1.0.5
- 【问题描述】:使用DM进行数据同步,tidb中未能生成需要同步的数据库 dm-worker.log里和mydumper相关的log: [2020/06/05 16:35:35.306 +08:00] [INFO] [mydumper.go:270] [“Tables needed to dump are not given, now we will start to generate table list that mydumper needs to dump through black-white list from given fromDB”] [task=test] [unit=dump]
[2020/06/05 16:35:35.412 +08:00] [INFO] [common.go:109] [“no tables need to sync”] [schema=cpic_data_test]
[2020/06/05 16:35:35.412 +08:00] [INFO] [mydumper.go:278] [“create mydumper”] [task=test] [unit=dump] [argument="[–host,<这里的IP被删除了>,–port,3306,–user,root,–outputdir,./dumped_data.test,–logfile,/dev/stderr,–verbose,3,–threads,4,–chunk-filesize,64,–skip-tz-utc,–tables-list,]"]
DM log里mydumper的参数中貌似没有数据库名,–tables-list貌似后面没有生成需要同步的表名
task配置:
---
name: test # global unique
task-mode: all # full/incremental/all
target-database:
host: "10.40.100.153"
port: 4000
user: "root"
password: ""
mysql-instances: # one or more source database, config more source database for sharding merge
-
source-id: "mysql-replica-01" # unique in all instances, used as id when save checkpoints, configs, etc.
black-white-list: "instance"
# number of threads to use for dump data
mydumper-thread: 4
# number of threads to use for load data
loader-thread: 16
# number of threads to use for replicate binlog
syncer-thread: 16
black-white-list:
instance:
do-dbs: ["cpic_data_test"] # white list of upstream schemas needs to be replicated, regular expression (starts with ~) is supported
do-tables: # white list of upstream tables needs to be replicated, (db-name, tbl-name) regular expression (starts with ~) is supported
- db-name: "cpic_data_test"
tbl-name: "~^cpic_.*"