createCloudMssqlSlaveInstance
- 印刷する
- PDF
createCloudMssqlSlaveInstance
- 印刷する
- PDF
記事の要約
この要約は役に立ちましたか?
ご意見ありがとうございます
VPC環境で利用できます。
Cloud DB for MSSQLインスタンスに Slaveサーバインスタンスを追加します。
リクエスト
リクエスト形式を説明します。リクエスト形式は次の通りです。
メソッド | URI |
---|---|
GET, POST | /createCloudMssqlSlaveInstance |
リクエストヘッダ
Cloud DB for MSSQL (VPC) APIで共通して使用されるヘッダの詳細は、Cloud DB for MSSQL (VPC)のリクエストヘッダをご参照ください。
リクエストパラメータ
パラメータの説明は次の通りです。
フィールド | タイプ | 必須の有無 | 説明 |
---|---|---|---|
regionCode | String | Optional | Slaveサーバインスタンス作成対象の Cloud DB for MSSQLインスタンスのリージョンコード
|
cloudMssqlInstanceNo | String | Required | Cloud DB for MSSQLインスタンス番号 |
privateDomainPostfix | String | Required | Slaveサーバインスタンスの Privateドメインの Postfix
|
subnetNo | String | Conditional | Cloud DB for MSSQLインスタンスで使用する基本ネットワークインターフェースの Subnet番号
|
responseFormatType | String | Optional | レスポンス結果の形式
|
リクエスト例
リクエストのサンプルコードは次の通りです。
curl --location --request GET 'https://ncloud.apigw.ntruss.com/vmssql/v2/createCloudMssqlSlaveInstance
?regionNo=KR
&cloudMssqlInstanceNo=2517****
&privateDomainPostfix=002
&subnetNo=139***
&responseFormatType=json'
--header 'x-ncp-apigw-timestamp: {Timestamp}'
--header 'x-ncp-iam-access-key: {Access Key}'
--header 'x-ncp-apigw-signature-v2: {API Gateway Signature}'
レスポンス
レスポンス形式を説明します。
レスポンスボディ
レスポンスボディの詳細は、CloudMssqlInstanceListをご参照ください。
レスポンスステータスコード
NAVERクラウドプラットフォームでで共通して使用されるレスポンスステータスコードの詳細は、Ncloud APIのレスポンスステータスコードをご参照ください。
レスポンス例
レスポンスのサンプルコードは次の通りです。
responseFormetType=json
の場合{ "createCloudMssqlSlaveInstanceResponse": { "totalRows": 1, "cloudMssqlInstanceList": [ { "cloudMssqlInstanceNo": "2517****", "cloudMssqlServiceName": "mssql002", "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.15043553.EE.B100", "isHa": true, "isMultiZone": false, "license": { "code": "SPLA", "codeName": "Service Provider License Agreement" }, "cloudMssqlPort": 1433, "backupFileRetentionPeriod": 1, "backupTime": "02:00", "configGroupNo": "0", "configGroupName": "mssql_2019_default", "engineVersion": "MSSQL 15.0.4355.3 Enterprise Edition", "createDate": "2024-06-25T10:18:57+0900", "dbCollation": "Korean_Wansung_CI_AS", "cloudMssqlServerInstanceList": [ { "cloudMssqlServerInstanceNo": "2517****", "cloudMssqlServerName": "m-2517****-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 Null OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****.vpc-cdb.ntruss.com", "createDate": "2024-06-25T10:18:57+0900", "uptime": "2024-06-25T10:48:04+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2517****", "cloudMssqlServerName": "m-2517****-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": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****.vpc-cdb.ntruss.com", "createDate": "2024-06-25T10:18:57+0900", "uptime": "2024-06-25T11:01:26+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2529****", "cloudMssqlServerName": "m-2517****-005", "cloudMssqlServerRole": { "code": "S", "codeName": "Slave" }, "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": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****-r001.vpc-cdb.ntruss.com", "createDate": "2024-07-01T15:50:23+0900", "uptime": "2024-07-01T16:19:57+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2529****", "cloudMssqlServerName": "m-2517****-006", "cloudMssqlServerRole": { "code": "S", "codeName": "Slave" }, "cloudMssqlServerInstanceStatusName": "creating", "cloudMssqlServerInstanceStatus": { "code": "PEND", "codeName": "CLOUD DATABASE(VPC) Server Pending State" }, "cloudMssqlServerInstanceOperation": { "code": "CREAT", "codeName": "CLOUD DATABASE(VPC) Server Create OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "createDate": "2024-07-01T16:50:01+0900", "uptime": "2024-07-01T17:22:39+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" } } ], "accessControlGroupNoList": [ "184***" ] } ], "requestId": "ba3feb17-****-****-****-c326f4ca42e1", "returnCode": "0", "returnMessage": "success" } }
responseFormetType=xml
(デフォルト)の場合<?xml version="1.0" encoding="UTF-8"?> <createCloudMssqlSlaveInstanceResponse> <requestId>ba3feb17-****-****-****-c326f4ca42e1</requestId> <returnCode>0</returnCode> <returnMessage>success</returnMessage> <totalRows>1</totalRows> <cloudMssqlInstanceList> <cloudMssqlInstance> <cloudMssqlInstanceNo>2517****</cloudMssqlInstanceNo> <cloudMssqlServiceName>mssql002</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.15043553.EE.B100</cloudMssqlImageProductCode> <isHa>true</isHa> <isMultiZone>false</isMultiZone> <license> <code>SPLA</code> <codeName>Service Provider License Agreement</codeName> </license> <cloudMssqlPort>1433</cloudMssqlPort> <backupFileRetentionPeriod>1</backupFileRetentionPeriod> <backupTime>02:00</backupTime> <configGroupNo>0</configGroupNo> <configGroupName>mssql_2019_default</configGroupName> <engineVersion>MSSQL 15.0.4355.3 Enterprise Edition</engineVersion> <createDate>2024-06-25T10:18:57+0900</createDate> <dbCollation>Korean_Wansung_CI_AS</dbCollation> <cloudMssqlServerInstanceList> <cloudMssqlServerInstance> <cloudMssqlServerInstanceNo>2517****</cloudMssqlServerInstanceNo> <cloudMssqlServerName>m-2517****-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 Null OP</codeName> </cloudMssqlServerInstanceOperation> <regionCode>KR</regionCode> <zoneCode>KR-1</zoneCode> <vpcNo>59***</vpcNo> <subnetNo>140***</subnetNo> <dataStorageSize>107374182400</dataStorageSize> <cpuCount>2</cpuCount> <memorySize>4294967296</memorySize> <isPublicSubnet>true</isPublicSubnet> <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode> <privateDomain>mssql-****.vpc-cdb.ntruss.com</privateDomain> <createDate>2024-06-25T10:18:57+0900</createDate> <uptime>2024-06-25T10:48:04+0900</uptime> <dataStorageType> <code>SSD</code> <codeName>SSD</codeName> </dataStorageType> <usedDataStorageSize>1073741824</usedDataStorageSize> </cloudMssqlServerInstance> <cloudMssqlServerInstance> <cloudMssqlServerInstanceNo>2517****</cloudMssqlServerInstanceNo> <cloudMssqlServerName>m-2517****-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>59***</vpcNo> <subnetNo>140***</subnetNo> <dataStorageSize>107374182400</dataStorageSize> <cpuCount>2</cpuCount> <memorySize>4294967296</memorySize> <isPublicSubnet>true</isPublicSubnet> <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode> <privateDomain>mssql-****.vpc-cdb.ntruss.com</privateDomain> <createDate>2024-06-25T10:18:57+0900</createDate> <uptime>2024-06-25T11:01:26+0900</uptime> <dataStorageType> <code>SSD</code> <codeName>SSD</codeName> </dataStorageType> <usedDataStorageSize>1073741824</usedDataStorageSize> </cloudMssqlServerInstance> <cloudMssqlServerInstance> <cloudMssqlServerInstanceNo>2529****</cloudMssqlServerInstanceNo> <cloudMssqlServerName>m-2517****-005</cloudMssqlServerName> <cloudMssqlServerRole> <code>S</code> <codeName>Slave</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>59***</vpcNo> <subnetNo>140***</subnetNo> <dataStorageSize>107374182400</dataStorageSize> <cpuCount>2</cpuCount> <memorySize>4294967296</memorySize> <isPublicSubnet>true</isPublicSubnet> <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode> <privateDomain>mssql-****-r001.vpc-cdb.ntruss.com</privateDomain> <createDate>2024-07-01T15:50:23+0900</createDate> <uptime>2024-07-01T16:19:57+0900</uptime> <dataStorageType> <code>SSD</code> <codeName>SSD</codeName> </dataStorageType> <usedDataStorageSize>1073741824</usedDataStorageSize> </cloudMssqlServerInstance> <cloudMssqlServerInstance> <cloudMssqlServerInstanceNo>2529****</cloudMssqlServerInstanceNo> <cloudMssqlServerName>m-2517****-006</cloudMssqlServerName> <cloudMssqlServerRole> <code>S</code> <codeName>Slave</codeName> </cloudMssqlServerRole> <cloudMssqlServerInstanceStatusName>creating</cloudMssqlServerInstanceStatusName> <cloudMssqlServerInstanceStatus> <code>PEND</code> <codeName>CLOUD DATABASE(VPC) Server Pending State</codeName> </cloudMssqlServerInstanceStatus> <cloudMssqlServerInstanceOperation> <code>CREAT</code> <codeName>CLOUD DATABASE(VPC) Server Create OP</codeName> </cloudMssqlServerInstanceOperation> <regionCode>KR</regionCode> <zoneCode>KR-1</zoneCode> <vpcNo>59***</vpcNo> <subnetNo>140***</subnetNo> <dataStorageSize>107374182400</dataStorageSize> <cpuCount>2</cpuCount> <memorySize>4294967296</memorySize> <isPublicSubnet>true</isPublicSubnet> <cloudMssqlProductCode>SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002</cloudMssqlProductCode> <privateDomain>mssql-****-r002.vpc-cdb.ntruss.com</privateDomain> <createDate>2024-07-01T16:50:01+0900</createDate> <uptime>2024-07-01T17:22:39+0900</uptime> <dataStorageType> <code>SSD</code> <codeName>SSD</codeName> </dataStorageType> <usedDataStorageSize>1073741824</usedDataStorageSize> </cloudMssqlServerInstance> </cloudMssqlServerInstanceList> <accessControlGroupNoList> <accessControlGroupNo>184***</accessControlGroupNo> </accessControlGroupNoList> </cloudMssqlInstance> </cloudMssqlInstanceList> </createCloudMssqlSlaveInstanceResponse>
この記事は役に立ちましたか?