Overview
Displays the list of servers for the tenant entry of the current tenant. In network-based physical standby database scenarios, it is primarily used to obtain the IP address and SQL port number of the OBServer node where the replica of the primary tenant resides.
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 for tenants in 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.