View OBServer node status

You can view the status of an OBServer node by running a command or in the OceanBase Cloud Platform (OCP) console.

View OBServer node status by running a command

You can view OBServer node status in the __all_server table.

1. Log on to the sys tenant as the root user.

2. Access the database named oceanbase.

   obclient> USE oceanbase
   

3. Execute the following statement to view OBServer node status.

   The __all_server table identifies OBServer node status by using the stop_time and status fields.

   • When the value of stop_time is 0, the OBServer node is in the started state. When the value of stop_time is not 0, the OBServer node is in the stopped state. In this case, the value of stop_time is the timestamp when the OBServer node was stopped.

   • Valid values of status:

     • active: indicates that the OBServer node is operating properly.

     • inactive: indicates that the OBServer node is offline.

     • deleting: indicates that the OBServer node is being deleted.

   Here is an example:

   obclient> SELECT stop_time,status FROM __all_server;
   +-----------+--------+
   | stop_time | status |
   +-----------+--------+
   |         0 | active |
   +-----------+--------+
   1 row in set
   

View OBServer node status in the OCP console

1. Log on to the OCP console.

   The Clusters page automatically appears.

2. In the Clusters list, find the target cluster and click its name.

3. In the OBServers area on the Overview page, view the status of the OBServer node in the cluster.