Get VPC CDB-MySQL server list
- Print
- PDF
Get VPC CDB-MySQL server list
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.
Get the list of servers that are visible in the Cloud Log Analytics service.
Get VPC CDB-MySQL server list
Get the list of CDB-MySQL server instances (VMs) in the VPC platform. Paging processing is available.
Request URL
GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mysql
Request headers
| Header name | Description |
|---|---|
| x-ncp-apigw-timestamp | It indicates the elapsed time in milliseconds since January 1, 1970 00:00:00 UTC Request is considered invalid if the timestamp differs from the current time by more than 5 minutes x-ncp-apigw-timestamp:{Timestamp} |
| x-ncp-apigw-api-key | Key value issued by API gatewayx-ncp-apigw-api-key:{API Gateway API Key} |
| x-ncp-iam-access-key | Value of access key ID issued in the NAVER Cloud Platform portalx-ncp-iam-access-key:{Account Access Key} |
| x-ncp-apigw-signature-v2 | Signature encrypted with the access key ID value and secret keyx-ncp-apigw-signature-v2:{API Gateway Signature} |
| Content-Type | Specify the request body content type as application/jsonContent-Type: application/json |
Request parameter
| Parameter | Type | Required | Description |
|---|---|---|---|
| pageNo | Integer | N | Page number Example: 1, 2 |
| pageSize | Integer | N | Page size Example: 10, 20 |
Request example
GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mysql?pageNo=1&pageSize=10
HOST: cloudloganalytics.apigw.ntruss.com
Content-Type: application/json
x-ncp-apigw-signature-v2: FJSBB4K3XnaGAvVe0Hzj3/2hfNWvgLHR1rQHW2Et2Rs=
x-ncp-apigw-timestamp: 1593848345548
x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo
curl -X GET "https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/mysql?pageNo=1&pageSize=10"
-H "accept: application/json"
-H "x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo"
-H "x-ncp-apigw-timestamp: 1593849262194"
-H "x-ncp-apigw-signature-v2: m/hJOfg92TqzOGyHJ++4vkimGT7un1/4+zLrLTvaVT4="
Response example
{
"code": 0,
"message": "The request has been successfully processed",
"result": {
"pageSize": 10,
"currentPage": 1,
"totalPage": 1,
"totalCount": 2,
"isPaged": true,
"dbServers": [
{
"standbyMasterServerName": null,
"dbServerName": "cla-test-001-1shh",
"databaseProductCode": null,
"db_svr_rank": 0,
"cloudDbServiceName": "clatest",
"dataStorageTypeCode": null,
"dataStorageSize": 10,
"dataStorageSizeStr": "10GB",
"dbInstanceNo": 0,
"memorySize": "8GB",
"dbStatusName": null,
"clusterStatusName": null,
"serverInstanceNo": 0,
"dbServerIpAddress": null,
"cpuCount": 2,
"roleCode": null,
"dbServerRoleCode": null,
"dbServerType": "[Standard] 2vCPU, 8GB Mem",
"usedDataStorageSize": 0,
"uuid": "0-cla-test-001-1shh",
"dbStatusNameValue": "creating",
"dbStatusNameColor": "yellow",
"dbServerRoleValue": "Master",
"zoneNo": null,
"zoneName": null
},
{
"standbyMasterServerName": null,
"dbServerName": "cla-test-002-1shi",
"databaseProductCode": null,
"db_svr_rank": 0,
"cloudDbServiceName": "clatest",
"dataStorageTypeCode": null,
"dataStorageSize": 10,
"dataStorageSizeStr": "10GB",
"dbInstanceNo": 0,
"memorySize": "8GB",
"dbStatusName": null,
"clusterStatusName": null,
"serverInstanceNo": 0,
"dbServerIpAddress": null,
"cpuCount": 2,
"roleCode": null,
"dbServerRoleCode": null,
"dbServerType": "[Standard] 2vCPU, 8GB Mem",
"usedDataStorageSize": 0,
"uuid": "0-cla-test-002-1shi",
"dbStatusNameValue": "creating",
"dbStatusNameColor": "yellow",
"dbServerRoleValue": "Standby Master",
"zoneNo": null,
"zoneName": null
}
]
}
}Was this article helpful?