Check upgrade results

After a cluster upgrade, you must check the cluster status to make sure that the upgrade succeeds.

Procedure

1. Log on to OceanBase Database.

   [admin@xxx /home/admin]
   $obclient -h10.10.10.1 -P2881 -uroot@sys -p
   Enter password:
   Welcome to the OceanBase.  Commands end with ; or \g.
   Your OceanBase connection id is 3221848076
   Server version: OceanBase 4.1.0.0 (r100000682023020119-c760cbb1023d73a2647f28add283646b1569418f) (Built Feb  1 2023 20:07:36)
   
   Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   obclient [(none)]>
   

2. View the current version.

   obclient [(none)]> SELECT version();
   +---------------------------+
   | version()                 |
   +---------------------------+
   | 5.7.25-OceanBase-v4.1.0.0 |
   +---------------------------+
   1 row in set
   

3. View the original parameter values.

   obclient [(none)]> SELECT SVR_IP,ZONE,NAME,VALUE FROM OCEANBASE.GV$OB_PARAMETERS WHERE NAME IN ("server_permanent_offline_time", "enable_rebalance", "enable_rereplication");
   +------------+-------+-------------------------------+-------+
   | SVR_IP     | ZONE  | NAME                          | VALUE |
   +------------+-------+-------------------------------+-------+
   | 10.10.10.1 | zone2 | enable_rebalance              | True  |
   | 10.10.10.1 | zone2 | enable_rereplication          | True  |
   | 10.10.10.1 | zone2 | server_permanent_offline_time | 3600s |
   | 10.10.10.2 | zone1 | enable_rebalance              | True  |
   | 10.10.10.2 | zone1 | enable_rereplication          | True  |
   | 10.10.10.2 | zone1 | server_permanent_offline_time | 3600s |
   | 10.10.10.3 | zone3 | enable_rebalance              | True  |
   | 10.10.10.3 | zone3 | enable_rereplication          | True  |
   | 10.10.10.3 | zone3 | server_permanent_offline_time | 3600s |
   +------------+-------+-------------------------------+-------+
   9 rows in set
   

More information

Overview