createCloudMssqlSlaveInstance

인쇄
공유
PDF

Article Summary

Share feedback

Thanks for sharing your feedback!

개요

Cloud DB for MSSQL 인스턴스에 Slave 서버 인스턴스를 추가합니다.

요청

요청 파라미터

파라미터명	필수 여부	타입	제약 사항	설명
cloudMssqlInstanceNo	Yes	String		- Slave 서버를 추가할 Cloud DB for MSSQL 인스턴스 번호 Cloud DB for MSSQL 인스턴스를 식별하기 위한 NAVER CLOUD PLATFORM의 식별자 cloudMssqlInstanceNo는 getCloudMssqlInstanceList 액션을 통해서 획득 가능
regionCode	No	String		- 리전 코드 추가될 Cloud DB for MSSQL Slave 서버 인스턴스의 리전(Region)을 결정 가능 regionCode는 getRegionList 액션을 통해서 획득 가능 Default : getRegionList 조회 결과의 첫 번째 리전 선택
privateDomainPostfix	Yes	String	001 ~ 999 범위의 세 자리 숫자 형태만 입력 가능	- private domain postfix 추가하는 Slave 서버에 부여할 private domain의 이름에 붙일 postfix
subnetNo	Conditional	String		- Subnet 번호 생성할 Cloud 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	No	String		- 응답 결과의 포맷 타입 Options: xml \| json Default: json

응답

응답 데이터 타입

CloudMssqlInstanceList 타입

CloudMssqlInstanceList extends CommonResponse
private Integer totalRows;
private List<CloudMssqlInstance> cloudMssqlInstanceList = new ArrayList<>();

CloudMssqlInstance
private String cloudMssqlInstanceNo;
private String cloudMssqlServiceName;
private String cloudMssqlInstanceStatusName;
private CommonCode cloudMssqlInstanceStatus;
private CommonCode cloudMssqlInstanceOperation;
private String cloudMssqlImageProductCode;
private Boolean isHa;
private Boolean isMultiZone;
private CommonCode license;
private Integer cloudMssqlPort;
private Integer backupFileRetentionPeriod;
private String backupTime;
private String configGroupNo;
private String configGroupName;
private String engineVersion;
private Date createDate;
private String dbCollation;
private List<CloudMssqlServerInstance> cloudMssqlServerInstanceList;
private AccessControlGroupNoList accessControlGroupNoList;

CloudMssqlServerInstance
private String cloudMssqlServerInstanceNo;
private String cloudMssqlServerName;
private CommonCode cloudMssqlServerRole;
private String cloudMssqlServerInstanceStatusName;
private CommonCode cloudMssqlServerInstanceStatus;
private CommonCode cloudMssqlServerInstanceOperation;
private String regionCode;
private String zoneCode;
private String vpcNo;
private String subnetNo;
private Long dataStorageSize;
private Integer cpuCount;
private Long memorySize;
private Boolean isPublicSubnet;
private String cloudMssqlProductCode;
private String privateDomain;
private String publicDomain;
private Date createDate;
private Date uptime;
private CommonCode dataStorageType;
private Long usedDataStorageSize;

AccessControlGroupNoList
private List<String> accessControlGroupNoList = new ArrayList<>();

예시

요청 예시

ncloud vmssql createCloudMssqlSlaveInstance --regionCode FKR --cloudMssqlInstanceNo ****890 --privateDomainPostfix 777 --subnetNo ****92

응답 예시

<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>FKR</regionCode>
                    <zoneCode>FKR-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>FKR</regionCode>
                    <zoneCode>FKR-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>FKR</regionCode>
                    <zoneCode>FKR-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>

이 문서가 도움이 되었습니까?

What's Next

deleteCloudMssqlInstance

개요
요청
응답
예시

태그

Cloud DB for MSSQL