【TIDB】关闭tidbv5.1.1 的 binlog 功能

最新推荐文章于 2024-09-25 11:41:26 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2024-09-25 11:41:26 发布

阅读量181

点赞数 1

分类专栏：国产数据库-TIDB 文章标签： tidb

本文链接：https://blog.csdn.net/weixin_43346403/article/details/141284638

版权

国产数据库-TIDB 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

1.检查现有的binlog

--当前binlog 已经开启，且同步到:1.14节点上。
mysql> show pump status;
+-------------------+-------------------+--------+--------------------+---------------------+
| NodeID            | Address           | State  | Max_Commit_Ts      | Update_Time         |
+-------------------+-------------------+--------+--------------------+---------------------+
| 192.168.1.14:8250 | 192.168.1.14:8250 | online | 451907091865534465 | 2024-08-17 17:59:09 |
+-------------------+-------------------+--------+--------------------+---------------------+
1 row in set (0.01 sec)

mysql> show drainer status;
+-------------------+-------------------+--------+--------------------+---------------------+
| NodeID            | Address           | State  | Max_Commit_Ts      | Update_Time         |
+-------------------+-------------------+--------+--------------------+---------------------+
| 192.168.1.14:8249 | 192.168.1.14:8249 | online | 451907093438136321 | 2024-08-17 17:59:16 |
+-------------------+-------------------+--------+--------------------+---------------------+
1 row in set (0.01 sec)

mysql>  show global variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.02 sec)

2.编辑配置关闭 binlog

tiup cluster edit-config tidbcluster
 
server_configs:
  tidb:
    binlog.enable: false
    binlog.ignore-error: false
    log.slow-threshold: 300

--重启;
tiup cluster reload tidbcluster

3.检查binlog;

mysql> show drainer status;
+-------------------+-------------------+--------+--------------------+---------------------+
| NodeID            | Address           | State  | Max_Commit_Ts      | Update_Time         |
+-------------------+-------------------+--------+--------------------+---------------------+
| 192.168.1.14:8249 | 192.168.1.14:8249 | online | 451907180063883266 | 2024-08-17 18:04:44 |
+-------------------+-------------------+--------+--------------------+---------------------+
1 row in set (0.01 sec)

mysql> show pump status;
+-------------------+-------------------+--------+--------------------+---------------------+
| NodeID            | Address           | State  | Max_Commit_Ts      | Update_Time         |
+-------------------+-------------------+--------+--------------------+---------------------+
| 192.168.1.14:8250 | 192.168.1.14:8250 | online | 451907181636747265 | 2024-08-17 18:04:51 |
+-------------------+-------------------+--------+--------------------+---------------------+
1 row in set (0.00 sec)

mysql>  show global variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.01 sec)

--由此可见，binlog 已经关闭，但是 drainer服务和pump 服务是开启的。

4.下线 drainer,pump 服务。

(1)卸载 drainer:

[tidb@mysql1 soft]$ tiup cluster display tidbcluster
Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.5.3/tiup-cluster display tidbcluster
Cluster type:       tidb
Cluster name:       tidbcluster
Cluster version:    v5.1.1
Deploy user:        tidb
SSH type:           builtin
Dashboard URL:      http://192.168.1.13:2379/dashboard
ID                  Role            Host          Ports                            OS/Arch       Status   Data Dir                           Deploy Dir
--                  ----            ----          -----                            -------       ------   --------                           ----------
192.168.1.11:9093   alertmanager    192.168.1.11  9093/9094                        linux/x86_64  Up       /tidb/tidb-data/alertmanager-9093  /tidb/tidb-deploy/alertmanager-9093
192.168.1.11:8300   cdc             192.168.1.11  8300                             linux/x86_64  Up       /tidb/tidb-data/cdc-8300           /tidb/tidb-deploy/cdc-8300
192.168.1.14:8249   drainer         192.168.1.14  8249                             linux/x86_64  Up       /tidb/tidb-data/drainer-8249       /tidb/tidb-deploy/drainer-8249
192.168.1.11:3000   grafana         192.168.1.11  3000                             linux/x86_64  Up       -                                  /tidb/tidb-deploy/grafana-3000
192.168.1.11:2379   pd              192.168.1.11  2379/2380                        linux/x86_64  Up       /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.12:2379   pd              192.168.1.12  2379/2380                        linux/x86_64  Up       /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.13:2379   pd              192.168.1.13  2379/2380                        linux/x86_64  Up|L|UI  /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.11:9090   prometheus      192.168.1.11  9090                             linux/x86_64  Up       /tidb/tidb-data/prometheus-9090    /tidb/tidb-deploy/prometheus-9090
192.168.1.14:8250   pump            192.168.1.14  8250                             linux/x86_64  Up       /tidb/tidb-data/pump-8250          /tidb/tidb-deploy/pump-8250
192.168.1.11:4000   tidb            192.168.1.11  4000/10080                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4000
192.168.1.12:4001   tidb            192.168.1.12  4001/10081                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4001
192.168.1.13:4000   tidb            192.168.1.13  4000/10080                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4000
192.168.1.11:9000   tiflash         192.168.1.11  9000/8123/3930/20170/20292/8234  linux/x86_64  Up       /tidb/tidb-data/tiflash-9000       /tidb/tidb-deploy/tiflash-9000
192.168.1.11:20160  tikv            192.168.1.11  20160/20180                      linux/x86_64  Up       /tidb/tidb-data/tikv-20160         /tidb/tidb-deploy/tikv-20160
192.168.1.12:20161  tikv            192.168.1.12  20161/20181                      linux/x86_64  Up       /tidb/tidb-data/tikv-20161         /tidb/tidb-deploy/tikv-20161
192.168.1.13:20160  tikv            192.168.1.13  20160/20180                      linux/x86_64  Up       /tidb/tidb-data/tikv-20160         /tidb/tidb-deploy/tikv-20160
192.168.1.11:7077   tispark-master  192.168.1.11  7077/8080                        linux/x86_64  Up       -                                  /tidb/tidb-deploy/tispark-master-7077
192.168.1.11:7078   tispark-worker  192.168.1.11  7078/8081                        linux/x86_64  Up       -                                  /tidb/tidb-deploy/tispark-worker-7078


--卸载drainer;
tiup cluster scale-in tidbcluster --node 192.168.1.14:8249
--卸载pump;
tiup cluster scale-in tidbcluster --node 192.168.1.14:8250

--清理死亡节点: 
tiup cluster prune tidbcluster

5.检查集群

tiup cluster display tidbcluster
[tidb@mysql1 soft]$ tiup cluster display tidbcluster
Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.5.3/tiup-cluster display tidbcluster
Cluster type:       tidb
Cluster name:       tidbcluster
Cluster version:    v5.1.1
Deploy user:        tidb
SSH type:           builtin
Dashboard URL:      http://192.168.1.13:2379/dashboard
ID                  Role            Host          Ports                            OS/Arch       Status   Data Dir                           Deploy Dir
--                  ----            ----          -----                            -------       ------   --------                           ----------
192.168.1.11:9093   alertmanager    192.168.1.11  9093/9094                        linux/x86_64  Up       /tidb/tidb-data/alertmanager-9093  /tidb/tidb-deploy/alertmanager-9093
192.168.1.11:8300   cdc             192.168.1.11  8300                             linux/x86_64  Up       /tidb/tidb-data/cdc-8300           /tidb/tidb-deploy/cdc-8300
192.168.1.11:3000   grafana         192.168.1.11  3000                             linux/x86_64  Up       -                                  /tidb/tidb-deploy/grafana-3000
192.168.1.11:2379   pd              192.168.1.11  2379/2380                        linux/x86_64  Up       /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.12:2379   pd              192.168.1.12  2379/2380                        linux/x86_64  Up       /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.13:2379   pd              192.168.1.13  2379/2380                        linux/x86_64  Up|L|UI  /tidb/tidb-data/pd-2379            /tidb/tidb-deploy/pd-2379
192.168.1.11:9090   prometheus      192.168.1.11  9090                             linux/x86_64  Up       /tidb/tidb-data/prometheus-9090    /tidb/tidb-deploy/prometheus-9090
192.168.1.11:4000   tidb            192.168.1.11  4000/10080                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4000
192.168.1.12:4001   tidb            192.168.1.12  4001/10081                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4001
192.168.1.13:4000   tidb            192.168.1.13  4000/10080                       linux/x86_64  Up       -                                  /tidb/tidb-deploy/tidb-4000
192.168.1.11:9000   tiflash         192.168.1.11  9000/8123/3930/20170/20292/8234  linux/x86_64  Up       /tidb/tidb-data/tiflash-9000       /tidb/tidb-deploy/tiflash-9000
192.168.1.11:20160  tikv            192.168.1.11  20160/20180                      linux/x86_64  Up       /tidb/tidb-data/tikv-20160         /tidb/tidb-deploy/tikv-20160
192.168.1.12:20161  tikv            192.168.1.12  20161/20181                      linux/x86_64  Up       /tidb/tidb-data/tikv-20161         /tidb/tidb-deploy/tikv-20161
192.168.1.13:20160  tikv            192.168.1.13  20160/20180                      linux/x86_64  Up       /tidb/tidb-data/tikv-20160         /tidb/tidb-deploy/tikv-20160
192.168.1.11:7077   tispark-master  192.168.1.11  7077/8080                        linux/x86_64  Up       -                                  /tidb/tidb-deploy/tispark-master-7077
192.168.1.11:7078   tispark-worker  192.168.1.11  7078/8081                        linux/x86_64  Up       -                                  /tidb/tidb-deploy/tispark-worker-7078
Total nodes: 16

mysql>  show global variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.19 sec)

mysql> show pump status;
Empty set (0.02 sec)

mysql> show drainer status;
Empty set (0.01 sec)

--由此可见，trainer服务,pump服务均已清理完毕，同时binlog 功能也已经关闭。