How to Write Configuration for Migrating Multiple Instances in a Database Using TiDB DM

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb dm 迁移一个数据库中的多个实例 该如何写配置

| username: wisdom

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】
【Encountered Issues】
【Reproduction Path】What operations were performed that led to the issue
【Issue Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download and run the script. Please select all and copy-paste the terminal output results for upload.

2
| username: Hacker007 | Original post link

What does multiple instances refer to? Databases? Tables?

3
| username: wisdom | Original post link

There are many instances in one database, and I want to synchronize some tables in three instances.

block-allow-list:
bw-rule-1:
do-dbs: [“db1”, “db2”, “db3”]
do-tables:
- db-name: “db1”
tbl-name: “table1”
- db-name: “db2”
tbl-name: “table1”
- db-name: “db3”
tbl-name: “table1”

Writing it like this won’t synchronize.

4
| username: buchuitoudegou | Original post link

Could you describe it in more detail? This block-allow-list should be able to match: db1.table1, db2.table1, db3.table1, these three tables. What exactly is your requirement? For example, which tables do you want to synchronize but have not been successfully synchronized?

5
| username: wisdom | Original post link

The issue has been resolved. Initially, I suspected it was related to table and database rules, but later found out that the problem was not in the block-allow-list. Thank you for the explanation.

6
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.