DM配置同步报错1st: mysql instance config must specify

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

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

配置文件的内容是否可以提供下,看起来是没配置mysql-instance

---
name: test # global unique
task-mode: all  # full/incremental/all

target-database:
  host: "10.x.x.x"
  port: 3308
  user: "dba"
  password: "xxxxxx"

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"

    #black-white-list:  "global"
    # 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

  -
    #source-id: "instance118-5306"
    #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: ["sbtest"]        # 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: "sbtest"
      tbl-name: "sbtest1"
    #- db-name: "do"
    #  tbl-name: "do"

task 任务配置中的 mysql-instances 的 source-id 是否与 inventory.ini 中 dm-worker 的 source-id 是对应的?
可以的话,可以上传一下 inventory.ini 配置文件

inventory.ini 和dm-worker.toml 中的 source_id server_id 都是一样的。

# Worker Configuration.

server-id = 101

source-id = "mysql-replica-01"

flavor = "mysql"

enable-gtid = false



#charset of DSN of source mysql/mariadb instance
charset = ""
meta-dir = ""

[from]
host = "10.204.x.x"
user = "dba"
password = "xxxxxxxxx"
port = 3306

#relay log purge strategy
[purge]
interval = 3600
expires = 0
remain-space = 15

inventory.ini

## DM modules
[dm_master_servers]
dm_master ansible_host=10.204.x.x

[dm_worker_servers]
dm-worker1 ansible_host=10.204.x.x source_id="mysql-replica-01" server_id=101 mysql_host=10.204.xx.xx mysql_user=dba mysql_password=tMv2hmnztyKGbaV3oT9HJkAtHXzLIDJxY6k= mysql_port=3306

#dm-worker2 ansible_host=172.16.55.73 source_id="mysql-replica-02" server_id=102 mysql_host=172.16.10.73 mysql_user=root mysql_password=123456 mysql_port=3306

[dm_portal_servers]
dm_portal ansible_host=10.204.x.x

## Monitoring modules
[prometheus_servers]
prometheus ansible_host=10.204.x.x

[grafana_servers]
grafana ansible_host=10.204.x.x

[alertmanager_servers]
alertmanager ansible_host=10.204.x.x

## Global variables
[all:vars]
cluster_name = test-cluster

ansible_user = tidb

dm_version = v1.0.2

deploy_dir = /app/dm

grafana_admin_user = "admin"
grafana_admin_password = "admin"
-
#source-id: "instance118-5306"
#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

“-” 这个也需要注释掉,可以再试下,因为下面的内容已经被注释掉~

是的,上周后来发现了,感谢。

:+1:

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。