Purpose
The oceanbase.CDB_OB_ACCESS_POINT view displays the list of servers for accessing the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant.
|
| TENANT_NAME | varchar(128) | NO | The name of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the server where the log stream replica resides. |
| SQL_PORT | bigint(20) | NO | The SQL port of the server where the log stream replica resides. |
Sample query
obclient [oceanbase]>select svr_ip, sql_port CDB_OB_ACCESS_POINT where TENANT_NAME = 'primary_tenant1';
+-------------+----------+
| svr_ip | sql_port |
+-------------+----------+
| xxx.xxx.xxx.20 | 17860 |
+-------------+----------+
1 row in set (0.06 sec)