GBase 8a MPP基础 gcadmin 查看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 showdistribution

                                 Distribution ID: 1 | State: new | Total segment num: 6

             Primary Segment Node IP                   Segment ID                 Duplicate Segment node IP
========================================================================================================================
|                 192.168.3.136                  |         1          |                 192.168.3.137                  |
------------------------------------------------------------------------------------------------------------------------
|                 192.168.3.137                  |         2          |                 192.168.3.138                  |
------------------------------------------------------------------------------------------------------------------------
|                 192.168.3.138                  |         3          |                 192.168.3.136                  |
------------------------------------------------------------------------------------------------------------------------
|                 192.168.3.136                  |         4          |                 192.168.3.138                  |
------------------------------------------------------------------------------------------------------------------------
|                 192.168.3.137                  |         5          |                 192.168.3.136                  |
------------------------------------------------------------------------------------------------------------------------
|                 192.168.3.138                  |         6          |                 192.168.3.137                  |
========================================================================================================================

基于节点查看distribution

[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                    |
====================================================================================================================================

xml形式查看distribution

[gbase@localhost gcinstall]$ gcadmin showdistribution f
<?xml version='1.0' encoding="utf-8"?>
<distributions>

    <distribution>
        <distribution_id>1</distribution_id>
        <distribution_state>new</distribution_state>
        <total_segment_num>6</total_segment_num>

        <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培训中心
• 墨天轮社区

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