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 に実行が完了しました。