GBase 8a MPP基础 gcadmin 导出指定ID的distribution

Server：CentOS Linux release 7.3.1611 (Core) （3.10.0-514.el7.x86_64）
GBase8a MPP Cluster：9.5.2.39-redhat7.3-x86_64
GBaseDataStudio：9.5.1.0_build2_Windows_x86_64

查看集群状态和distribution

[gbase@localhost gcinstall]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

================================================================
|            GBASE COORDINATOR CLUSTER INFORMATION             |
================================================================
|   NodeName   |   IpAddress   | gcware | gcluster | DataState |
----------------------------------------------------------------
| coordinator1 | 192.168.3.136 |  OPEN  |   OPEN   |     0     |
----------------------------------------------------------------
| coordinator2 | 192.168.3.137 |  OPEN  |   OPEN   |     0     |
----------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.3.136               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |              192.168.3.137               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |              192.168.3.138               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

[gbase@localhost gcinstall]$ gcadmin showdistribution node
                                      Distribution ID: 1 | State: new | Total segment num: 6

====================================================================================================================================
|  nodes   |             192.168.3.136             |             192.168.3.137             |             192.168.3.138             |
------------------------------------------------------------------------------------------------------------------------------------
| primary  |                  1                    |                  2                    |                  3                    |
| segments |                  4                    |                  5                    |                  6                    |
------------------------------------------------------------------------------------------------------------------------------------
|duplicate |                  3                    |                  1                    |                  2                    |
|segments 1|                  5                    |                  6                    |                  4                    |
====================================================================================================================================

gcadmin 导出 Distribution ID=1 的 distribution信息

[gbase@localhost gcinstall]$ gcadmin getdistribution 1 /opt/distribution_info.xml
gcadmin getdistribution 1 /opt/distribution_info.xml ...

get segments information
write segments information to file [/opt/distribution_info.xml]

gcadmin getdistribution information successful
[gbase@localhost gcinstall]$ cat /opt/distribution_info.xml 
<?xml version='1.0' encoding="utf-8"?>
<distributions>
    <distribution>
        <segments>
            <segment>
                <primarynode ip="192.168.3.136"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.137"/>
                </duplicatenodes>
            </segment>

            <segment>
                <primarynode ip="192.168.3.137"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.138"/>
                </duplicatenodes>
            </segment>

            <segment>
                <primarynode ip="192.168.3.138"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.136"/>
                </duplicatenodes>
            </segment>

            <segment>
                <primarynode ip="192.168.3.136"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.138"/>
                </duplicatenodes>
            </segment>

            <segment>
                <primarynode ip="192.168.3.137"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.136"/>
                </duplicatenodes>
            </segment>

            <segment>
                <primarynode ip="192.168.3.138"/>

                <duplicatenodes>
                    <duplicatenode ip="192.168.3.137"/>
                </duplicatenodes>
            </segment>
        </segments>
    </distribution>
</distributions>
[gbase@localhost gcinstall]$ 

相关链接

• GBase培训中心
• 墨天轮社区

欢迎各位同学一起来交流学习心得！