Note
This view is available starting with V4.2.0.
Purpose
This view displays the Server list of all tenants.
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 to which the system log stream replica belongs. |
| SQL_PORT | bigint(20) | NO | The SQL port of the Server to which the system log stream replica belongs. |
Sample query
Query the Server list of the primary_tenant1 tenant 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