CHANGE DRAINER

The CHANGE DRAINER statement modifies the status information for Drainer in the cluster.

CHANGE DRAINER - 图1

Note

This feature is only applicable to TiDB Self-Hosted and not available on TiDB Cloud.

CHANGE DRAINER - 图2

Tip

Drainer’s state is automatically reported to PD while running. Only when Drainer is under abnormal circumstances and its state is inconsistent with the state information stored in PD, you can use the CHANGE DRAINER statement to modify the state information stored in PD.

Examples

  1. SHOW DRAINER STATUS;
  1. +----------|----------------|--------|--------------------|---------------------|
  2. |  NodeID  |     Address    | State  |   Max_Commit_Ts    |    Update_Time      |
  3. +----------|----------------|--------|--------------------|---------------------|
  4. | drainer1 | 127.0.0.3:8249 | Online | 408553768673342532 | 2019-04-30 00:00:03 |
  5. +----------|----------------|--------|--------------------|---------------------|
  6. | drainer2 | 127.0.0.4:8249 | Online | 408553768673345531 | 2019-05-01 00:00:04 |
  7. +----------|----------------|--------|--------------------|---------------------|
  8. 2 rows in set (0.00 sec)

It can be seen that drainer1’s state has not been updated for more than a day, the Drainer is in an abnormal state, but the State remains Online. After using CHANGE DRAINER, the Drainer’s State is changed to ‘paused’:

  1. CHANGE DRAINER TO NODE_STATE ='paused' FOR NODE_ID 'drainer1';
  1. Query OK, 0 rows affected (0.01 sec)
  1. SHOW DRAINER STATUS;
  1. +----------|----------------|--------|--------------------|---------------------|
  2. |  NodeID  |     Address    | State  |   Max_Commit_Ts    |    Update_Time      |
  3. +----------|----------------|--------|--------------------|---------------------|
  4. | drainer1 | 127.0.0.3:8249 | Paused | 408553768673342532 | 2019-04-30 00:00:03 |
  5. +----------|----------------|--------|--------------------|---------------------|
  6. | drainer2 | 127.0.0.4:8249 | Online | 408553768673345531 | 2019-05-01 00:00:04 |
  7. +----------|----------------|--------|--------------------|---------------------|
  8. 2 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also