- Table Routing
- Block and Allow Lists
- Binlog Event Filter
- Migration Delay Monitoring
- Usage Scenarios
- Manage the DM Cluster
- Manage Migration Tasks
- Migrate from MySQL-compatible Database
- DM Portal
DM-worker is a tool used to migrate data from MySQL/MariaDB to TiDB.
It has the following features:
- Acts as a secondary database of any MySQL or MariaDB instance
- Reads the binlog events from MySQL/MariaDB and persists them to the local storage
- A single DM-worker supports migrating the data of one MySQL/MariaDB instance to multiple TiDB instances
- Multiple DM-workers support migrating the data of multiple MySQL/MariaDB instances to one TiDB instance
A DM-worker task contains multiple logic units, including relay log, Dumper, Loader, and binlog replication.
The relay log persistently stores the binlog data from the upstream MySQL/MariaDB and provides the feature of accessing binlog events for the binlog replication.
Its rationale and features are similar to the secondary relay log of MySQL. For details, see The Secondary Relay Log.
Dumper dumps the full data from the upstream MySQL/MariaDB to the local disk.
Loader reads the files of Dumper and then loads these files to the downstream TiDB.
Binlog replication/Syncer reads the binlog events of the relay log, transforms these events to SQL statements, and then applies these statements to the downstream TiDB.
This section describes the upstream and downstream database users' privileges required by DM-worker, and the user privileges required by the respective processing unit.
The upstream database (MySQL/MariaDB) user must have the following privileges:
If you need to migrate the data from
db1 to TiDB, execute the following
GRANT RELOAD,REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'your_user'@'your_wildcard_of_host' GRANT SELECT ON db1.* TO 'your_user'@'your_wildcard_of_host';
If you also need to migrate the data from other databases into TiDB, make sure the same privileges are granted to the user of the respective databases.
The downstream database (TiDB) user must have the following privileges:
Execute the following
GRANT statement for the databases or tables that you need to migrate:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX ON db.table TO 'your_user'@'your_wildcard_of_host';
|Processing unit||Minimal upstream (MySQL/MariaDB) privilege||Minimal downstream (TiDB) privilege||Minimal system privilege|
|Relay log||NULL||Read/Write local files|
|Dumper||NULL||Write local files|
|Loader||NULL||Read/Write local files|
|Binlog replication||Read/Write local files|
These privileges are not immutable and they change as the request changes.