Query details about an OBProxy cluster|V4.3.2| docs|Distributed Database

Query details about an OBProxy cluster

Last Updated：2024-11-06 03:13:28 Updated

Description

You can call this operation to query details about an OBProxy cluster.

Call description

Prerequisites

You have passed the authentication for the OceanBase Cloud Platform (OCP) application service.

Request path

GET /api/v2/obproxy/clusters/{id}

Request parameters

Parameter	Type	Required	Example value	Description
id	Long	Yes	1	The ID of the OBProxy cluster.

Response parameters

Basic data structure

Parameter	Type	Description
data	Object	The information about the asynchronous task. For more information, see Task return structure.
successful	Boolean	Indicates whether the request was successful.
timestamp	Datetime	The timestamp when the server completed the request.
duration	Integer	The amount of time taken by the server to process the request, in milliseconds.
status	Integer	The HTTP status code.
traceId	String	The trace ID of the request. This trace ID is used for troubleshooting.
server	String	The address of the application server that responded to the request.

Data structure of obproxyCluster

Parameter	Type	Description
id	Long	The ID of the OBProxy cluster.
name	String	The name of the OBProxy cluster.
parameterVersion	Long	The parameter version of the OBProxy cluster.
creatorId	Long	The ID of the user that created the OBProxy cluster.
creatorName	String	The name of the user that created the OBProxy cluster.
createTime	OffsetDateTime	The time when the OBProxy cluster was created.
updateTime	OffsetDateTime	The time when the OBProxy cluster was last modified.
configUrl	String	The ConfigUrl of the OBProxy cluster.
address	String	The access URL of the OBProxy cluster.
port	Integer	The access port number of the OBProxy cluster.
obLinks	Array	The information of connectable OceanBase clusters. For more information, see Data structure of ObLink.
versions	Array	The versions of OBProxies in the OBProxy cluster. The number of OBProxies is counted by version. For more information, see Data structure of VersionStatInfo.
topo	Array	The topology of OBProxies in the OBProxy cluster. The number of OBProxies is counted by IDC. For more information, see Data structure of IdcStatInfo.
obproxies	Array	The list of OBProxies in the OBProxy cluster. For more information, see Data structure of ObproxyServer.

Data structure of ObLink

Parameter	Type	Description
clusterId	Long	The ID of the cluster.
clusterName	String	The name of the cluster.
username	String	The username for connecting to the cluster.
status	String	The status of the cluster. Valid values: RUNNING UNAVAILABLE STOPPED CREATING TAKINGOVER DELETING MOVINGOUT RESTARTING STARTING STOPPING SWITCHOVER FAILOVER UPGRADING OPERATING ABANDONED
connections	-	This parameter is deprecated and will be removed from later versions. You can call a monitoring API to query the data of the `current_session_server` metric as needed.
obClusterId	Long	The ID of the OceanBase cluster.
clusterType	String	The type of the cluster. Valid values: PRIMARY STANDBY

Data structure of VersionStatInfo

Parameter	Type	Description
version	String	The version.
count	Long	The number of OBProxies in the cluster.

Data structure of IdcStatInfo

Parameter	Type	Description
idcName	String	The name of the IDC.
count	Long	The number of OBProxies in the IDC.

Data structure of ObproxyServer

Parameter	Type	Description
id	Long	The ID of the OBProxy server.
clusterId	Long	The ID of the OBProxy cluster to which the OBProxy belongs.
hostId	Long	The ID of the host to which the OBProxy belongs.
idcName	String	The name of the IDC to which the OBProxy belongs.
lastActiveTime	OffsetDateTime	The last active time.
parameterVersion	Long	The parameter version of the OBProxy.
ip	String	The IP address of the OBProxy.
sqlPort	Integer	The SQL port of the OBProxy.
exporterPort	Integer	The Exporter port of the OBProxy.
version	String	The version of the OBProxy.
status	String	The status of the OBProxy. Valid values: CREATING RUNNING RESTARTING UPGRADING REFRESHING DELETING UNAVAILABLE TAKINGOVER
operateStatus	String	The operating status of the OBProxy. Valid values: NORMAL OPERATING
architecture	String	The hardware architecture of the host.

Examples

Sample request

GET /api/v2/obproxy/clusters/1

Sample response

{
        "data": {
                "address": "xxx.xxx.xxx.xxx",
                "configUrl": "http://xxx.xxx.xxx.xxx:8080/services?Action=GetObProxyConfig&User_ID=alibaba&UID=admin&ObproxyClusterName=test",
                "createTime": "2021-09-01T16:52:56+08:00",
                "creatorId": 100,
                "creatorName": "admin",
                "id": 1,
                "name": "test",
                "obLinks": [],
                "obproxies": [{
                        "architecture": "x86_64",
                        "clusterId": 1,
                        "exporterPort": 2884,
                        "hostId": 2,
                        "id": 1,
                        "idcName": "am171",
                        "ip": "xxx.xxx.xxx.xxx",
                        "lastActiveTime": "2021-09-01T16:59:06+08:00",
                        "operateStatus": "NORMAL",
                        "parameterVersion": 3,
                        "sqlPort": 2883,
                        "status": "UNAVAILABLE",
                        "version ": "1.9.1.1-1919579"
                }],
                "parameterVersion": 3,
                "port": 2883,
                "topo": [{
                        "count": 1,
                        "idcName": "am171"
                }],
                "updateTime": "2021-09-01T16:59:14+08:00",
                "versions": [{
                        "count": 1,
                        "version ": "1.9.1.1-1919579"
                }],
                "workMode": "CONFIG_URL"
        },
        "duration": 9,
        "server": "a83ad33525",
        "status": 200,
        "successful": true,
        "timestamp": "2021-09-03T16:04:17.284+08:00",
        "traceId": "bed960d58baa47c7"
}