oceanbase.CDB_OB_ACCESS_POINT

Overview

Displays the server list for all tenant portals. In network-based physical standby database scenarios, it is primarily used to obtain the IP address and SQL port number of the OBServer node hosting the replica of the primary tenant.

Columns

Sample query

Query the server list of the primary tenant primary_tenant1 in the sys tenant.

obclient [oceanbase]> SELECT SVR_IP, SQL_PORT FROM oceanbase.CDB_OB_ACCESS_POINT WHERE TENANT_NAME = 'primary_tenant1';

The query result is as follows:

+----------------+----------+
| SVR_IP         | SQL_PORT |
+----------------+----------+
| xxx.xxx.xxx.20 |    17860 |
+----------------+----------+
1 row in set

References

For more information about network-based physical standby databases, see Physical standby database.