<\/span><\/h3>\n\n\n\n2\u4e2avc\u90fd\u67091\u4e2a\u5e93\u53ebtestdb\uff0c\u6211\u4eec\u5728101\u7684\u96c6\u7fa4testdb\u5e93\u4e0a\uff0c\u5efa\u7acb\u4e86\u4e00\u4e2a\u8868 <\/p>\n\n\n\n
gbase> create table t_101_testdb_tt(id int);\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.08)\r\n\r\ngbase> show tables;\r\n+------------------+\r\n| Tables_in_testdb |\r\n+------------------+\r\n| t1 |\r\n| t2 |\r\n| t2_inc |\r\n| t3_inc |\r\n| t_101_testdb_tt |\r\n| t_inc |\r\n| t_p |\r\n| t_pid |\r\n| tidname |\r\n| tmp2 |\r\n| tmp3 |\r\n| tt |\r\n| tt2 |\r\n+------------------+\r\n13 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n\u5728102\u7684testdb\u5e93\u4e0b\uff0c\u4e5f\u5efa\u4e86\u4e00\u4e2a\u8868\u3002<\/p>\n\n\n\n
gbase> create table t_102_testdb_tt(id int);\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.09)\r\n\r\ngbase> show tables;\r\n+------------------+\r\n| Tables_in_testdb |\r\n+------------------+\r\n| t1 |\r\n| t2 |\r\n| t2_inc |\r\n| t3_inc |\r\n| t_102_testdb_tt |\r\n| t_inc |\r\n| t_pid |\r\n| tidname |\r\n| tmp2 |\r\n| tmp3 |\r\n| tt |\r\n| tt2 |\r\n+------------------+\r\n12 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5\u76ee\u6807<\/span><\/h2>\n\n\n\n\u5c06102\u96c6\u7fa4\u7684VC(\u4e5f\u5c31\u662f\u8ba1\u7b97\u8d44\u6e90\uff09\uff0c\u5408\u5e76\u5982101\u96c6\u7fa4\u96c6\u7fa4\u3002<\/p>\n\n\n\n
<\/span>\u5bfc\u5165\u524d\u8981\u6c42\u548c\u6ce8\u610f\u4e8b\u9879<\/span><\/h2>\n\n\n\n\u7531\u4e8e\u5c06\u5bfc\u51fa\u96c6\u7fa4\u7684VC\u52a0\u5165\u5230\u76ee\u6807\u96c6\u7fa4\uff0c\u6240\u4ee5vc\u7684\u540d\u5b57\u4e0d\u80fd\u548c\u73b0\u6709\u76ee\u6807\u96c6\u7fa4\u7684\u91cd\u590d\u3002\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u4fee\u6539vc\u540d\u5b57\u3002<\/p>\n\n\n\n
[gbase@localhost ~]$ gcadmin renamevc vcname000001 vcname000002\r\ngcadmin rename vc [vcname000001] to [vcname000002] successful\r\n\r\n[gbase@localhost ~]$ <\/code><\/pre>\n\n\n\n\u7531\u4e8e\u96c6\u7fa4\u7edf\u4e00\u6743\u9650\u7ba1\u7406\uff0c\u6240\u4ee5\u88ab\u5bfc\u5165\u96c6\u7fa4\u7684\u4e00\u4e9b\u7528\u6237\u4fe1\u606f\uff0c\u53ef\u80fd\u4f1a\u56e0\u4e3a\u91cd\u590d\u800c\u4e22\u5931\u3002 \u8bf7\u5bfc\u5165\u540e\uff0c\u8001\u96c6\u7fa4\u7528\u5230\u7684\u7528\u6237\u540d\u548c\u6743\u9650\u7b49\uff0c\u53ca\u65f6\u8c03\u6574\u3002<\/p>\n\n\n\n
<\/span>\u7f16\u5199\u914d\u7f6e\u6587\u4ef6<\/span><\/h2>\n\n\n\n<\/span>\u751f\u6210\u914d\u7f6e\u6587\u4ef6\u6837\u4f8b<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 ~]$ gcadmin importvc e example_vc.xml\r\ngcadmin importvc vc ...\r\ngcadmin importvc vc generate example file:[example_vc.xml] successful<\/code><\/pre>\n\n\n\n<\/span>\u914d\u7f6e\u6587\u4ef6\u8bf4\u660e<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 ~]$ cat example_vc.xml\r\n<?xml version='1.0' encoding=\"utf-8\"?>\r\n<import_vc_parameter>\r\n\r\n <vc_name name=\"vc name to be imported\"\/>\r\n\r\n <coordinator_ip ip_list=\"the imported vc coordinator ip list, splitting by comma\"\/>\r\n <gcware_port port=\"the imported vc coordinator gcware client port, default config is 5919\"\/>\r\n <coordinator_os_dba_user_name os_user_name=\"the imported cluster coordinator os dba user name\"\/>\r\n <coordinator_os_dba_password os_password=\"the imported cluster coordinator os dba user password, write \"\" if no password\"\/>\r\n\r\n <imported_vc_db_user_name db_user_name=\"the imported vc database user name\"\/>\r\n <imported_vc_db_password db_password=\"the imported vc database password, write \"\" if no password\"\/>\r\n\r\n <importing_os_dba_user_name os_user_name=\"the importing cluster coordinator os dba user name\"\/>\r\n <importing_os_dba_password os_password=\"the importing cluster coordinator os dba user password, write \"\" if no password\"\/>\r\n\r\n <importing_db_user_name db_user_name=\"the importing cluster database user name\"\/>\r\n <importing_db_password db_password=\"the importing cluster database password, write \"\" if no password\"\/>\r\n\r\n <import_vc_timeout timeout=\"import vc timeout, unit is minute\"\/><\/code><\/pre>\n\n\n\n\u4e2d\u6587\u89e3\u91ca\u4e00\u4e0b<\/p>\n\n\n\n
<?xml version='1.0' encoding=\"utf-8\"?>\r\n<import_vc_parameter>\r\n\r\n <vc_name name=\"\u88ab\u5bfc\u5165\u7684VC\u7684\u540d\u5b57\uff0c\u9ed8\u8ba4\u662fvcname000001\"\/>\r\n\r\n <coordinator_ip ip_list=\"\u88ab\u5bfc\u5165\u865a\u62df\u96c6\u7fa4gcluster\u8c03\u5ea6\u8282\u70b9IP\u5217\u8868\uff0c\u9017\u53f7\u5206\u5272\"\/>\r\n <gcware_port port=\"\u88ab\u5bfc\u5165\u96c6\u7fa4gcware\u5ba2\u6237\u90fd\u7684\u7aef\u53e3\uff0c\u9ed8\u8ba4\u662f5919\"\/>\r\n <coordinator_os_dba_user_name os_user_name=\"\u88ab\u5bfc\u5165\u96c6\u7fa4\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u7684\u7528\u6237\u540d\"\/>\r\n <coordinator_os_dba_password os_password=\"\u88ab\u5bfc\u5165\u96c6\u7fa4\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u7684\u5bc6\u7801\uff0c\u65e0\u5bc6\u7801\u7684\u8bdd\u8fd9\u91cc\u4fdd\u6301\u7a7a\u4e32\u5c31\u884c\"\/>\r\n\r\n <imported_vc_db_user_name db_user_name=\"\u88ab\u5bfc\u5165\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u7528\u6237\u540d\"\/>\r\n <imported_vc_db_password db_password=\"\u88ab\u5bfc\u5165\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u5bc6\u7801\uff0c\u65e0\u5bc6\u7801\u4fdd\u6301\u7a7a\u4e32\"\/>\r\n\r\n <importing_os_dba_user_name os_user_name=\"\u5f53\u524d\u6267\u884c\u5bfc\u5165\u64cd\u4f5c\u7684\u76ee\u6807\u96c6\u7fa4\u7684\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\u540d\"\/>\r\n <importing_os_dba_password os_password=\"\u5f53\u524d\u6267\u884c\u5bfc\u5165\u64cd\u4f5c\u7684\u76ee\u6807\u96c6\u7fa4\u7684\u64cd\u4f5c\u7cfb\u7edf\u5bc6\u7801\uff0c\u65e0\u5bc6\u7801\u4fdd\u6301\u7a7a\u4e32\"\/>\r\n\r\n <importing_db_user_name db_user_name=\"\u5f53\u524d\u6267\u884c\u5bfc\u5165\u64cd\u4f5c\u7684\u76ee\u6807\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u7528\u6237\u540d\"\/>\r\n <importing_db_password db_password=\"\u5f53\u524d\u6267\u884c\u5bfc\u5165\u64cd\u4f5c\u7684\u76ee\u6807\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u5bc6\u7801\uff0c\u65e0\u5bc6\u7801\u4fdd\u6301\u7a7a\u4e32\"\/>\r\n\r\n <import_vc_timeout timeout=\"\u8d85\u65f6\u65f6\u95f4\uff0c\u5355\u4f4d\u662f\u5206\u949f\"\/><\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u540e\u7684\u914d\u7f6e\u6587\u4ef6<\/span><\/h3>\n\n\n\n<?xml version='1.0' encoding=\"utf-8\"?>\r\n<import_vc_parameter>\r\n\r\n <vc_name name=\"vcname000002\"\/>\r\n\r\n <coordinator_ip ip_list=\"10.0.2.102\"\/>\r\n <gcware_port port=\"5919\"\/>\r\n <coordinator_os_dba_user_name os_user_name=\"gbase\"\/>\r\n <coordinator_os_dba_password os_password=\"gbase1234\"\/>\r\n\r\n <imported_vc_db_user_name db_user_name=\"root\"\/>\r\n <imported_vc_db_password db_password=\"\"\/>\r\n\r\n <importing_os_dba_user_name os_user_name=\"gbase\"\/>\r\n <importing_os_dba_password os_password=\"gbase1234\"\/>\r\n\r\n <importing_db_user_name db_user_name=\"root\"\/>\r\n <importing_db_password db_password=\"\"\/>\r\n\r\n <import_vc_timeout timeout=\"15\"\/>\r\n\r\n<\/import_vc_parameter>\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5bfc\u5165\u96c6\u7fa4\u64cd\u4f5c<\/span><\/h2>\n\n\n\n\u5bfc\u5165\u5f88\u987a\u5229\uff0c\u91cc\u9762\u7684\u7ec6\u8282\u5c31\u4e0d\u5c55\u5f00\u4e86\u3002<\/p>\n\n\n\n
[gbase@gbase_rh7_001 ~]$ gcadmin importvc example_vc.xml\r\ngcadmin importvc vc ...\r\ngcadmin importvc vc parse config file\r\ngcadmin importvc vc [vcname000002] check parameters\r\ngcadmin importvc vc [vcname000002] has 1 distribution\r\nget importing cluster coordinator information and check os password\r\nclear importing and imported cluster coordinator nodes\r\ndrop temporary database\r\ngcadmin importvc disable vc [vcname000002] resource plan\r\ngcadmin importvc vc [vcname000002] switch to readonly mode\r\ngcadmin importvc vc [vcname000002] wait write process\r\ngcadmin importvc create importvc directory at all coordinator nodes\r\ngcadmin importvc get vc [vcname000002] databases and tables information, may be consume some times, please wait a moment ...\r\ngcadmin importvc get vc [vcname000002] information\r\ngcadmin importvc switch importing cluster every vc mode to readonly\r\ngcadmin importvc write vc [vcname000002] information to current cluster\r\ngcadmin importvc get vc [vcname000002] nodedatamap\r\ngcadmin importvc insert nodedatamap, may be consume some times, please wait a moment ...\r\ngcadmin importvc create gclusterdb\r\ngcadmin importvc [vcname000002] backup table id, may be consume some times, please wait a moment ...\r\ngcadmin importvc [vcname000002] backup table id done\r\ngcadmin importvc [vcname000002] modify table id, may be consume some times, please wait a moment ...\r\ngcadmin importvc [vcname000002] modify table id done\r\ngcadmin importvc [vcname000002] build metadata packet, may be consume some times, please wait a moment ...\r\ngcadmin importvc [vcname000002] build metadata packet done\r\ngcadmin importvc [vcname000002] copy metadata packet\r\ngcadmin importvc [vcname000002] copy metadata packet done\r\ngcadmin importvc [vcname000002] extract metadata packet\r\ngcadmin importvc [vcname000002] extract metadata packet done\r\n\r\ngcadmin importvc remove vc [vcname000002] from coordinator 10.0.2.102\r\ngcadmin importvc restore importing cluster every vc mode\r\n\r\ngcadmin import vc [vcname000002] successful\r\n[gbase@gbase_rh7_001 ~]$<\/code><\/pre>\n\n\n\n<\/span>\u5bfc\u5165\u540e\u7684\u6548\u679c<\/span><\/h2>\n\n\n\n<\/span>\u96c6\u7fa4gcadmin\u8f93\u51fa<\/span><\/h3>\n\n\n\n\u53ef\u4ee5\u770b\u5230\u8c03\u5ea6\u8282\u70b9\u4f9d\u7136\u662f101\uff1b\u865a\u62df\u96c6\u7fa4\u51fa\u73b0\u4e86\uff0c\u67092\u4e2a\u3002<\/p>\n\n\n\n
[gbase@gbase_rh7_001 ~]$ gcadmin\r\nCLUSTER STATE: ACTIVE\r\n\r\n=============================================================\r\n| GBASE COORDINATOR CLUSTER INFORMATION |\r\n=============================================================\r\n| NodeName | IpAddress | gcware | gcluster | DataState |\r\n-------------------------------------------------------------\r\n| coordinator1 | 10.0.2.101 | OPEN | OPEN | 0 |\r\n-------------------------------------------------------------\r\n=============================================\r\n| GBASE VIRTUAL CLUSTER INFORMATION |\r\n=============================================\r\n| VcName | DistributionId | comment |\r\n---------------------------------------------\r\n| vcname000001 | 8 | |\r\n---------------------------------------------\r\n| vcname000002 | 9 | |\r\n---------------------------------------------\r\n\r\n2 virtual cluster: vcname000001, vcname000002\r\n1 coordinator node\r\n0 free data node\r\n\r\n[gbase@gbase_rh7_001 ~]$<\/code><\/pre>\n\n\n\n