GBase 8c数据库基本操作详解

1 集群状态监控

使用MONITOR可以分别监控集群gtm、Coordinator、Datanode、DCS节点状态或对集群全部节点状态进行监控。语法：

gha_ctl MONITOR all/gtm/coordinator/datanode/dcs -l dcslist

l dcslist为DCS地址，一般情况下可以只列出一个节点地址，其他节点会自动同步消息。为了保证高可用，也可以列出所有节点地址；

具体操作命令如下：

$ /home/gbase/deploy/bin/gha_ctl monitor all -l http://192.168.142.211:2379,http://192.168.142.212:2379,http://192.168.142.213:2379

返回全部运行中为成功：

{

    "cluster":"gbase8c",

    "gtm":[

        {

            "host":"192.168.142.210",

            "port":"6666",

            "restPort":"8008",

            "name":"gtm1",

            "workDir":"/home/gbase/data/gtm",

            "state":"running",

            "role":"master"

        }

    ],

    "coordinator":[

        {

            "host":"192.168.142.211",

            "port":"5432",

            "restPort":"8009",

            "name":"cn1",

            "workDir":"/home/gbase/data/coord",

            "state":"running"

        },

        {

            "host":"192.168.142.212",

            "port":"5432",

            "restPort":"8009",

            "name":"cn2",

            "workDir":"/home/gbase/data/coord",

            "state":"running"

        },

        {

            "host":"192.168.142.213",

            "port":"5432",

            "restPort":"8009",

            "name":"cn3",

            "workDir":"/home/gbase/data/coord",

            "state":"running"

        }

    ],

    "datanode":{

        "dn1":[

            {

                "host":"192.168.142.211",

                "port":"5433",

                "restPort":"8011",

                "name":"dn1_1",

                "workDir":"/home/gbase/data/datanode",

                "role":"master",

                "state":"running"

            }

        ],

        "dn2":[

            {

                "host":"192.168.142.212",

                "port":"5433",

                "restPort":"8011",

                "name":"dn2_1",

                "workDir":"/home/gbase/data/datanode",

                "role":"master",

                "state":"running"

            }

        ],

        "dn3":[

            {

                "host":"192.168.142.213",

                "port":"5433",

                "restPort":"8011",

                "name":"dn3_1",

                "workDir":"/home/gbase/data/datanode",

                "role":"master",

                "state":"running"

            }

        ]

    },

    "dcs":{

        "cluster_state":"healthy",

        "members":[

            {

                "url":"http://192.168.142.213:2379",

                "id":"62f9a805ba818264",

                "name":"node_2",

                "state":"healthy",

                "isLeader":false

            },

            {

                "url":"http://192.168.142.211:2379",

                "id":"8ea592db62fb7d92",

                "name":"node_0",

                "state":"healthy",

                "isLeader":true

            },

            {

                "url":"http://192.168.142.212:2379",

                "id":"fbc0fc018ba512fa",

                "name":"node_1",

                "state":"healthy",

                "isLeader":false

            }

        ]

    }

}

该集群中已配置1个GTM节点，3个Coordinator节点及3个Datanode节点（Datanode节点无备机）。