| distribution_id<\/td> | bigint<\/td> | \u76ee\u6807distribution_id<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\ngbase> desc rebalancing_status;\n+-----------------+--------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-----------------+--------------+------+-----+---------+-------+\n| index_name | varchar(129) | YES | | NULL | |\n| db_name | varchar(64) | YES | | NULL | |\n| table_name | varchar(64) | YES | | NULL | |\n| tmptable | varchar(129) | YES | | NULL | |\n| start_time | datetime | YES | | NULL | |\n| end_time | datetime | YES | | NULL | |\n| status | varchar(32) | YES | | NULL | |\n| percentage | int(11) | YES | | NULL | |\n| priority | int(11) | YES | | NULL | |\n| host | varchar(60) | YES | | NULL | |\n| distribution_id | bigint(8) | YES | | NULL | |\n+-----------------+--------------+------+-----+---------+-------+\n11 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u91cd\u5206\u5e03\u4efb\u52a1\u72b6\u6001<\/span><\/h2>\n\n\n\n- STARTING \u51c6\u5907\u72b6\u6001\uff0c\u6392\u961f\u4e2d<\/li>
- RUNNING \u6b63\u5728\u91cd\u5206\u5e03\u4e2d<\/li>
- COMPLETED \u5df2\u7ecf\u5b8c\u6210\u4e86\u91cd\u5206\u5e03<\/li>
- PAUSED \u4efb\u52a1\u6682\u505c<\/li>
- CANCELED \u4efb\u52a1\u53d6\u6d88<\/li><\/ul>\n\n\n\n
\u72b6\u6001\u8f6c\u6362\u89c4\u5219\u5982\u4e0b\u6240\u793a<\/p>\n\n\n\n![\"GBase](\"https:\/\/www.gbase8.cn\/wp-content\/uploads\/2021\/09\/16309123161.png\") <\/figure>\n\n\n\n- \u8868\u5904\u4e8e STARTING \u72b6\u6001\u65f6\uff0cCoordinator \u540e\u53f0\u7ebf\u7a0b\u5f00\u59cb\u6267\u884c\u8868\u7684 rebalance \u64cd\u4f5c\uff0c\u8868\u72b6\u6001\u8f6c\u6362\u6210 RUNNING\u3002<\/li>
- \u8868\u5904\u4e8e PAUSED \u72b6\u6001\u65f6\uff0c\u5bf9\u8fd9\u4e2a\u8868\u6267\u884c continue rebalance \u64cd\u4f5c\uff0c\u8868\u72b6\u6001\u8f6c\u6362\u6210RUNNING\u3002<\/li>
- \u8868\u5904\u4e8e RUNNING \u72b6\u6001\u65f6\uff0ccoordinator \u540e\u53f0\u7ebf\u7a0b\u6267\u884c\u8868\u7684 rebalance \u64cd\u4f5c\u5931\u8d25\uff0c\u8868\u72b6\u6001\u8f6c\u6362\u6210 STARTING\u3002<\/li>
- \u8868\u5904\u4e8e RUNNING \u72b6\u6001\u65f6\uff0ccoordinator \u540e\u53f0\u7ebf\u7a0b\u5b8c\u6210\u4e86\u8868\u7684 rebalance \u64cd\u4f5c\uff0c\u8868\u72b6\u6001\u8f6c\u6362\u6210 COMPLETED\u3002<\/li><\/ul>\n\n\n\n
<\/span>\u67e5\u8be2\u603b\u4f53\u91cd\u5206\u5e03\u8fdb\u5ea6<\/span><\/h2>\n\n\n\n\u6839\u636eSTATUS\u7edf\u8ba1\u6bcf\u4e2a\u72b6\u6001\u7684\u6570\u91cf\u3002\u5982\u4e0b\u4f8b\u5b50\uff0c\u7b49\u5f85\u4e2d\u768415\u4e2a\uff0c\u6b63\u5728\u91cd\u5206\u5e03\u76843\u4e2a\uff0c\u5b8c\u6210\u4e863\u4e2a\u3002<\/p>\n\n\n\n gbase> select status,count(*) from gclusterdb.rebalancing_status group by status;\n+-----------+----------+\n| status | count(*) |\n+-----------+----------+\n| STARTING | 15 |\n| RUNNING | 3 |\n| COMPLETED | 3 |\n+-----------+----------+\n3 rows in set (Elapsed: 00:00:00.61)<\/code><\/pre>\n\n\n\n\u5f53\u6240\u6709\u7684\u8868\u90fd\u5904\u4e8eCOMPLETED\u72b6\u6001\uff0c\u5219\u91cd\u5206\u5e03\u5168\u90e8\u5b8c\u6210\u3002<\/p>\n\n\n\n gbase> select status,count(*) from gclusterdb.rebalancing_status group by status;\n+-----------+----------+\n| status | count(*) |\n+-----------+----------+\n| COMPLETED | 21 |\n+-----------+----------+\n1 row in set (Elapsed: 00:00:00.19)<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770b\u6b63\u5728\u91cd\u5206\u5e03\u7684\u4efb\u52a1\u8fdb\u5ea6<\/span><\/h2>\n\n\n\n\u67e5\u770b\u72b6\u6001\u4e3aRUNNING\u7684\u8fdb\u5ea6\u3002\u5982\u4e0b\u662f4\u4e2a\u6b63\u5728\u8fd0\u884c\u7684\u4efb\u52a1\u3002<\/p>\n\n\n\n gbase> select * from rebalancing_status where status='RUNNING';\n+-----------------------------------+------------+----------------------------+----------+----------------------------+------------+-----------+------------+----------+----------+-----------------+\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\n+-----------------------------------+------------+----------------------------+----------+----------------------------+------------+-----------+------------+----------+----------+-----------------+\n| testdb.t1 | testdb | t1 | | 2018-11-07 09:05:35.216000 | | RUNNING | 30 | 5 | 2001::61 | 2 |\n| testdb.aggr_http_ci_hour_20180904 | testdb | aggr_http_ci_hour_20180904 | | 2018-11-07 09:05:35.276000 | | RUNNING | 10 | 5 | 2001::61 | 2 |\n| testdb.dim_ci | testdb | dim_ci | | 2018-11-07 09:05:35.333000 | | RUNNING | 50 | 5 | 2001::61 | 2 |\n| gclusterdb.audit_log_express | gclusterdb | audit_log_express | | 2018-11-07 09:05:35.251000 | | RUNNING | 20 | 5 | 2001::61 | 2 |\n+-----------------------------------+------------+----------------------------+----------+----------------------------+------------+-----------+------------+----------+----------+-----------------+\n4 rows in set (Elapsed: 00:00:00.02)<\/code><\/pre>\n\n\n\n\u9700\u8981\u6ce8\u610f\uff0c\u9ed8\u8ba4\u91cd\u5206\u5e03\u65f6\uff0c\u6bcf\u4e2a\u8282\u70b9\uff0c\u6bcf\u6b21\u5904\u7406\u7684\u6570\u636e\u662f\u901a\u8fc7\u53c2\u6570\uff08gcluster_rebalancing_step\uff09\u914d\u7f6e\u7684\uff0c\u5728V8\u91cc\u9ed8\u8ba4\u662f2000\u4e07\u884c\uff0c\u5728V95\u91cc\u662f1\u4ebf\u884c\u3002<\/p>\n\n\n\n \u518d\u6b21\u63d0\u9192\uff0c\u662f\u6bcf\u4e2a\u8282\u70b9\u3002\u6bd4\u5982100\u4e00\u884c\uff0c10\u4e2a\u8282\u70b9\u5e73\u5747\uff0c\u5219\u6bcf\u4e2a\u8282\u70b9\u5904\u740610\u4ebf\u884c\uff0c\u9700\u8981\u5904\u740610\u8f6e\u3002\u5bf9\u5e94\u7684percentage\u5728\u5904\u7406\u65f6\u4f1a\u53d8\u52a8\u3002\u5982\u679c\u8282\u70b9\u5904\u7406\u7684\u6570\u636e\u5c11\u4e8e\u53c2\u6570\u503c\uff0c\u5219\u4e00\u6b21\u6027\u5904\u7406\uff0cpercentage\u4ece0\u76f4\u63a5\u523099\u6216\u8005100\u3002<\/p>\n\n\n\n <\/span>\u6682\u5b9a\u91cd\u5206\u5e03<\/span><\/h2>\n\n\n\npause rebalance table \u5e93\u540d.\u8868\u540d<\/p>\n\n\n\n \u4ee5rebalancing_status\u91cc\u9762\u7684index_name\u4e3a\u51c6\u3002<\/p>\n\n\n\n gbase> select * from rebalancing_status;\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| testdb.t1 | testdb | t1 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t2 | testdb | t2 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure | testdb | t_procedure | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure_testdb | testdb | t_procedure_testdb | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_enc | testdb | t_enc | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.ta | testdb | ta | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n6 rows in set (Elapsed: 00:00:00.01)\r\n\r\ngbase> pause rebalance table testdb.t1;\r\nQuery OK, 1 row affected (Elapsed: 00:00:00.08)\r\n\r\ngbase> select * from rebalancing_status;\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| testdb.t1 | testdb | t1 | NULL | 2022-06-01 09:49:42.633000 | NULL | PAUSED | 0 | 5 | NULL | 4 |\r\n| testdb.t2 | testdb | t2 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure | testdb | t_procedure | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure_testdb | testdb | t_procedure_testdb | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_enc | testdb | t_enc | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.ta | testdb | ta | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n6 rows in set (Elapsed: 00:00:00.14)\r\n\r\n<\/code><\/pre>\n\n\n\n<\/span>\u7ee7\u7eed\u91cd\u5206\u5e03<\/span><\/h2>\n\n\n\ncontinue rebalance table \u5e93\u540d.\u8868\u540d<\/p>\n\n\n\n \u4ee5rebalancing_status\u91cc\u9762\u7684index_name\u4e3a\u51c6\u3002<\/p>\n\n\n\n gbase> select * from rebalancing_status;\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n| testdb.t1 | testdb | t1 | NULL | 2022-06-01 09:49:42.633000 | NULL | PAUSED | 0 | 5 | NULL | 4 |\r\n| testdb.t2 | testdb | t2 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure | testdb | t_procedure | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure_testdb | testdb | t_procedure_testdb | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_enc | testdb | t_enc | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.ta | testdb | ta | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------+----------+------------+----------+------+-----------------+\r\n6 rows in set (Elapsed: 00:00:00.14)\r\n\r\ngbase>\r\ngbase>\r\ngbase>\r\ngbase> continue rebalance table testdb.t1;\r\nQuery OK, 1 row affected (Elapsed: 00:00:00.08)\r\n\r\ngbase> select * from rebalancing_status;\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\r\n| index_name | db_name | table_name | tmptable | start_time | end_time | status | percentage | priority | host | distribution_id |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\r\n| testdb.t1 | testdb | t1 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t2 | testdb | t2 | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure | testdb | t_procedure | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_procedure_testdb | testdb | t_procedure_testdb | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.t_enc | testdb | t_enc | NULL | 2022-06-01 09:49:42.633000 | NULL | STARTING | 0 | 5 | NULL | 4 |\r\n| testdb.ta | testdb | ta | NULL | 2022-06-01 09:56:27.395000 | 2022-06-01 09:56:27.395000 | COMPLETED | 0 | 5 | 10.0.2.101 | 4 |\r\n+---------------------------+---------+--------------------+----------+----------------------------+----------------------------+-----------+------------+----------+------------+-----------------+\r\n6 rows in set (Elapsed: 00:00:00.01)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u53d6\u6d88\u91cd\u5206\u5e03<\/span><\/h2>\n\n\n\ncancel rebalance table \u5e93\u540d.\u8868\u540d<\/p>\n\n\n\n \u4ee5rebalancing_status\u91cc\u9762\u7684index_name\u4e3a\u51c6\u3002<\/p>\n\n\n\n \u4e0d\u4fdd\u8bc1\u4e00\u5b9a\u80fd\u6210\u529f\u3002<\/p>\n\n\n\n <\/span>Summary<\/span><\/h2>\n\n\n\n\u901a\u8fc7\u7edf\u8ba1\u5df2\u7ecfFINISHED\u72b6\u6001\u7684\u8868\u6570\u91cf\uff0c\u8ba1\u7b97\u51fa\u6574\u4f53\u8fdb\u5ea6\u3002\u901a\u8fc7\u67e5\u8be2RUNNING\u72b6\u6001\u7684\u6570\u636e\uff0c\u67e5\u770b\u5f53\u524d\u8868\u7684\u8fdb\u5ea6\u3002<\/p>\n\n\n\n \u7531\u4e8e\u4e0d\u540c\u7684\u8868\uff0c\u6570\u636e\u91cf\u4e0d\u540c\uff0c\u8017\u65f6\u4e0d\u540c\uff0c\u6240\u4ee5\u901a\u8fc7\u8fdb\u5ea6\u6765\u8bc4\u4f30\u9884\u8ba1\u8017\u65f6\uff0c\u5e76\u6ca1\u6709\u90a3\u4e48\u7cbe\u786e\uff0c\u53ea\u80fd\u4f5c\u4e3a\u53c2\u8003\u3002\u7528\u6237\u53ef\u4ee5\u6839\u636e\u4e1a\u52a1\u6570\u636e\u91cf\u60c5\u51b5\uff0c\u5212\u5206\u4e0d\u540c\u7684\u4f18\u5148\u7ea7\uff0c\u4ee5\u6b64\u6765\u8bc4\u4f30\u6bcf\u4e2a\u4e0d\u540c\u4f18\u5148\u7ea7\u7684\u5b8c\u6210\u8fdb\u5ea6\uff0c\u76f8\u5bf9\u66f4\u51c6\u786e\u4e9b\u3002<\/p>","protected":false},"excerpt":{"rendered":" \u5357\u5927\u901a\u7528GBase 8a\u6269\u5bb9\u7f29\u5bb9\u65f6\u91cd\u5206\u5e03\u8fdb\u5ea6\u67e5\u8be2rebalancing_status<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[88],"class_list":{"0":"post-7872","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-88"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7872","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=7872"}],"version-history":[{"count":20,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7872\/revisions"}],"predecessor-version":[{"id":9533,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7872\/revisions\/9533"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=7872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=7872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=7872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
|