CHANGE DRAINER

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

Examples

SHOW DRAINER STATUS;
+----------|----------------|--------|--------------------|---------------------| | NodeID | Address | State | Max_Commit_Ts | Update_Time | +----------|----------------|--------|--------------------|---------------------| | drainer1 | 127.0.0.3:8249 | Online | 408553768673342532 | 2019-04-30 00:00:03 | +----------|----------------|--------|--------------------|---------------------| | drainer2 | 127.0.0.4:8249 | Online | 408553768673345531 | 2019-05-01 00:00:04 | +----------|----------------|--------|--------------------|---------------------| 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':

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

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also

Was this page helpful?