<\/span><\/h3>\n\n\n\n\u901a\u8fc7rebalance table to \u65b9\u6cd5\uff0c\u5c06\u8868\u56de\u9000\u52301\uff0c\u6ce8\u610f\u5176\u4e2d\u7684gclusterdb.rebalancing_status\u4e0d\u80fd\u624b\u5de5\u56de\u9000\u3002<\/p>\n\n\n\n
gbase> rebalance table testdb.t4 to 1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.05)\n\ngbase> rebalance table gclusterdb.dual to 1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.06)\n\ngbase> rebalance table gclusterdb.rebalancing_status to 1;\nERROR 1707 (HY000): gcluster command error: system table can't be rebalanced.\n\n\ngbase> select * from gbase.table_distribution order by data_distribution_id;;\n+------------------------------------+------------+-------------------------+-------------+-------------+------------------+--------------------+-------------+----------------------+---------+--------------+\n| index_name | dbName | tbName | isReplicate | hash_column | lmt_storage_size | table_storage_size | is_nocopies | data_distribution_id | vc_id | mirror_vc_id |\n+------------------------------------+------------+-------------------------+-------------+-------------+------------------+--------------------+-------------+----------------------+---------+--------------+\n| gclusterdb.dual | gclusterdb | dual | YES | NULL | NULL | NULL | NO | 1 | vc00001 | NULL |\n| gclusterdb.rebalancing_status | gclusterdb | rebalancing_status | NO | index_name | NULL | NULL | NO | 1 | vc00001 | NULL |\n| testdb.t1 | testdb | t1 | NO | NULL | NULL | NULL | NO | 1 | vc00001 | vc00002 |\n| testmirror.t1 | testmirror | t1 | NO | NULL | NULL | NULL | NO | 1 | vc00001 | vc00002 |\n| testdb.t2 | testdb | t2 | NO | NULL | NULL | NULL | NO | 1 | vc00001 | vc00002 |\n| testdb.t3 | testdb | t3 | NO | NULL | NULL | NULL | NO | 1 | vc00001 | vc00002 |\n| testdb.t4 | testdb | t4 | NO | NULL | NULL | NULL | NO | 1 | vc00001 | |\n| testdb.t_encrypt | testdb | t_encrypt | NO | NULL | NULL | NULL | NO | 1 | vc00001 | vc00002 |\n\u3002\u3002\u3002\u3002\u3002\n+------------------------------------+------------+-------------------------+-------------+-------------+------------------+--------------------+-------------+----------------------+---------+--------------+\n82 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
<\/span>\u518d\u6b21\u6e05\u7406\u91cd\u5206\u5e03\u4efb\u52a1\u8868<\/span><\/h3>\n\n\n\ngbase> select * from gclusterdb.rebalancing_status;\n+-----------------+------------+------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\n+-----------------+------------+------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\n| testdb.t4 | testdb | t4 | | 2021-03-22 15:52:12.401000 | 2021-03-22 15:52:12.809000 | COMPLETED | 100 | 5 | 10.0.2.101 | 1 |\n| gclusterdb.dual | gclusterdb | dual | | 2021-03-22 15:52:42.051000 | 2021-03-22 15:52:42.515000 | COMPLETED | 100 | 5 | 10.0.2.101 | 1 |\n+-----------------+------------+------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\n2 rows in set (Elapsed: 00:00:00.02)\n\ngbase> delete from rebalancing_status;\nQuery OK, 2 rows affected (Elapsed: 00:00:00.26)\n\ngbase> select * from rebalancing_status;\nEmpty set (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<\/span>\u91cd\u65b0\u5f00\u59cb\u91cd\u5206\u5e03<\/span><\/h3>\n\n\n\n\u53c2\u8003\u91cd\u5206\u5e03\u65b9\u6848\uff0c\u4e0d\u518d\u91cd\u590d\u3002<\/p>\n\n\n\n
<\/p>","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u652f\u6301\u5728\u7ebf\u6269\u5bb9\uff0c\u5176\u4e2d\u91cd\u5206\u5e03\u6b65\u9aa4rebalance\uff0c\u5c06\u8001\u6570\u636e\u91cd\u5206\u5e03\u5230\u65b0\u7684\u5206\u5e03\u7b56\u7565\uff08distirbution id\uff09\uff0c\u5728\u67d0\u4e9b\u60c5\u51b5\u4e0b\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7rebalance to \u5c06\u65b0\u7b56\u7565\u6570\u636e\uff0c\u56de\u9000\u5230\u8001\u7684\u7b56\u7565\u4e0a\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5170","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=5170"}],"version-history":[{"count":3,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5170\/revisions"}],"predecessor-version":[{"id":5174,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5170\/revisions\/5174"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=5170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=5170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=5170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}