Note
This view is available starting with V4.2.0.
Overview
Displays the list of servers for the tenant entry of the current tenant. In a network-based physical standby database scenario, it is mainly used to obtain the IP address and SQL port number of the OBServer node where the replica of the primary tenant is located.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID.
|
| TENANT_NAME | varchar(128) | NO | Tenant Name |
| SVR_IP | varchar(46) | NO | IP Address of the Server Where the System Log Stream Replica Resides |
| SQL_PORT | bigint(20) | NO | SQL Port of the System Log Stream Replica |
Sample query
Query the server list of the current 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 network-based physical standby databases, see Physical standby database.