dm问题

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【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)

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

麻烦检查一下 dm worker 配置上游的 xie 这个用户是否有足够的权限。具体权限可以参考这里: