查看集群信息 | OceanBase 文档中心

查看集群信息

更新时间：2026-05-29 18:00:34

OceanBase 集群架构包括集群信息、可用区(Zone)、节点等，可以通过命令行查看集群视图或 OCP 管理平台来查看，下面分别对这两种方式进行介绍。

通过命令行查看集群信息

使用 root 用户登录数据库的 sys 租户。

[root@xxxx ~]# obclient -h10.10.10.1 -P2881 -uroot@sys -p -A
Enter password:
Welcome to the OceanBase monitor.  Commands end with ; or \g.
Your OceanBase connection id is 3221487637

进入 oceanbase 数据库。

obclient> use oceanbase;
Database changed

通过视图查看集群相关信息。

通过视图 v$ob_cluster 查看集群 id、集群名字和创建时间等信息。

obclient> SELECT * FROM v$ob_cluster\G
*************************** 1. row ***************************
                cluster_id: 14
              cluster_name: test3232
                   created: 2022-09-08 14:43:27.254167
              cluster_role: PRIMARY
            cluster_status: VALID
               switchover#: 0
         switchover_status: NOT ALLOWED
           switchover_info: NONE SYNCED STANDBY CLUSTER
               current_scn: 1662620251109247
standby_became_primary_scn: 0
        primary_cluster_id: NULL
           protection_mode: MAXIMUM PERFORMANCE
          protection_level: MAXIMUM PERFORMANCE
    redo_transport_options: ASYNC NET_TIMEOUT = 30000000
1 row in set

通过视图 __all_zone 查看集群中所有的 Zone 信息。

obclient> SELECT * FROM __all_zone WHERE name='idc';
+----------------------------+----------------------------+-------+------+-------+------+
| gmt_create                 | gmt_modified               | zone  | name | value | info |
+----------------------------+----------------------------+-------+------+-------+------+
| 2022-09-08 14:43:39.940623 | 2022-09-08 14:44:04.161923 | zone1 | idc  |     0 | HZ0  |
| 2022-09-08 14:43:39.942688 | 2022-09-08 14:44:04.169328 | zone2 | idc  |     0 | HZ0  |
| 2022-09-08 14:43:39.943735 | 2022-09-08 14:44:04.175624 | zone3 | idc  |     0 | HZ0  |
+----------------------------+----------------------------+-------+------+-------+------+
3 rows in set

字段说明：

字段名称	描述
gmt_create	创建时间
gmt_modified	更新时间
zone	zone 名称
name	信息名称
value	信息值
info	信息值字符串表示

通过查看 __all_server 视图，可以了解集群中所有的节点的 ip，对外提供的服务端口，内部通信端口，所属可用区，状态等信息。

obclient> SELECT id,svr_ip,svr_port,zone,inner_port,with_rootserver,status,start_service_time,last_offline_time
      FROM  __all_server;
+----+----------------+----------+-------+------------+-----------------+--------+--------------------+-------------------+
| id | svr_ip         | svr_port | zone  | inner_port | with_rootserver | status | start_service_time | last_offline_time |
+----+----------------+----------+-------+------------+-----------------+--------+--------------------+-------------------+
|  1 | 10.10.10.1 |     2882 | zone3 |       2881 |               1 | active |   1662619523361997 |                 0 |
|  2 | 10.10.10.2 |     2882 | zone2 |       2881 |               0 | active |   1662619523371177 |                 0 |
|  3 | 10.10.10.3 |     2882 | zone1 |       2881 |               0 | active |   1662619523366233 |                 0 |
+----+----------------+----------+-------+------------+-----------------+--------+--------------------+-------------------+
3 rows in set

字段说明：

字段名称	描述
id	服务器 ID
svr_ip	IP 地址
svr_port	端口
zone	zone 名称
inner_port	sql 执行端口
with_rootserver	是否RS 所在服务器
status	observer 状态。有以下取值： active：server 运行正常。 inactive：server 异常。 deleting：delete server 进行中。
start_service_time	开始服务的时间
last_offline_time	最近下线时间

通过 __all_virtual_server_stat 查看集群资源使用情况。

obclient> SELECT
    zone,
    concat(svr_ip, ':', svr_port) observer,
    cpu_capacity,
    cpu_total,
    cpu_assigned,
    cpu_assigned_percent,
    mem_capacity,
    mem_total,
    mem_assigned,
    mem_assigned_percent,
    unit_Num,
    round(`load`, 2) `load`,
    round(cpu_weight, 2) cpu_weight,
    round(memory_weight, 2) mem_weight,
    leader_count
    FROM __all_virtual_server_stat
    ORDER BY zone,svr_ip;
+-------+---------------------+--------------+-----------+--------------+----------------------+--------------+-------------+--------------+----------------------+----------+------+------------+------------+--------------+
| zone  | observer            | cpu_capacity | cpu_total | cpu_assigned | cpu_assigned_percent | mem_capacity | mem_total   | mem_assigned | mem_assigned_percent | unit_Num | load | cpu_weight | mem_weight | leader_count |
+-------+---------------------+--------------+-----------+--------------+----------------------+--------------+-------------+--------------+----------------------+----------+------+------------+------------+--------------+
| zone1 | 10.10.10.1:2882 |           62 |        62 |          5.5 |                    8 |  53687091200 | 53687091200 |  25769803776 |                   48 |        3 | 0.42 |       0.16 |       0.84 |         1585 |
| zone2 | 10.10.10.2:2882 |           62 |        62 |          5.5 |                    8 |  53687091200 | 53687091200 |  25769803776 |                   48 |        3 | 0.42 |       0.16 |       0.84 |            0 |
| zone3 | 10.10.10.3:2882 |           62 |        62 |          5.5 |                    8 |  53687091200 | 53687091200 |  25769803776 |                   48 |        3 | 0.42 |       0.16 |       0.84 |            0 |
+-------+---------------------+--------------+-----------+--------------+----------------------+--------------+-------------+--------------+----------------------+----------+------+------------+------------+--------------+
3 rows in set