如何监控GBase 8c数据库集群状态

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

语法：

gha_ctl MONITOR all/gtm/coordinator/datanode/dcs -l dcslist [-c cluster] [-H]

参数说明：

l [-c cluster]表示集群名称，为可选字段，缺省默认值gbase8c；

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

l [-H]集群状态结果将以表格形式展示；

具体操作命令如下：

$ /home/gbase/deploy/bin/gha_ctl monitor all -l http://10.0.7.17:2379,http://10.0.7.18:2379,http://10.0.7.19:2379 -H

返回全部运行中为成功：

+----+------+-----------+------+-----------------------+---------+--------+

| No | name |    host   | port |        workDir        |  state  |  role  |

+----+------+-----------+------+-----------------------+---------+--------+

| 0  | gtm1 | 10.0.7.16 | 6666 | /home/gbase/data/gtm1 | running | master |

+----+------+-----------+------+-----------------------+---------+--------+

+----+------+-----------+------+------------------------+---------+

| No | name |    host   | port |        workDir         |  state  |

+----+------+-----------+------+------------------------+---------+

| 0  | cn1  | 10.0.7.17 | 5432 | /home/gbase/data/coord | running |

| 1  | cn2  | 10.0.7.18 | 5432 | /home/gbase/data/coord | running |

| 2  | cn3  | 10.0.7.19 | 5432 | /home/gbase/data/coord | running |

+----+------+-----------+------+------------------------+---------+

+----+-------+-------+-----------+------+------------------------+---------+--------+

| No | group |  name |    host   | port |        workDir         |  state  |  role  |

+----+-------+-------+-----------+------+------------------------+---------+--------+

| 0  |  dn1  | dn1_1 | 10.0.7.17 | 5433 | /home/gbase/data/dn1_1 | running | master |

| 1  |  dn2  | dn2_1 | 10.0.7.18 | 5433 | /home/gbase/data/dn2_1 | running | master |

| 2  |  dn3  | dn3_1 | 10.0.7.19 | 5433 | /home/gbase/data/dn3_1 | running | master |

+----+-------+-------+-----------+------+------------------------+---------+--------+

+----+-----------------------+--------+---------+----------+

| No |          url          |  name  |  state  | isLeader |

+----+-----------------------+--------+---------+----------+

| 0  | http://10.0.7.17:2379 | node_0 | healthy |  False   |

| 1  | http://10.0.7.19:2379 | node_2 | healthy |  False   |

| 2  | http://10.0.7.18:2379 | node_1 | healthy |   True   |

+----+-----------------------+--------+---------+----------+

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