为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:3.0.8
- 【问题描述】:
使用dm同步mysql到tidb上,数据同步不过来
[tidb@tidb05 dm-cnf]$ cat dm-worker1.toml
Worker Configuration.
source-id = “mysql1”
flavor = “mysql”
worker-addr = “10.105.1.167:8262”
log-file = “/home/tidb/dm/logs/worker1.log”
relay-dir = “/home/tidb/dm/data/relay1”
meta-dir = “/home/tidb/dm/data/meta1”
[from]
host = “ip”
user = “xxx”
password = “b50FjxA0”
port = 3307
[tidb@tidb05 dm-cnf]$ cat dm-master.toml
master-addr = “:8261”
log-file = “/home/tidb/dm/logs/master.log”
[[deploy]]
source-id = “mysql1”
dm-worker = “:8262”
[tidb@tidb05 dm-cnf]$
[tidb@tidb05 dm-cnf]$ cat dmtask1.yaml
name: dmtask1
task-mode: all
is-sharding: true
enable-heartbeat: true
ignore-checking-items:
- “auto_increment_ID”
target-database:
host: “127.0.0.1”
port: 4000
user: “root”
password: “”
mysql-instances:
- source-id: “mysql1”
black-white-list: “dmtest1”
loader-config-name: “loader1”
black-white-list: # filter rules, mysql instance can ref rules in it
dmtest1:
do-dbs: [“dmtest1”]
mydumpers:
global:
threads: 4
loaders:
loader1:
dir: “/home/tidb/dm/data/dump1”
master.log (5.3 KB) worker1.log (74.4 KB)
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。