Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
show variables like "log_bin";

show pump status;

show drainer status;

总结:

1.先将pump的节点缩容到12.配置tidb的binlogEnabled: false配置tidb的binlogEnabled: false

2.将pump节点缩容到0

如果pump的pod无法自动删除,可以标记为下线

Code Block
kubectl -n tidb exec -it tidb-cluster-drainer-0 bash
/binlogctl -pd-urls=http://tidb-cluster-pd:2379 -cmd update-pump -node-id tidb-cluster-pump-0:8250 --state offline
/binlogctl -pd-urls=http://tidb-cluster-pd:2379 -cmd update-pump -node-id tidb-cluster-pump-1:8250 --state offline
/binlogctl -pd-urls=http://tidb-cluster-pd:2379 -cmd update-pump -node-id tidb-cluster-pump-2:8250 --state offline


3.删除pump配置项

4.删除 Pump StatefulSet 资源

5.移除pump的pvc资源

6. kubectl run offline-drainer-0 --image=pingcap/tidb-binlog:${tidb_version} --namespace=${namespace} --restart=OnFailure -- /binlogctl 进入到drainer的pod中


Code Block
kubectl -n tidb exec -it tidb-cluster-drainer-0 bash
##如果有多个drainer需要执行多次tidb-cluster-drainer-0:8249
/binlogctl -pd-urls=http://

...

tidb-cluster-pd:2379 -cmd offline-drainer -node-id

...

 tidb-cluster-drainer-0:8249


7.删除 Drainer StatefulSet 资源

...