执行initnodedatamap 命令初始化hashmap,然后将数据通过rebalance instance 命令
重分布到最新的distribution(Distribution ID: 2)上。
说明
按distribution 分布规则,此次rebalance 操作不会实际进行数据搬移,所
以会很快完成;
本次rebalance 操作后不要删掉旧版nodedatamap 和distribution。
操作步骤
步骤1 :
步骤1:初始化hashmap:
$ gccli -uroot
GBase client 9.5.3.17.117651. Copyright (c) 2004-2020, GBase.
All Rights
Reserved.
gbase> use vc vc1;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)
gbase> initnodedatamap;
Query OK, 0 rows affected, 5 warnings (Elapsed: 00:00:01.45)
步骤2:执行数据重分布:
gbase> rebalance database demo;
Query OK, 2 rows affected (Elapsed: 00:00:01.45)
查看rebalance 状态:
gbase> rebalance instance;
Query OK, 3 rows affected (Elapsed: 00:00:05.60)
gbase>
select
index_name,status,percentage,priority,host,distribution_id
from
gclusterdb.rebalancing_status;
+------------+-----------+------------+----------+---------------+-----------------+
| index_name | status
| percentage | priority | host
| distribution_id |
+------------+-----------+------------+----------+---------------+-----------------+
| demo.tt
| COMPLETED |
100 |
5 | 172.168.83.11 |
3 |
| demo.t
| COMPLETED |
100 |
5 | 172.168.83.11 |
3 |
| demo.ttt
| COMPLETED |
100 |
5 | 172.168.83.11 |
3 |
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
301
gbase> rebalance database demo;
Query OK, 2 rows affected (Elapsed: 00:00:01.45)
+------------+-----------+------------+----------+---------------+-----------------+
3 rows in set (Elapsed: 00:00:00.17)
gbase> quit
Bye