Cloud DB for MySQL 서버 인스턴스를 삭제합니다.
명령어
명령어 구문은 다음과 같습니다.
ncloud vmysql deleteCloudMysqlServerInstance [regionCode FKR] [cloudMysqlServerInstanceNo] [output]
파라미터
파라미터에 대한 설명은 다음과 같습니다.
| 파라미터 | 타입 | 필수 여부 | 설명 | 제약 사항 |
|---|---|---|---|---|
| regionCode | String | N | Cloud DB for MySQL 인스턴스가 존재하는 리전 코드 - getRegionList 액션을 통해서 획득 가능 - default: getRegionList 조회 결과의 첫 번째 리전을 선택 |
- |
| cloudMysqlServerInstanceNo | String | Y | Cloud DB for MySQL 서버 인스턴스 번호 - Slave, Recovery 서버만 삭제 가능 - getCloudMysqlInstanceList 액션을 통해 획득 가능 |
- |
| output | String | N | 응답 결과의 포맷 타입 - options: xml | json - default: json |
- |
응답
응답 데이터 타입
명령어 호출에 대한 응답 데이터 타입은 다음과 같습니다.
- CloudMysqlInstanceList 타입
| CloudMysqlInstanceList extends CommonResponse | 설명 |
|---|---|
| private Integer totalRows; | 조회된 목록의 총 개수 |
| private List<CloudMysqlInstance> cloudMysqlInstanceList = new ArrayList<>(); |
- CloudMysqlInstance 타입
| CloudMysqlInstance | 설명 |
|---|---|
| private String cloudMysqlInstanceNo; | Cloud DB for MySQL 인스턴스 번호 |
| private String cloudMysqlServiceName; | Cloud DB for MySQL 서비스 이름 |
| private String cloudMysqlInstanceStatusName; | Cloud DB for MySQL 인스턴스 상태 이름 - creating- deleted- deleting- pending- recovering- reinstalling- restarting- running- settingup- shuttingdown- stopped- upgrading- downgrading |
| private CommonCode cloudMysqlInstanceStatus; | Cloud DB for MySQL 인스턴스 상태 코드 - INIT (init)- CREAT (created)- DEL (deleted) |
| private CommonCode cloudMysqlInstanceOperation; | Cloud DB for MySQL 인스턴스 Operation 코드 - CREAT (create)- DEL (delete)- FO (failover)- NULL (no)- SETUP (setup)- UPGD (upgrade)- DWGD (downgrade)- BKP (backup) |
| private String cloudMysqlImageProductCode; | Cloud DB for MySQL 이미지 상품 코드 |
| private String engineVersion; | Cloud DB for MySQL 엔진 버전 |
| private CommonCode license; | Cloud DB for MySQL 라이선스 |
| private Integer cloudMysqlPort; | Cloud DB for MySQL 포트 |
| private Boolean isHa; | 고가용성 여부 |
| private Boolean isMultiZone; | 멀티존 여부 |
| private Boolean isBackup; | 백업 여부 |
| private Integer backupFileRetentionPeriod; | 백업 파일 보관 기간 |
| private String backupTime; | 백업 시간 |
| private String generationCode; | 서버 세대 코드 |
| private Date createDate; | 생성일자 |
| private List<String> accessControlGroupNoList; | ACG 번호 목록 |
| private List<String> cloudMysqlConfigList; | Cloud DB for MySQL Config 목록 |
| private List<CloudMysqlServerInstance> cloudMysqlServerInstanceList; | Cloud DB for MySQL 서버 인스턴스 목록 |
- CloudMysqlServerInstance 타입
| CloudMysqlServerInstance | 설명 |
|---|---|
| private String cloudMysqlServerInstanceNo; | Cloud DB for MySQL 서버 인스턴스 번호 |
| private String cloudMysqlServerName; | Cloud DB for MySQL 서버 이름 |
| private CommonCode cloudMysqlServerRole; | Cloud DB for MySQL 서버 역할 |
| private String cloudMysqlServerInstanceStatusName; | Cloud DB for MySQL 서버 인스턴스 상태 이름 - creating- deleted- deleting- downgrading- pending- recovering- reinstalling- restarting- running- settingup- shuttingdown- stopped- upgrading- downgrading |
| private CommonCode cloudMysqlServerInstanceStatus; | Cloud DB for MySQL 서버 인스턴스 상태 코드 - DEL (deleted)- PEND (pending)- RUN (running)- STOP (stopped)- FSTOP (failure stopped) |
| private CommonCode cloudMysqlServerInstanceOperation; | Cloud DB for MySQL 서버 인스턴스 Operation 코드 - NOOP (no operation)- CREAT (create)- START (start)- RSTRT (restart)- SETUP (setup)- STOP (stop)- FO (failover)- DEL (delete)- UPGD (upgrade)- DWGD (downgrade)- RISTL (서버 reinstall)- MIG (migration) |
| private String cloudMysqlProductCode; | Cloud DB for MySQL 상품 코드 |
| private String regionCode; | 리전 코드 |
| private String zoneCode; | ZONE 코드 |
| private String vpcNo; | VPC 번호 |
| private String subnetNo; | Subnet 번호 |
| private Boolean isPublicSubnet; | Public Subnet 여부 |
| private String publicDomain; | 공인 도메인명 |
| private String privateDomain; | 사설 도메인명 |
| private String privateIp; | 사설 IP |
| private CommonCode dataStorageType; | 데이터 스토리지 타입 |
| private Boolean isStorageEncryption; | 데이터 스토리지 암호화 여부 |
| private Long dataStorageSize; | 데이터 스토리지 사이즈 |
| private Long usedDataStorageSize; | 사용중인 데이터 스토리지 사이즈 |
| private Integer cpuCount; | virtual CPU 개수 |
| private Long memorySize; | 메모리 사이즈 |
| private Date uptime; | VM Booting 완료시간 |
| private Date createDate; | 생성일자 |
예시
호출과 응답 예시를 설명합니다.
호출 예시
호출 예시는 다음과 같습니다.
ncloud vmysql deleteCloudMysqlServerInstance --regionCode FKR --cloudMysqlServerInstanceNo ****048
응답 예시
응답 예시는 다음과 같습니다.
응답 결과 포맷 타입(output)이 json 일 때
{
"deleteCloudMysqlServerInstanceResponse": {
"requestId": "ec3580e6-2cc8-487b-bc61-f4ff52ffebc0",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMysqlInstanceList": {
"cloudMysqlInstance": {
"cloudMysqlInstanceNo": "****890",
"cloudMysqlServiceName": "test-****",
"cloudMysqlInstanceStatusName": "deleting",
"cloudMysqlInstanceStatus": {
"code": "CREAT",
"codeName": "CLOUD DATABASE(VPC) Created State"
},
"cloudMysqlInstanceOperation": {
"code": "NULL",
"codeName": "CLOUD DATABASE(VPC) Null OP"
},
"cloudMysqlImageProductCode": "SW.VDBAS.DBAAS.LNX64.CNTOS.0708.MYSQL.5732.B050",
"engineVersion": "MYSQL5.7.32",
"license": {
"code": "GPL",
"codeName": "General Public License"
},
"cloudMysqlPort": 13306,
"isHa": true,
"isMultiZone": true,
"isBackup": true,
"backupFileRetentionPeriod": 10,
"backupTime": "02:00",
"generationCode": "G2",
"createDate": "2021-05-27T18:00:00+0900",
"accessControlGroupNoList": [
"****58"
],
"cloudMysqlConfigList": [
"autocommit=ON",
"default-time-zone=+09:00",
"wait_timeout=28800"
],
"cloudMysqlServerInstanceList": {
"cloudMysqlServerInstance": [
{
"cloudMysqlServerInstanceNo": "****891",
"cloudMysqlServerName": "test-****-001-e04",
"cloudMysqlServerRole": {
"code": "M",
"codeName": "Master"
},
"cloudMysqlServerInstanceStatusName": "deleting",
"cloudMysqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMysqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
"regionCode": "FKR",
"zoneCode": "FKR-1",
"vpcNo": "****83",
"subnetNo": "****91",
"isPublicSubnet": true,
"publicDomain": "db-****.vpc-pub-cdb.ntruss.com",
"privateDomain": "db-****.vpc-cdb.ntruss.com",
"privateIp": "***.***.***.***",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"isStorageEncryption": true,
"dataStorageSize": 10737418240,
"usedDataStorageSize": 2791728640,
"cpuCount": 2,
"memorySize": 8589934592,
"uptime": "2021-05-27T18:10:00+0900",
"createDate": "2021-05-27T18:00:00+0900"
},
{
"cloudMysqlServerInstanceNo": "****897",
"cloudMysqlServerName": "test-****-002-e05",
"cloudMysqlServerRole": {
"code": "H",
"codeName": "Standby Master"
},
"cloudMysqlServerInstanceStatusName": "deleting",
"cloudMysqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMysqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
"regionCode": "FKR",
"zoneCode": "FKR-2",
"vpcNo": "****83",
"subnetNo": "****93",
"isPublicSubnet": true,
"privateDomain": "db-****.vpc-cdb.ntruss.com",
"privateIp": "***.***.***.***",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"isStorageEncryption": true,
"dataStorageSize": 10737418240,
"usedDataStorageSize": 2791728640,
"cpuCount": 2,
"memorySize": 8589934592,
"uptime": "2021-05-27T18:10:00+0900",
"createDate": "2021-05-27T18:00:00+0900"
},
{
"cloudMysqlServerInstanceNo": "****048",
"cloudMysqlServerName": "test-****-003-e06",
"cloudMysqlServerRole": {
"code": "S",
"codeName": "Slave"
},
"cloudMysqlServerInstanceStatusName": "deleting",
"cloudMysqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMysqlServerInstanceOperation": {
"code": "DEL",
"codeName": "CLOUD DATABASE(VPC) Server Delete OP"
},
"cloudMysqlProductCode": "SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002",
"regionCode": "FKR",
"zoneCode": "FKR-1",
"vpcNo": "****83",
"subnetNo": "****91",
"isPublicSubnet": true,
"privateDomain": "db-****.vpc-cdb.ntruss.com",
"privateIp": "***.***.***.***",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"isStorageEncryption": true,
"dataStorageSize": 10737418240,
"usedDataStorageSize": 2791728640,
"cpuCount": 2,
"memorySize": 8589934592,
"uptime": "2021-07-22T18:10:00+0900",
"createDate": "2021-07-22T18:00:00+0900"
}
]
}
}
}
}
}
응답 결과 포맷 타입(output)이 xml 일 때
<deleteCloudMysqlServerInstanceResponse>
<requestId>ec3580e6-2cc8-487b-bc61-f4ff52ffebc0</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMysqlInstanceList>
<cloudMysqlInstance>
<cloudMysqlInstanceNo>****890</cloudMysqlInstanceNo>
<cloudMysqlServiceName>test-****</cloudMysqlServiceName>
<cloudMysqlInstanceStatusName>deleting</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>
<cloudMysqlImageProductCode>SW.VDBAS.DBAAS.LNX64.CNTOS.0708.MYSQL.5732.B050</cloudMysqlImageProductCode>
<engineVersion>MYSQL5.7.32</engineVersion>
<license>
<code>GPL</code>
<codeName>General Public License</codeName>
</license>
<cloudMysqlPort>13306</cloudMysqlPort>
<isHa>true</isHa>
<isMultiZone>true</isMultiZone>
<isBackup>true</isBackup>
<backupFileRetentionPeriod>10</backupFileRetentionPeriod>
<backupTime>02:00</backupTime>
<generationCode>G2</generationCode>
<createDate>2021-05-27T18:00:00+0900</createDate>
<accessControlGroupNoList>
<accessControlGroupNo>****58</accessControlGroupNo>
</accessControlGroupNoList>
<cloudMysqlConfigList>
<cloudMysqlConfig>autocommit=ON</cloudMysqlConfig>
<cloudMysqlConfig>default-time-zone=+09:00</cloudMysqlConfig>
<cloudMysqlConfig>wait_timeout=28800</cloudMysqlConfig>
</cloudMysqlConfigList>
<cloudMysqlServerInstanceList>
<cloudMysqlServerInstance>
<cloudMysqlServerInstanceNo>****891</cloudMysqlServerInstanceNo>
<cloudMysqlServerName>test-****-001-e04</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>M</code>
<codeName>Master</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>deleting</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>
<cloudMysqlProductCode>SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002</cloudMysqlProductCode>
<regionCode>FKR</regionCode>
<zoneCode>FKR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<isPublicSubnet>true</isPublicSubnet>
<publicDomain>db-****.vpc-pub-cdb.ntruss.com</publicDomain>
<privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
<privateIp>***.***.***.***</privateIp>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<isStorageEncryption>true</isStorageEncryption>
<dataStorageSize>10737418240</dataStorageSize>
<usedDataStorageSize>2791728640</usedDataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<uptime>2021-05-27T18:10:00+0900</uptime>
<createDate>2021-05-27T18:00:00+0900</createDate>
</cloudMysqlServerInstance>
<cloudMysqlServerInstance>
<cloudMysqlServerInstanceNo>****897</cloudMysqlServerInstanceNo>
<cloudMysqlServerName>test-****-002-e05</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>H</code>
<codeName>Standby Master</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>deleting</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>
<cloudMysqlProductCode>SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002</cloudMysqlProductCode>
<regionCode>FKR</regionCode>
<zoneCode>FKR-2</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****93</subnetNo>
<isPublicSubnet>true</isPublicSubnet>
<privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
<privateIp>***.***.***.***</privateIp>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<isStorageEncryption>true</isStorageEncryption>
<dataStorageSize>10737418240</dataStorageSize>
<usedDataStorageSize>2791728640</usedDataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<uptime>2021-05-27T18:10:00+0900</uptime>
<createDate>2021-05-27T18:00:00+0900</createDate>
</cloudMysqlServerInstance>
<cloudMysqlServerInstance>
<cloudMysqlServerInstanceNo>****048</cloudMysqlServerInstanceNo>
<cloudMysqlServerName>test-****-003-e06</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>S</code>
<codeName>Slave</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>deleting</cloudMysqlServerInstanceStatusName>
<cloudMysqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMysqlServerInstanceStatus>
<cloudMysqlServerInstanceOperation>
<code>DEL</code>
<codeName>CLOUD DATABASE(VPC) Server Delete OP</codeName>
</cloudMysqlServerInstanceOperation>
<cloudMysqlProductCode>SVR.VDBAS.STAND.C002.M008.NET.HDD.B050.G002</cloudMysqlProductCode>
<regionCode>FKR</regionCode>
<zoneCode>FKR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<isPublicSubnet>true</isPublicSubnet>
<privateDomain>db-****.vpc-cdb.ntruss.com</privateDomain>
<privateIp>***.***.***.***</privateIp>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<isStorageEncryption>true</isStorageEncryption>
<dataStorageSize>10737418240</dataStorageSize>
<usedDataStorageSize>2791728640</usedDataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<uptime>2021-07-22T18:10:00+0900</uptime>
<createDate>2021-07-22T18:00:00+0900</createDate>
</cloudMysqlServerInstance>
</cloudMysqlServerInstanceList>
</cloudMysqlInstance>
</cloudMysqlInstanceList>
</deleteCloudMysqlServerInstanceResponse>