deleteCloudMysqlServerInstance
- 인쇄
- PDF
deleteCloudMysqlServerInstance
- 인쇄
- PDF
기사 요약
이 요약이 도움이 되었나요?
의견을 보내 주셔서 감사합니다.
VPC 환경에서 이용 가능합니다.
Cloud DB for MySQL 서버 인스턴스를 삭제합니다.
명령어
명령어 구문은 다음과 같습니다.
ncloud vmysql deleteCloudMysqlServerInstance [regionCode KR] [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 KR --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": "KR",
"zoneCode": "KR-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": "KR",
"zoneCode": "KR-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": "KR",
"zoneCode": "KR-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>KR</regionCode>
<zoneCode>KR-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>KR</regionCode>
<zoneCode>KR-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>KR</regionCode>
<zoneCode>KR-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>
이 문서가 도움이 되었습니까?