Maintain DM Clusters Using dmctl

Manage Using dmctl - 图1

Note

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.

Interactive mode

Enter the interactive mode to interact with DM-master:

Manage Using dmctl - 图2

Note

The interactive mode does not support Bash features. For example, you need to directly pass string flags instead of passing them in quotes.

  1. ./dmctl --master-addr 172.16.30.14:8261
  1. Welcome to dmctl
  2. Release Version: ${version}
  3. Git Commit Hash: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
  4. Git Branch: release-x.x
  5. UTC Build Time: yyyy-mm-dd hh:mm:ss
  6. Go Version: go version gox.xx linux/amd64
  8. » help
  9. DM control
  11. Usage:
  12.   dmctl [command]
  14. Available Commands:
  15.   binlog          manage or show binlog operations
  16.   binlog-schema   manage or show table schema in schema tracker
  17.   check-task      Checks the configuration file of the task
  18.   config          manage config operations
  19.   encrypt         Encrypts plain text to cipher text
  20.   help            Gets help about any command
  21.   list-member     Lists member information
  22.   offline-member  Offlines member which has been closed
  23.   operate-leader  `evict`/`cancel-evict` the leader
  24.   operate-source  `create`/`stop`/`show` upstream MySQL/MariaDB source
  25.   pause-relay     Pauses DM-worker's relay unit
  26.   pause-task      Pauses a specified running task or all (sub)tasks bound to a source
  27.   purge-relay     Purges relay log files of the DM-worker according to the specified filename
  28.   query-status    Queries task status
  29.   resume-relay    Resumes DM-worker's relay unit
  30.   resume-task     Resumes a specified paused task or all (sub)tasks bound to a source
  31.   shard-ddl-lock  maintain or show shard-ddl locks information
  32.   start-relay     Starts workers pulling relay log for a source
  33.   start-task      Starts a task as defined in the configuration file
  34.   stop-relay      Stops workers pulling relay log for a source
  35.   stop-task       Stops a specified task or all (sub)tasks bound to a source
  36.   transfer-source Transfers a upstream MySQL/MariaDB source to a free worker
  38. Flags:
  39.   -h, --help             Help for dmctl.
  40.   -s, --source strings   MySQL Source ID.
  42. Use "dmctl [command] --help" for more information about a command.

Command mode

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.

Manage Using dmctl - 图3

Note

  • A dmctl command must be followed by only one task operation.
  • Starting from v2.0.4, DM supports reading the -master-addr parameter from the environment variable DM_MASTER_ADDR.
  1. ./dmctl --master-addr 172.16.30.14:8261 start-task task.yaml
  2. ./dmctl --master-addr 172.16.30.14:8261 stop-task task
  3. ./dmctl --master-addr 172.16.30.14:8261 query-status
  5. export DM_MASTER_ADDR="172.16.30.14:8261"
  6. ./dmctl query-status
  1. Available Commands:
  2.   binlog          manage or show binlog operations
  3.   binlog-schema   manage or show table schema in schema tracker
  4.   check-task      Checks the configuration file of the task
  5.   config          manage config operations
  6.   encrypt         Encrypts plain text to cipher text
  7.   help            Gets help about any command
  8.   list-member     Lists member information
  9.   offline-member  Offlines member which has been closed
  10.   operate-leader  `evict`/`cancel-evict` the leader
  11.   operate-source  `create`/`stop`/`show` upstream MySQL/MariaDB source
  12.   pause-relay     Pauses DM-worker's relay unit
  13.   pause-task      Pauses a specified running task or all (sub)tasks bound to a source
  14.   purge-relay     Purges relay log files of the DM-worker according to the specified filename
  15.   query-status    Queries task status
  16.   resume-relay    Resumes DM-worker's relay unit
  17.   resume-task     Resumes a specified paused task or all (sub)tasks bound to a source
  18.   shard-ddl-lock  maintain or show shard-ddl locks information
  19.   start-relay     Starts workers pulling relay log for a source
  20.   start-task      Starts a task as defined in the configuration file
  21.   stop-relay      Stops workers pulling relay log for a source
  22.   stop-task       Stops a specified task or all (sub)tasks bound to a source
  23.   transfer-source Transfers a upstream MySQL/MariaDB source to a free worker
  25. Flags:
  26.       --config string        Path to config file.
  27.   -h, --help                 help for dmctl
  28.       --master-addr string   Master API server address, this parameter is required when interacting with the dm-master
  29.       --rpc-timeout string   RPC timeout, default is 10m. (default "10m")
  30.   -s, --source strings       MySQL Source ID.
  31.       --ssl-ca string        Path of file that contains list of trusted SSL CAs for connection.
  32.       --ssl-cert string      Path of file that contains X509 certificate in PEM format for connection.
  33.       --ssl-key string       Path of file that contains X509 key in PEM format for connection.
  34.   -V, --version              Prints version and exit.
  36. Use "dmctl [command] --help" for more information about a command.