V$OB_LS_LOG_TRANSPORT_STAT

Overview

The V$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of each log stream (LS) pushing logs to a standby database at the current node of a tenant in strong sync mode. To query this view, you must log in as the primary tenant (or the sys tenant of the cluster where the primary tenant resides).

Columns

Sample query

In the sys tenant of the cluster where the primary tenant resides, query the transmission status of logs pushed by each log stream (LS) from the current node of the primary tenant with tenant ID 1002 to the standby tenant.

1. Check the synchronization mode of the primary tenant LS.

   obclient(root@sys)[oceanbase]> SELECT TENANT_ID, LS_ID, ROLE, SYNC_MODE FROM oceanbase.V$OB_LOG_STAT WHERE TENANT_ID = 1002 AND ROLE = 'LEADER';
   

   The query result is as follows:

   +-----------+-------+--------+-----------+
   | TENANT_ID | LS_ID | ROLE   | SYNC_MODE |
   +-----------+-------+--------+-----------+
   |      1002 |     1 | LEADER | SYNC      |
   |      1002 |  1001 | LEADER | SYNC      |
   +-----------+-------+--------+-----------+
   2 rows in set
   

   If the result is SYNC, it indicates that the current tenant's log stream synchronization mode is strong sync.

2. Query the transmission status of log pushing from each log stream on all nodes of the primary tenant to the standby tenant.

   obclient(root@sys)[oceanbase]> SELECT TENANT_ID, LS_ID, ROLE, ENABLED, 
       END_LSN, LAST_SENT_LSN, STANDBY_END_LSN, STANDBY_ADDR
       FROM oceanbase.V$OB_LS_LOG_TRANSPORT_STAT WHERE TENANT_ID = 1002 AND ROLE = 'LEADER';
   

   The query result is as follows:

   +-----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | TENANT_ID | LS_ID | ROLE   | ENABLED | END_LSN   | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR      |
   +-----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   |      1002 |     1 | LEADER |       1 | 304766784 |     304766784 |       304766784 | 6.xx.xxx.160:2882 |
   |      1002 |  1001 | LEADER |       1 | 200961942 |     200961942 |       200961942 | 6.xx.xxx.160:2882 |
   +-----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   2 rows in set