createCloudMysqlSlaveInstance
- 인쇄
- PDF
createCloudMysqlSlaveInstance
- 인쇄
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
VPC 환경에서 이용 가능합니다.
Cloud DB for MySQL 인스턴스에 Slave 서버 인스턴스를 추가합니다.
명령어
명령어 구문은 다음과 같습니다.
ncloud vmysql createCloudMysqlSlaveInstance [regionCode KR] [cloudMysqlInstanceNo] [subnetNo] [output]
파라미터
파라미터에 대한 설명은 다음과 같습니다.
파라미터 | 타입 | 필수 여부 | 설명 | 제약 사항 |
---|---|---|---|---|
regionCode | String | N | Cloud DB for MySQL 인스턴스가 존재하는 리전 코드 - getRegionList 액션을 통해서 획득 가능 - default: getRegionList 조회 결과의 첫 번째 리전을 선택 | - |
cloudMysqlInstanceNo | String | Y | Cloud DB for MySQL 인스턴스 번호 - getCloudMysqlInstanceList 액션을 통해서 획득 가능 | - |
subnetNo | String | N | Subnet 번호 - getCloudMysqlTargetSubnetList 액션을 통해서 획득 가능 - Cloud DB for MySQL 인스턴스의 isMultiZone이 true면 subnetNo은 반드시 입력 - Cloud DB for MySQL 인스턴스의 isMultiZone이 false면 subnetNo의 입력은 받지 않으며 기존 subnetNo에 생성됨 - Public 도메인은 Public Subnet에 생성된 DB 서버에서만 이용 신청 가능 - Cloud DB for MySQL Slave 서버 인스턴스 생성 이후에 Subnet 이전 불가능 | - |
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 createCloudMysqlSlaveInstance --regionCode KR --cloudMysqlInstanceNo ****890 --subnetNo ****91
응답 예시
응답 예시는 다음과 같습니다.
응답 결과 포맷 타입(output)이 json 일 때
{
"createCloudMysqlSlaveInstanceResponse": {
"requestId": "ec3580e6-2cc8-487b-bc61-f4ff52ffebc0",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMysqlInstanceList": {
"cloudMysqlInstance": {
"cloudMysqlInstanceNo": "****890",
"cloudMysqlServiceName": "test-****",
"cloudMysqlInstanceStatusName": "pending",
"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"
},
{
"cloudMysqlServerName": "test-****-003-e06",
"cloudMysqlServerRole": {
"code": "S",
"codeName": "Slave"
},
"cloudMysqlServerInstanceStatusName": "pending",
"cloudMysqlServerInstanceStatus": {
"code": "PEND",
"codeName": "CLOUD DATABASE(VPC) Server Pending 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,
"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 일 때
<createCloudMysqlSlaveInstanceResponse>
<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>pending</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>
<cloudMysqlServerName>test-****-003-e06</cloudMysqlServerName>
<cloudMysqlServerRole>
<code>S</code>
<codeName>Slave</codeName>
</cloudMysqlServerRole>
<cloudMysqlServerInstanceStatusName>pending</cloudMysqlServerInstanceStatusName>
<cloudMysqlServerInstanceStatus>
<code>PEND</code>
<codeName>CLOUD DATABASE(VPC) Server Pending 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>
<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>
</createCloudMysqlSlaveInstanceResponse>
이 문서가 도움이 되었습니까?