Note
This view is available starting with V4.2.0.
Purpose
This view displays the list of Server nodes for the tenant access point. In the scenario of a physical standby database based on the network, this view is primarily used to obtain the IP address and SQL port number of the OBServer node in the primary tenant's replica.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID.
|
| TENANT_NAME | varchar(128) | NO | The tenant name. |
| SVR_IP | varchar(46) | NO | The IP address of the server node that hosts the system log stream replica. |
| SQL_PORT | bigint(20) | NO | The SQL port number of the server node that hosts the system log stream replica. |
Sample query
Query the list of Server nodes for the tenant access point in the user tenant.
obclient [oceanbase]> SELECT SVR_IP, SQL_PORT FROM oceanbase.DBA_OB_ACCESS_POINT;
The query result is as follows:
+----------------+----------+
| SVR_IP | SQL_PORT |
+----------------+----------+
| 172.xx.xxx.xxx | 2881 |
+----------------+----------+
1 row in set
References
For more information about physical standby databases based on the network, see Physical standby database.