createCloudMssqlSlaveInstance
- 인쇄
- PDF
createCloudMssqlSlaveInstance
- 인쇄
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
VPC 환경에서 이용 가능합니다.
Cloud DB for MSSQL 인스턴스에 Slave 서버 인스턴스를 추가합니다.
명령어
명령어 구문은 다음과 같습니다.
ncloud vmssql createCloudMssqlSlaveInstance [regionCode] [cloudMssqlInstanceNo] [privateDomainPostfix] [subnetNo] [output]
파라미터
파라미터에 대한 설명은 다음과 같습니다.
파라미터 | 타입 | 필수 여부 | 설명 | 제약 사항 |
---|---|---|---|---|
regionCode | String | N | 리전 코드 - regionCode는 getRegionList 액션을 통해서 획득 - default: getRegionList 조회 결과의 첫 번째 리전 선택 | - |
cloudMssqlInstanceNo | String | Y | Slave 서버를 추가할 Cloud DB for MSSQL 인스턴스 번호 - cloudMssqlInstanceNo는 getCloudMssqlInstanceList 액션을 통해서 획득 | - |
privateDomainPostfix | String | Y | private domain postfix - 추가하는 Slave 서버에 부여할 private domain의 이름에 붙일 postfix | - 001 ~ 999 범위의 세 자리 숫자 형태만 입력 가능 |
subnetNo | String | N | Subnet 번호 - 생성할 Cloud DB for MSSQL 인스턴스의 Subnet을 결정 - subnetNo는 getCloudMssqlTargetSubnetList 액션을 통해서 획득 - Cloud DB for MSSQL 인스턴스의 isMultiZone이 true이면 subnetNo은 반드시 입력 - Cloud DB for MSSQL 인스턴스의 isMultiZone이 false이면 subnetNo의 입력은 받지 않으며 기존 subnetNo에 생성 - Public 도메인은 Public Subnet에 생성된 DB 서버에서만 이용 신청 가능 - Cloud DB for MSSQL 인스턴스 생성 이후에 Subnet 이전은 불가 | - |
output | String | N | 응답 결과의 포맷 타입 - options: xml | json - default: json | - |
응답
응답 데이터 타입
CloudMssqlInstanceList 타입
CloudMssqlInstanceList extends CommonResponse 설명 private Integer totalRows; 조회된 목록의 총 개수 private List<CloudMssqlInstance> cloudMssqlInstanceList = new ArrayList<>(); Cloud DB for MSSQL 인스턴스 목록 CloudMssqlInstance 타입
CloudMssqlInstance 설명 private String cloudMssqlInstanceNo; Cloud DB for MSSQL 인스턴스 번호 private String cloudMssqlServiceName; Cloud DB for MSSQL 서비스 이름 private String cloudMssqlInstanceStatusName; Cloud DB for MSSQL 인스턴스 상태 이름
-creating
-deleted
-deleting
-downgrading
-pending
-recovering
-reinstalling
-restarting
-running
-settingup
-shuttingdown
-stopped
-upgrading
private CommonCode cloudMssqlInstanceStatus; Cloud DB for MSSQL 인스턴스 상태 코드
-INIT (initiate)
-CREAT (created)
-DEL (deleted)
private CommonCode cloudMssqlInstanceOperation; Cloud DB for MSSQL 인스턴스 Operation 코드
-CREAT (create)
-DEL (delete)
-FO (failover)
-NULL (no operation)
-SETUP (setup)
-UPGD (upgrade)
-DWGD (downgrade)
-BKP (backup)
private String cloudMssqlImageProductCode; Cloud DB for MSSQL 이미지 상품 코드 private Boolean isHa; 고가용성 여부 private Boolean isMultiZone; 멀티존 여부 private CommonCode license; Cloud DB for MSSQL 라이선스 private Integer cloudMssqlPort; Cloud DB for MSSQL 포트 private Integer backupFileRetentionPeriod; 백업 파일 보관 기간 private String backupTime; 백업 시간 private String configGroupNo; Cloud DB for MSSQL Config Group 번호 private String configGroupName; Cloud DB for MSSQL Config Group 이름 private String engineVersion; Cloud DB for MSSQL 엔진 버전 private Date createDate; 생성일자 private String dbCollation; Cloud DB for MSSQL 문자셋 private List<CloudMssqlServerInstance> cloudMssqlServerInstanceList; Cloud DB for MSSQL 서버 인스턴스 목록 private AccessControlGroupNoList accessControlGroupNoList; ACG 번호 목록 CloudMssqlServerInstance 타입
CloudMssqlServerInstance 설명 private String cloudMssqlServerInstanceNo; Cloud DB for MSSQL 서버 인스턴스 번호 private String cloudMssqlServerName; Cloud DB for MSSQL 서버 이름 private CommonCode cloudMssqlServerRole; Cloud DB for MSSQL 서버 역할 private String cloudMssqlServerInstanceStatusName; Cloud DB for MSSQL 서버 인스턴스 상태 이름
-creating
-deleted
-deleting
-downgrading
-pending
-recovering
-reinstalling
-restarting
-running
-settingup
-shuttingdown
-stopped
-upgrading
-downgrading
private CommonCode cloudMssqlServerInstanceStatus; Cloud DB for MSSQL 서버 인스턴스 상태 코드
-DEL (deleted)
-PEND (pending)
-RUN (running)
-STOP (stopped)
-FSTOP (failure stopped)
private CommonCode cloudMssqlServerInstanceOperation; Cloud DB for MSSQL 서버 인스턴스 Operation 코드
-NOOP (no operation)
-CREAT (create)
-START (start)
-RSTRT (restart)
-SETUP (setup)
-STOP (stop)
-FO (failover)
-DEL (delete)
-UPGD (upgrade)
-DWGD (downgrade)
-RISTL (reinstall)
private String regionCode; 리전 코드 private String zoneCode; Zone 코드 private String vpcNo; VPC 번호 private String subnetNo; Subnet 번호 private Long dataStorageSize; 데이터 스토리지 사이즈 private Integer cpuCount; CPU 개수 private Long memorySize; 메모리 사이즈 private Boolean isPublicSubnet; Public Subnet 여부 private String cloudMssqlProductCode; Cloud DB for MSSQL 상품 코드 private String privateDomain; 사설 도메인명 private String publicDomain; 공인 도메인명 private Date createDate; 생성일자 private Date uptime; VM 부팅 완료 시간 private CommonCode dataStorageType; 데이터 스토리지 타입 private Long usedDataStorageSize; 사용중인 데이터 스토리지 사이즈 AccessControlGroupNoList 타입
AccessControlGroupNoList 설명 private List<String> accessControlGroupNoList = new ArrayList<>(); ACG 번호 목록
예시
호출과 응답 예시를 설명합니다.
호출 예시
호출 예시는 다음과 같습니다.
ncloud vmssql createCloudMssqlSlaveInstance --regionCode KR --cloudMssqlInstanceNo ****890 --privateDomainPostfix 777 --subnetNo ****92
응답 예시
응답 예시는 다음과 같습니다.
응답 결과 포맷 타입(output)이 json인 경우
응답 결과 포맷 타입(output)이 json인 경우는 다음과 같습니다.
{
"createCloudMssqlSlaveInstanceResponse": {
"requestId": "858c2941-2402-4686-9f4d-36a7a906a39d",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMssqlInstanceList": [
{
"cloudMssqlInstanceNo": "****890",
"cloudMssqlServiceName": "test-****",
"cloudMssqlInstanceStatusName": "running",
"cloudMssqlInstanceStatus": {
"code": "CREAT",
"codeName": "CLOUD DATABASE(VPC) Created State"
},
"cloudMssqlInstanceOperation": {
"code": "NULL",
"codeName": "CLOUD DATABASE(VPC) Null OP"
},
"cloudMssqlImageProductCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100",
"isHa": true,
"isMultiZone": true,
"license": {
"code": "SPLA",
"codeName": "Service Provider License Agreement"
},
"cloudMssqlPort": 1433,
"backupFileRetentionPeriod": 3,
"backupTime": "17:00",
"configGroupNo": 0,
"configGroupName": "test-****-config",
"engineVersion": "MSSQL 15.0.2000.5 Standard Edition",
"createDate": "2021-04-30T14:03:20+0900",
"dbCollation": "Korean_Wansung_CI_AS",
"cloudMssqlServerInstanceList": [
{
"cloudMssqlServerInstanceNo": "****891",
"cloudMssqlServerName": "m-****890-001",
"cloudMssqlServerRole": {
"code": "M",
"codeName": "Principal"
},
"cloudMssqlServerInstanceStatusName": "running",
"cloudMssqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMssqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Restart OP"
},
"regionCode": "KR",
"zoneCode": "KR-1",
"vpcNo": "****83",
"subnetNo": "****91",
"dataStorageSize": 107374182400,
"cpuCount": 2,
"memorySize": 8589934592,
"isPublicSubnet": true,
"cloudMssqlProductCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"privateDomain": "mssql-***.beta-vpc-cdb.ntruss.com",
"createDate": "2021-04-30T14:03:20+0900",
"uptime": "2021-04-30T14:14:39+0900",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"usedDataStorageSize": 1073741824
},
{
"cloudMssqlServerInstanceNo": "****897",
"cloudMssqlServerName": "m-****890-002",
"cloudMssqlServerRole": {
"code": "H",
"codeName": "Mirror"
},
"cloudMssqlServerInstanceStatusName": "running",
"cloudMssqlServerInstanceStatus": {
"code": "RUN",
"codeName": "CLOUD DATABASE(VPC) Server Running State"
},
"cloudMssqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"regionCode": "KR",
"zoneCode": "KR-1",
"vpcNo": "****83",
"subnetNo": "****91",
"dataStorageSize": 107374182400,
"cpuCount": 2,
"memorySize": 8589934592,
"isPublicSubnet": true,
"cloudMssqlProductCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"privateDomain": "mssql-***.beta-vpc-cdb.ntruss.com",
"createDate": "2021-05-27T19:00:00+0900",
"uptime": "2021-05-27T19:01:00+0900",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"usedDataStorageSize": 1073741824
},
{
"cloudMssqlServerInstanceNo": "****123",
"cloudMssqlServerName": "m-****890-003",
"cloudMssqlServerRole": {
"code": "S",
"codeName": "Slave"
},
"cloudMssqlServerInstanceStatusName": "PEND",
"cloudMssqlServerInstanceStatus": {
"code": "PEND",
"codeName": "CLOUD DATABASE(VPC) Server Pending State"
},
"cloudMssqlServerInstanceOperation": {
"code": "NOOP",
"codeName": "CLOUD DATABASE(VPC) Server Null OP"
},
"regionCode": "KR",
"zoneCode": "KR-2",
"vpcNo": "****83",
"subnetNo": "****92",
"dataStorageSize": 107374182400,
"cpuCount": 2,
"memorySize": 8589934592,
"isPublicSubnet": true,
"cloudMssqlProductCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"privateDomain": "mssql-***.beta-vpc-cdb.ntruss.com",
"createDate": "2021-05-27T19:00:00+0900",
"uptime": "2021-05-27T19:01:00+0900",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
},
"usedDataStorageSize": 1073741824
}
],
"accessControlGroupNoList": [
"****58"
]
}
]
}
}
응답 결과 포맷 타입(responseFormatType)이 xml인 경우
응답 결과 포맷 타입(responseFormatType)이 xml인 경우는 다음과 같습니다.
<createCloudMssqlSlaveInstanceResponse>
<requestId>858c2941-2402-4686-9f4d-36a7a906a39d</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMssqlInstanceList>
<CloudMssqlInstance>
<cloudMssqlInstanceNo>****890</cloudMssqlInstanceNo>
<cloudMssqlServiceName>test-****</cloudMssqlServiceName>
<cloudMssqlInstanceStatusName>running</cloudMssqlInstanceStatusName>
<cloudMssqlInstanceStatus>
<code>CREAT</code>
<codeName>CLOUD DATABASE(VPC) Created State</codeName>
</cloudMssqlInstanceStatus>
<cloudMssqlInstanceOperation>
<code>NULL</code>
<codeName>CLOUD DATABASE(VPC) Null OP</codeName>
</cloudMssqlInstanceOperation>
<cloudMssqlImageProductCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100</cloudMssqlImageProductCode>
<isHa>true</isHa>
<isMultiZone>true</isMultiZone>
<license>
<code>SPLA</code>
<codeName>Service Provider License Agreement</codeName>
</license>
<cloudMssqlPort>1433</cloudMssqlPort>
<backupFileRetentionPeriod>3</backupFileRetentionPeriod>
<backupTime>17:00</backupTime>
<configGroupNo>0</configGroupNo>
<configGroupName>test-****-config</configGroupName>
<engineVersion>MSSQL 15.0.2000.5 Standard Edition</engineVersion>
<createDate>2021-04-30T14:03:20+0900</createDate>
<dbCollation>Korean_Wansung_CI_AS</dbCollation>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceNo>****891</cloudMssqlServerInstanceNo>
<cloudMssqlServerName>m-****890-001</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>M</code>
<codeName>Principal</codeName>
</cloudMssqlServerRole>
<cloudMssqlServerInstanceStatusName>running</cloudMssqlServerInstanceStatusName>
<cloudMssqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMssqlServerInstanceStatus>
<cloudMssqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Restart OP</codeName>
</cloudMssqlServerInstanceOperation>
<regionCode>KR</regionCode>
<zoneCode>KR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>107374182400</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<privateDomain>mssql-***.beta-vpc-cdb.ntruss.com</privateDomain>
<createDate>2021-04-30T14:03:20+0900</createDate>
<uptime>2021-04-30T14:14:39+0900</uptime>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<usedDataStorageSize>1073741824</usedDataStorageSize>
</cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceNo>****897</cloudMssqlServerInstanceNo>
<cloudMssqlServerName>m-****890-002</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>H</code>
<codeName>Mirror</codeName>
</cloudMssqlServerRole>
<cloudMssqlServerInstanceStatusName>running</cloudMssqlServerInstanceStatusName>
<cloudMssqlServerInstanceStatus>
<code>RUN</code>
<codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
</cloudMssqlServerInstanceStatus>
<cloudMssqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMssqlServerInstanceOperation>
<regionCode>KR</regionCode>
<zoneCode>KR-1</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>107374182400</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<privateDomain>mssql-***.beta-vpc-cdb.ntruss.com</privateDomain>
<createDate>2021-05-27T19:00:00+0900</createDate>
<uptime>2021-05-27T19:01:00+0900</uptime>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<usedDataStorageSize>1073741824</usedDataStorageSize>
</cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstanceNo>****123</cloudMssqlServerInstanceNo>
<cloudMssqlServerName>m-****890-003</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>S</code>
<codeName>Slave</codeName>
</cloudMssqlServerRole>
<cloudMssqlServerInstanceStatusName>PEND</cloudMssqlServerInstanceStatusName>
<cloudMssqlServerInstanceStatus>
<code>PEND</code>
<codeName>CLOUD DATABASE(VPC) Server Pending State</codeName>
</cloudMssqlServerInstanceStatus>
<cloudMssqlServerInstanceOperation>
<code>NOOP</code>
<codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
</cloudMssqlServerInstanceOperation>
<regionCode>KR</regionCode>
<zoneCode>KR-2</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****92</subnetNo>
<dataStorageSize>107374182400</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<privateDomain>mssql-***.beta-vpc-cdb.ntruss.com</privateDomain>
<createDate>2021-05-27T19:00:00+0900</createDate>
<uptime>2021-05-27T19:01:00+0900</uptime>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
<usedDataStorageSize>1073741824</usedDataStorageSize>
</cloudMssqlServerInstanceList>
</cloudMssqlServerInstanceList>
<accessControlGroupNoList>
<accessControlGroupNo>****58</accessControlGroupNo>
</accessControlGroupNoList>
</CloudMssqlInstance>
</cloudMssqlInstanceList>
</createCloudMssqlSlaveInstanceResponse>
이 문서가 도움이 되었습니까?