- About DM
- What is DM?
- Basic Features
- Advanced Features
- Merge and Migrate Data from Sharded Tables
- Migrate from MySQL Databases that Use GH-ost/PT-osc
- Filter Certain Row Changes Using SQL Expressions
- DM Architecture
- Quick Start
- Cluster Upgrade
- Manage Data Source
- Manage a Data Migration Task
- Manually Handle Sharding DDL Lock
- Manage Schemas of Tables to be Migrated
- Handle Alerts
- Daily Check
- Usage Scenarios
- Performance Tuning
- Release Notes
For DM clusters deployed using TiUP, you are recommended to directly use
tiup dmctl to maintain the clusters.
dmctl is a command line tool used to maintain DM clusters. It supports both the interactive mode and the command mode.
Enter the interactive mode to interact with DM-master:
The interactive mode does not support Bash features. For example, you need to directly pass string flags instead of passing them in quotes.
./dmctl --master-addr 172.16.30.14:8261
Welcome to dmctl Release Version: v2.0.3 Git Commit Hash: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Git Branch: release-2.0 UTC Build Time: yyyy-mm-dd hh:mm:ss Go Version: go version go1.13 linux/amd64 » help DM control Usage: dmctl [command] Available Commands: check-task Checks the configuration file of the task. config Commands to import/export config. get-config Gets the configuration. handle-error `skip`/`replace`/`revert` the current error event or a specific binlog position (binlog-pos) event. help Gets help about any command. list-member Lists member information. offline-member Offlines member which has been closed. operate-leader `evict`/`cancel-evict` the leader. operate-schema `get`/`set`/`remove` the schema for an upstream table. operate-source `create`/`update`/`stop`/`show` upstream MySQL/MariaDB source. pause-relay Pauses DM-worker's relay unit. pause-task Pauses a specified running task. purge-relay Purges relay log files of the DM-worker according to the specified filename. query-status Queries task status. resume-relay Resumes DM-worker's relay unit. resume-task Resumes a specified paused task. show-ddl-locks Shows un-resolved DDL locks. start-task Starts a task as defined in the configuration file. stop-task Stops a specified task. unlock-ddl-lock Unlocks DDL lock forcefully. Flags: -h, --help Help for dmctl. -s, --source strings MySQL Source ID. Use "dmctl [command] --help" for more information about a command.
The command mode differs from the interactive mode in that you need to append the task operation right after the dmctl command. The parameters of the task operation in the command mode are the same as those in the interactive mode.
- A dmctl command must be followed by only one task operation.
- Starting from v2.0.4, DM supports reading the
-master-addrparameter from the environment variable
./dmctl --master-addr 172.16.30.14:8261 start-task task.yaml ./dmctl --master-addr 172.16.30.14:8261 stop-task task ./dmctl --master-addr 172.16.30.14:8261 query-status export DM_MASTER_ADDR="172.16.30.14:8261" ./dmctl query-status
Available Commands: check-task check-task <config-file> [--error count] [--warn count] config commands to import/export config get-config get-config <task | master | worker | source> <name> [--file filename] handle-error handle-error <task-name | task-file> [-s source ...] [-b binlog-pos] <skip/replace/revert> [replace-sql1;replace-sql2;] list-member list-member [--leader] [--master] [--worker] [--name master-name/worker-name ...] offline-member offline-member <--master/--worker> <--name master-name/worker-name> operate-leader operate-leader <operate-type> operate-schema operate-schema <operate-type> <-s source ...> <task-name | task-file> <-d database> <-t table> [schema-file] operate-source operate-source <operate-type> [config-file ...] [--print-sample-config] pause-relay pause-relay <-s source ...> pause-task pause-task [-s source ...] <task-name | task-file> purge-relay purge-relay <-s source> <-f filename> [--sub-dir directory] query-status query-status [-s source ...] [task-name | task-file] [--more] resume-relay resume-relay <-s source ...> resume-task resume-task [-s source ...] <task-name | task-file> show-ddl-locks show-ddl-locks [-s source ...] [task-name | task-file] start-task start-task [-s source ...] [--remove-meta] <config-file> stop-task stop-task [-s source ...] <task-name | task-file> unlock-ddl-lock unlock-ddl-lock <lock-ID> Special Commands: --encrypt Encrypts plaintext to ciphertext. --decrypt Decrypts ciphertext to plaintext. Global Options: --V Prints version and exit. --config Path to configuration file. --master-addr Master API server addr. --rpc-timeout RPC timeout, default is 10m. --ssl-ca Path of file that contains list of trusted SSL CAs for connection. --ssl-cert Path of file that contains X509 certificate in PEM format for connection. --ssl-key Path of file that contains X509 key in PEM format for connection.