VPC環境で利用できます。
Cloud DB for MSSQLインスタンスを作成します。
コマンド
コマンド構文は次の通りです。
ncloud vmssql createCloudMssqlInstance [regionCode] [vpcNo] [subnetNo] [mirrorSubnetNo] [cloudMssqlServiceName] [configGroupNo] [cloudMssqlImageProductCode] [cloudMssqlProductCode] [dataStorageTypeCode] [isHa] [isMultiZone] [backupFileRetentionPeriod] [backupTime] [isAutomaticBackup] [cloudMssqlUserName] [cloudMssqlUserPassword] [cloudMssqlPort] [characterSetName] [engineVersionCode] [output]
パラメータ
パラメータの説明は次の通りです。
| パラメータ | タイプ | 必須の有無 | 説明 | 制限事項 |
|---|---|---|---|---|
| regionCode | String | N | リージョンコード
|
- |
| vpcNo | String | Y | VPC番号
|
- |
| subnetNo | String | Y | Subnet番号
|
- |
| mirrorSubnetNo | String | N | Mirrorサーバの Subnet番号
|
- |
| cloudMssqlServiceName | String | Y | Cloud DB for MSSQLサービス名 |
|
| configGroupNo | String | N | Cloud DB for MSSQL Config Group番号
|
- |
| cloudMssqlImageProductCode | String | N | Cloud DB for MSSQLイメージ商品コード
|
- |
| cloudMssqlProductCode | String | N | Cloud DB for MSSQL商品コード
|
- |
| dataStorageTypeCode | String | N | データストレージタイプコード
|
- |
| isHa | Boolean | Y | 高可用性の有無
|
- |
| isMultiZone | Boolean | N | マルチゾーンの有無
|
- |
| backupFileRetentionPeriod | Integer | N | バックアップファイルの保管期間
|
|
| backupTime | String | N | バックアップ時間
|
|
| isAutomaticBackup | Boolean | N | バックアップ時間の自動有無
|
- |
| cloudMssqlUserName | String | Y | アクセスユーザー名
|
|
| cloudMssqlUserPassword | String | Y | アクセスパスワード
|
|
| cloudMssqlPort | Integer | N | Cloud DB for MSSQLポート
|
1433
|
| characterSetName | String | N | DBキャラクターセット
|
- |
| engineVersionCode | String | N | DBエンジンのバージョン
|
- |
| output | String | N | レスポンス結果の形式タイプ
|
- |
レスポンス
レスポンスデータタイプ
-
CloudMssqlInstanceListタイプ
CloudMssqlInstanceList extends CommonResponse 説明 private Integer totalRows; private List<CloudMssqlInstance> cloudMssqlInstanceList = new ArrayList<>(); -
CloudMssqlInstanceタイプ
CloudMssqlInstance 説明 private String cloudMssqlInstanceNo; private String cloudMssqlServiceName; private String cloudMssqlInstanceStatusName; private CommonCode cloudMssqlInstanceStatus; private CommonCode cloudMssqlInstanceOperation; private String generationCode; 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タイプ
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タイプ
AccessControlGroupNoList 説明 private List<String> accessControlGroupNoList = new ArrayList<>();
例
呼び出しとレスポンスの例を説明します。
呼び出し例
呼び出しのサンプルコードは次の通りです。
ncloud vmssql createCloudMssqlInstance --regionCode KR --vpcNo ****83 --subnetNo ****91 --mirrorSubnetNo ****92 --cloudMssqlServiceName test-**** --configGroupNo **9 --cloudMssqlImageProductCode SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100 --cloudMssqlProductCode SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002 --dataStorageTypeCode SSD --isHa true --isMultiZone true --backupFileRetentionPeriod 10 --backupTime 00:15 --isAutomaticBackup true --cloudMssqlUserName test**** --cloudMssqlUserPassword ******** --cloudMssqlPort 1433 --characterSetName Korean_Wansung_CI_AS --engineVersionCode 15.0.4355.3
レスポンス例
レスポンスのサンプルコードは次の通りです。
レスポンス結果の形式タイプ(output)が jsonの場合
レスポンス結果の形式タイプ(output)が jsonの場合は次の通りです。
{
"createCloudMssqlInstanceResponse": {
"requestId": "c04bfdd1-e27e-4006-9bc3-bc37840ce1dd",
"returnCode": 0,
"returnMessage": "success",
"totalRows": 1,
"cloudMssqlInstanceList": [
{
"cloudMssqlInstanceNo": "****890",
"cloudMssqlServiceName": "test-****",
"cloudMssqlInstanceStatusName": "creating",
"cloudMssqlInstanceStatus": {
"code": "INIT",
"codeName": "CLOUD DATABASE(VPC) Init State"
},
"cloudMssqlInstanceOperation": {
"code": "CREAT",
"codeName": "CLOUD DATABASE(VPC) Creat OP"
},
"generationCode": "G2",
"cloudMssqlImageProductCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100",
"isHa": true,
"isMultiZone": true,
"license": {
"code": "GPL",
"codeName": "General Public License"
},
"cloudMssqlPort": 1433,
"backupFileRetentionPeriod": 10,
"backupTime": "00:15",
"configGroupNo": "**9",
"configGroupName": "test-****-config",
"engineVersion": "MSSQL 15.0.2000.5 Standard Edition",
"createDate": "2021-04-12T19:30:38+0900",
"cloudMssqlServerInstanceList": [
{
"cloudMssqlServerName": "test-****-001-e04",
"cloudMssqlServerRole": {
"code": "M",
"codeName": "Principal"
},
"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": "****83",
"subnetNo": "****91",
"dataStorageSize": 10737418240,
"cpuCount": 2,
"memorySize": 8589934592,
"isPublicSubnet": true,
"cloudMssqlProductCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"createDate": "2021-05-27T19:00:00+0900",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
}
},
{
"cloudMssqlServerName": "test-****-001-e05",
"cloudMssqlServerRole": {
"code": "H",
"codeName": "Mirror"
},
"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-2",
"vpcNo": "****83",
"subnetNo": "****92",
"dataStorageSize": 10737418240,
"cpuCount": 2,
"memorySize": 8589934592,
"isPublicSubnet": true,
"cloudMssqlProductCode": "SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002",
"createDate": "2021-05-27T19:00:00+0900",
"dataStorageType": {
"code": "SSD",
"codeName": "SSD"
}
}
]
}
]
}
}
レスポンス結果の形式タイプ(responseFormatType)が xmlの場合
レスポンス結果の形式タイプ(responseFormatType)が xmlの場合は次の通りです。
<createCloudMssqlInstanceResponse>
<requestId>c04bfdd1-e27e-4006-9bc3-bc37840ce1dd</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudMssqlInstanceList>
<cloudMssqlInstance>
<cloudMssqlInstanceNo>****890</cloudMssqlInstanceNo>
<cloudMssqlServiceName>test-****</cloudMssqlServiceName>
<cloudMssqlInstanceStatusName>creating</cloudMssqlInstanceStatusName>
<cloudMssqlInstanceStatus>
<code>INIT</code>
<codeName>CLOUD DATABASE(VPC) Init State</codeName>
</cloudMssqlInstanceStatus>
<cloudMssqlInstanceOperation>
<code>CREAT</code>
<codeName>CLOUD DATABASE(VPC) Creat OP</codeName>
</cloudMssqlInstanceOperation>
<generationCode>G2</generationCode>
<cloudMssqlImageProductCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100</cloudMssqlImageProductCode>
<isHa>true</isHa>
<isMultiZone>true</isMultiZone>
<license>
<code>GPL</code>
<codeName>General Public License</codeName>
</license>
<cloudMssqlPort>1433</cloudMssqlPort>
<backupFileRetentionPeriod>10</backupFileRetentionPeriod>
<backupTime>00:15</backupTime>
<configGroupNo>**9</configGroupNo>
<configGroupName>test-****-config</configGroupName>
<engineVersion>MSSQL 15.0.2000.5 Standard Edition</engineVersion>
<createDate>2021-04-12T19:30:38+0900</createDate>
<cloudMssqlServerInstanceList>
<cloudMssqlServerInstance>
<cloudMssqlServerName>test-****-001-e04</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>M</code>
<codeName>Principal</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>****83</vpcNo>
<subnetNo>****91</subnetNo>
<dataStorageSize>10737418240</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<createDate>2021-05-27T19:00:00+0900</createDate>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
</cloudMssqlServerInstance><cloudMssqlServerInstance>
<cloudMssqlServerName>test-****-001-e05</cloudMssqlServerName>
<cloudMssqlServerRole>
<code>H</code>
<codeName>Mirror</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-2</zoneCode>
<vpcNo>****83</vpcNo>
<subnetNo>****92</subnetNo>
<dataStorageSize>10737418240</dataStorageSize>
<cpuCount>2</cpuCount>
<memorySize>8589934592</memorySize>
<isPublicSubnet>true</isPublicSubnet>
<cloudMssqlProductCode>SVR.VMSSL.STAND.C002.M008.NET.HDD.B100.G002</cloudMssqlProductCode>
<createDate>2021-05-27T19:00:00+0900</createDate>
<dataStorageType>
<code>SSD</code>
<codeName>SSD</codeName>
</dataStorageType>
</cloudMssqlServerInstance>
</cloudMssqlServerInstanceList>
</cloudMssqlInstance>
</cloudMssqlInstanceList>
</createCloudMssqlInstanceResponse>