Overview
Displays the list of servers at the tenant entry for this 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 primary tenant's replica 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 list of entry servers for 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.