【TIDB】收缩TIDB-SERVER

最新推荐文章于 2024-10-18 23:42:31 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2024-10-18 23:42:31 发布

阅读量124

点赞数 3

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

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

版权

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

42 篇文章 0 订阅

订阅专栏

1.tidb-server 查看

mysql> select * from INFORMATION_SCHEMA.CLUSTER_INFO;
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+------------------+
| TYPE | INSTANCE           | STATUS_ADDRESS     | VERSION | GIT_HASH                                 | START_TIME                | UPTIME           |
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+------------------+
| tidb | 192.168.1.11:4000  | 192.168.1.11:10080 | 4.0.7   | ed939f3f11599b5a38352c5c160c917df3ebf3eb | 2024-08-15T18:52:08+08:00 | 14m9.410687394s  |
| tidb | 192.168.1.12:4000  | 192.168.1.12:10080 | 4.0.7   | ed939f3f11599b5a38352c5c160c917df3ebf3eb | 2024-08-15T18:52:07+08:00 | 14m10.41069314s  |
| tidb | 192.168.1.13:4000  | 192.168.1.13:10080 | 4.0.7   | ed939f3f11599b5a38352c5c160c917df3ebf3eb | 2024-08-15T18:52:07+08:00 | 14m10.410694591s |
| pd   | 192.168.1.13:2379  | 192.168.1.13:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T18:51:39+08:00 | 14m38.4106973s   |
| pd   | 192.168.1.11:2379  | 192.168.1.11:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T18:51:39+08:00 | 14m38.410698657s |
| pd   | 192.168.1.12:2379  | 192.168.1.12:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T18:51:42+08:00 | 14m35.41070003s  |
| tikv | 192.168.1.11:20160 | 192.168.1.11:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T18:51:55+08:00 | 14m22.41070122s  |
| tikv | 192.168.1.13:20160 | 192.168.1.13:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T18:51:53+08:00 | 14m24.410702373s |
| tikv | 192.168.1.12:20160 | 192.168.1.12:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T18:51:54+08:00 | 14m23.410703586s |
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+------------------+
9 rows in set (0.02 sec)

我们由三个缩到一个。

2.停止

ansible-playbook stop.yml -l 192.168.1.12
ansible-playbook stop.yml -l 192.168.1.13

3.修改配置文件。

ansible-playbook deploy.yml  -f 10

4.启动其他服务。

ansible-playbook start.yml -l 192.168.1.12
ansible-playbook start.yml -l 192.168.1.13

5.检查节点 。
mysql> 
mysql> select * from INFORMATION_SCHEMA.CLUSTER_INFO;
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+---------------+
| TYPE | INSTANCE           | STATUS_ADDRESS     | VERSION | GIT_HASH                                 | START_TIME                | UPTIME        |
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+---------------+
| tidb | 192.168.1.11:4000  | 192.168.1.11:10080 | 4.0.7   | ed939f3f11599b5a38352c5c160c917df3ebf3eb | 2024-08-15T19:54:15+08:00 | 13.051455103s |
| pd   | 192.168.1.13:2379  | 192.168.1.13:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T19:53:50+08:00 | 38.051460315s |
| pd   | 192.168.1.11:2379  | 192.168.1.11:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T19:53:50+08:00 | 38.051461642s |
| pd   | 192.168.1.12:2379  | 192.168.1.12:2379  | 4.0.7   | 8b0348f545611d5955e32fdcf3c57a3f73657d77 | 2024-08-15T19:53:53+08:00 | 35.05146281s  |
| tikv | 192.168.1.11:20160 | 192.168.1.11:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T19:54:03+08:00 | 25.051464141s |
| tikv | 192.168.1.13:20160 | 192.168.1.13:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T19:54:02+08:00 | 26.051466113s |
| tikv | 192.168.1.12:20160 | 192.168.1.12:20180 | 4.0.7   | bc0a9b3974f32cc2e08244a6eaf5284e5e5f4d76 | 2024-08-15T19:54:02+08:00 | 26.051467302s |
+------+--------------------+--------------------+---------+------------------------------------------+---------------------------+---------------+
7 rows in set (0.03 sec)

6.数据验证  
--由此可见，现在已经缩到只有一个tidb-server了。
[tidb@mysql1 tidb-ansible-4.0.7]$ mysql -u root -h 192.168.1.11 -P 4000 -e "select * from test.my_tab1;"
+------+------------+
| id   | name       |
+------+------------+
|    1 | 薛双奇     |
|    2 | 雪霜期2    |
+------+------------+

mysql -u root -h 192.168.1.11 -P 4000 -e "insert into test.my_tab1 values(3,'xsq3');"
mysql -u root -h 192.168.1.11 -P 4000 -e "select * from test.my_tab1;"
[tidb@mysql1 tidb-ansible-4.0.7]$ mysql -u root -h 192.168.1.11 -P 4000 -e "insert into test.my_tab1 values(3,'xsq3');"
[tidb@mysql1 tidb-ansible-4.0.7]$ mysql -u root -h 192.168.1.11 -P 4000 -e "select * from test.my_tab1;"
+------+------------+
| id   | name       |
+------+------------+
|    1 | 薛双奇     |
|    2 | 雪霜期2    |
|    3 | xsq3       |