getCloudMysqlInstanceList
- Print
- PDF
getCloudMysqlInstanceList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Cloud DB for MySQL instance list can be viewed.
Requests
Request Parameters
Parameters | Type | Requirement status | Description | Restrictions |
---|---|---|---|---|
regionCode | String | N | Region code for which Cloud DB for MySQL instance exists - Can be obtained through getRegionList action - Default: choose the first region viewed through getRegionList | - |
zoneCode | String | N | ZONE code - Can be obtained through getZoneList action | - |
vpcNo | String | N | VPC number - Can be obtained through getCloudMysqlTargetVpcList action | - |
subnetNo | String | N | Subnet number - Can be obtained through getCloudMysqlTargetSubnetList action | - |
cloudMysqlServiceName | String | N | Cloud DB for MySQL service name - Can be obtained through getCloudMysqlInstanceList action | - |
cloudMysqlInstanceNoList | List<String> | N | List of Cloud DB for MySQL instance numbers - Can be obtained through getCloudMysqlInstanceList action -<example> cloudMysqlInstanceNoList.1=1234&cloudMysqlInstanceNoList.2=2345 | - |
cloudMysqlServerName | String | N | Cloud DB for MySQL server name - Can be obtained through getCloudMysqlInstanceList action | - |
cloudMysqlServerInstanceNoList | List<String> | N | List of Cloud DB for MySQL server instance numbers - Can be obtained through getCloudMysqlInstanceList action -<example> cloudMysqlServerInstanceNoList.1=1234&cloudMysqlServerInstanceNoList.2=2345 | - |
generationCode | String | N | Server generation code - Can be obtained through getCloudMysqlInstanceList action - options: G2 | G3 | - |
pageNo | Integer | N | Page number of paged results - The results can be paged using pageNo and pageSize | min: 0 |
pageSize | Integer | N | Size of each page to be shown during paging - The results can be paged using pageNo and pageSize - Enter it every time you enter pageNo | min: 1 |
responseFormatType | String | N | Format type for the response results - options: xml | json - default: xml | - |
Responses
Response bodies
For response bodies, please refer to CloudMysqlInstanceList.
Examples
Request Examples
The following is an example of a request body.
GET {API_URL}/getCloudMysqlInstanceList
?regionCode=KR
&zoneCode=KR-1
&vpcNo=***83
&subnetNo=**91
&cloudMysqlServiceName=test-****
&cloudMysqlInstanceNoList.1=****890
&cloudMysqlServerName=test-****
&cloudMysqlServerInstanceNoList.1=****891
&generationCode=G2
&pageNo=0
&pageSize=10
Response examples
The following are examples of responses.
If the response shows that format type (responseFormatType) is json
{
"getCloudMysqlInstanceListResponse": {
"requestId": "1ae10c76-412d-4050-8911-42fa19a60a31",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMysqlInstanceList": {
"cloudMysqlInstance": {
"cloudMysqlInstanceNo": "****890",
"cloudMysqlServiceName": "test-****",
"cloudMysqlInstanceStatusName": "running",
"cloudMysqlInstanceStatus": {
"code": "CREAT",
"codeName": "CLOUD DATABASE(VPC) Created State"
},
"cloudMysqlInstanceOperation": {
"code": "NULL",
"codeName": "CLOUD DATABASE(VPC) Null OP"
},
"isHa": true,
"isMultiZone": true,
"generationCode": "G2",
"cloudMysqlServerInstanceList": {
"cloudMysqlServerInstance": [
{
"cloudMysqlServerInstanceNo": "****891",
"cloudMysqlServerName": "test-****-001-e04",
"cloudMysqlServerRole": {
"code": "M",
"codeName": "Master"
},
"cloudMysqlServerInstanceStatusName": "running",
"cloudMysqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMysqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"regionCode": "KR",
"zoneCode": "KR-1",
"vpcNo": "****83",
"subnetNo": "****91",
"dataStorageSize": 10737418240,
"cpuCount": 2,
"memorySize": 8589934592
},
{
"cloudMysqlServerInstanceNo": "****897",
"cloudMysqlServerName": "test-****-002-e05",
"cloudMysqlServerRole": {
"code": "H",
"codeName": "Standby Master"
},
"cloudMysqlServerInstanceStatusName": "running",
"cloudMysqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMysqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"regionCode": "KR",
"zoneCode": "KR-2",
"vpcNo": "****83",
"subnetNo": "****93",
"dataStorageSize": 10737418240,
"cpuCount": 2,
"memorySize": 8589934592
}
]
}
}
}
}
}
If the response shows that format type (responseFormatType) is xml
<getCloudMysqlInstanceListResponse>
<requestId>1ae10c76-412d-4050-8911-42fa19a60a31</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMysqlInstanceList>
<cloudMysqlInstance>
<cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
<cloudMysqlServiceName>test-****</cloudMysqlServiceName>
<cloudMysqlInstanceStatusName>running</cloudMysqlInstanceStatusName>
<cloudMysqlInstanceStatus>
<code>CREAT</code>
<codeName>CLOUD DATABASE(VPC) Created State</codeName>
</cloudMysqlInstanceStatus>
<cloudMysqlInstanceOperation>
<code>NULL</code>
<codeName>CLOUD DATABASE(VPC) Null OP</codeName>
</cloudMysqlInstanceOperation>
<isHa>true</isHa>
<isMultiZone>true</isMultiZone>
<generationCode>G2</generationCode>
<cloudMysqlServerInstanceList>
<cloudMysqlServerInstance>
<cloudMysqlServerInstanceNo>****891</cloudMysqlServerInstanceNo>
<cloudMysqlServerName>test-****-001-e04</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>M</code>
<codeName>Master</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>running</cloudMysqlServerInstanceStatusName>
<cloudMysqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMysqlServerInstanceStatus>
<cloudMysqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMysqlServerInstanceOperation>
<regionCode>KR</regionCode>
<zoneCode>KR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>10737418240</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
</cloudMysqlServerInstance>
<cloudMysqlServerInstance>
<cloudMysqlServerInstanceNo>****897</cloudMysqlServerInstanceNo>
<cloudMysqlServerName>test-****-002-e05</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>H</code>
<codeName>Standby Master</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>running</cloudMysqlServerInstanceStatusName>
<cloudMysqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMysqlServerInstanceStatus>
<cloudMysqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMysqlServerInstanceOperation>
<regionCode>KR</regionCode>
<zoneCode>KR-2</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****93</subnetNo>
<dataStorageSize>10737418240</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
</cloudMysqlServerInstance>
</cloudMysqlServerInstanceList>
</cloudMysqlInstance>
</cloudMysqlInstanceList>
</getCloudMysqlInstanceListResponse>
Was this article helpful?