查看 Locality 变更记录

本文介绍如何通过视图 DBA_OB_TENANT_JOBS 查看 Locality 的变更记录。

有关视图 DBA_OB_TENANT_JOBS 的详细介绍，参见 DBA_OB_TENANT_JOBS 。

操作步骤

1. 使用 root 用户登录到集群的 sys 租户。

   obclient -h172.30.xxx.xxx -P2883 -uroot@sys#obdemo -pxxxx -A

2. 进入 oceanbase 数据库。

   obclient>use oceanbase;

3. 查看 Locality 变更任务。

   • 查看 Locality 变更任务的执行状态。

        obclient> SELECT * FROM oceanbase.DBA_OB_TENANT_JOBS WHERE JOB_TYPE = 'ALTER_TENANT_LOCALITY';
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
        | JOB_ID | JOB_TYPE              | JOB_STATUS | RESULT_CODE | PROGRESS | START_TIME                 | MODIFY_TIME                | TENANT_ID | SQL_TEXT                                                                     | EXTRA_INFO                                  | RS_SVR_IP      | RS_SVR_PORT |
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
        |      1 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-05 19:33:46.730319 | 2023-01-05 19:33:46.920111 |      1002 | ALTER TENANT mysql001 locality='FULL{1}@zone1, FULL{1}@zone2'                | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | xx.xx.xx.206 |        2882 |
        |      2 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-05 19:38:38.416011 | 2023-01-05 19:40:11.019113 |      1002 | ALTER TENANT mysql001 locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3' | FULL{1}@zone1, FULL{1}@zone2                | xx.xx.xx.207 |        2882 |
        |      3 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-06 14:37:01.569689 | 2023-01-06 14:37:01.726090 |      1002 | ALTER TENANT mysql001 locality="FULL{1}@zone1, FULL{1}@zone2"                | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | xx.xx.xx.208 |        2882 |
        |      4 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-06 14:39:56.377599 | 2023-01-06 14:40:57.874498 |      1002 | ALTER TENANT mysql001 locality="FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3" | FULL{1}@zone1, FULL{1}@zone2                | xx.xx.xx.209 |        2882 |
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
     

   • 查看某一租户上的历史 Locality 变更记录。

        obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANT_JOBS WHERE JOB_TYPE = 'ALTER_TENANT_LOCALITY' AND tenant_id = 1002 ORDER BY START_TIME DESC LIMIT 10;
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
        | JOB_ID | JOB_TYPE              | JOB_STATUS | RESULT_CODE | PROGRESS | START_TIME                 | MODIFY_TIME                | TENANT_ID | SQL_TEXT                                                                     | EXTRA_INFO                                  | RS_SVR_IP      | RS_SVR_PORT |
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
        |      4 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-06 14:39:56.377599 | 2023-01-06 14:40:57.874498 |      1002 | ALTER TENANT mysql001 locality="FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3" | FULL{1}@zone1, FULL{1}@zone2                | xx.xx.xx.209 |        2882 |
        |      3 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-06 14:37:01.569689 | 2023-01-06 14:37:01.726090 |      1002 | ALTER TENANT mysql001 locality="FULL{1}@zone1, FULL{1}@zone2"                | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | xx.xx.xx.206 |        2882 |
        |      2 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-05 19:38:38.416011 | 2023-01-05 19:40:11.019113 |      1002 | ALTER TENANT mysql001 locality='FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3' | FULL{1}@zone1, FULL{1}@zone2                | xx.xx.xx.207 |        2882 |
        |      1 | ALTER_TENANT_LOCALITY | SUCCESS    |           0 |      100 | 2023-01-05 19:33:46.730319 | 2023-01-05 19:33:46.920111 |      1002 | ALTER TENANT mysql001 locality='FULL{1}@zone1, FULL{1}@zone2'                | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | xx.xx.xx.208 |        2882 |
        +--------+-----------------------+------------+-------------+----------+----------------------------+----------------------------+-----------+------------------------------------------------------------------------------+---------------------------------------------+----------------+-------------+
     

     查询结果解释说明：

     以 JOB_ID = 4 为例，租户 tenant_id = 1002 在 2023-01-06 14:39:56.377599 创建了修改租户 locality 由 FULL{1}@zone1, FULL{1}@zone2 变更为 FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 的操作，并在 2023-01-06 14:40:57.874498 执行完成。