Help & DocumentationTencentDB for MySQLAPI DocumentsInstance APICreateDBInstanceHour

CreateDBInstanceHour

Last updated: 2019-11-29 19:48:23

PDF

Contents：

1. API Description

Domain name for API request: cdb.tencentcloudapi.com.

This API (CreateDBInstanceHour) is used to create postpaid database instances by passing such information as instance specification, MySQL version number, and quantity. You can create master instances, disaster recovery instances, and read-only instances via this API.

  1. Please first use the API [Query Supported Database Specifications] to query the supported specifications, and then use the API [Query Price (Postpaid)] to query the price of supported instances.
  2. A maximum of 100 instances can be created at one time with a maximum validity period of 36 months.
  3. MySQL 5.5, 5.6 and 5.7 versions are supported.
  4. Master instances, disaster recovery instances, and read-only instances can be created via this API.

A maximum of 20 requests can be initiated per second for this API.

Note: This API supports Finance regions. Since Finance regions and non-Finance regions are isolated and not interconnected. If the common parameter Region is a Finance region (such as ap-shanghai-fsi), you need to specify a domain name containing the Finance region that should be identical to the value of Region field, for example: cdb.ap-shanghai-fsi.tencentcloudapi.com.

2. Input Parameters

The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see [Common Request Parameters].

Parameter Name Required Type Description
Action Yes String Common parameter. The value used for this API: CreateDBInstanceHour
Version Yes String Common parameter. The value used for this API: 2017-03-20
Region Yes String Common parameter. For more information, please see the [list of regions] supported by the product.
GoodsNum Yes Integer Number of instances. Default is 1, minimum is 1, and maximum is 100.
Memory Yes Integer Instance memory size (in MB). You can obtain supported memory specifications using the API [Query Supported Database Specifications].
Volume Yes Integer Instance disk size (in GB). You can obtain supported disk size ranges using the API [Query Supported Database Specifications].
EngineVersion No String MySQL version. Values include: 5.5, 5.6 and 5.7. You can obtain supported instance versions using the API [Query Supported Database Specifications].
UniqVpcId No String VPC ID. If this is left empty, the default is basic network. You can obtain the VPC ID using the API Query VPC List.
UniqSubnetId No String Subnet ID under a VPC. If UniqVpcId is set, UniqSubnetId is required. You can obtain the subnet ID using the API Query Subnet List.
ProjectId No Integer Project ID. If this is left empty, default project is used. You can obtain the project ID using the API [Query Project List]
Zone No String Availability zone information. If this is left empty, an availability zone will be selected automatically. You can obtain supported availability zones using the API [Query Supported Database Specifications].
MasterInstanceId No String Instance ID, which is required when you purchase read-only instances or disaster recovery instances. This field indicates the master instance ID of read-only instances or disaster recovery instances.
InstanceRole No String Instance type. Default is master. Supported values include: master - master instance, dr - disaster recovery instance, and ro - read-only instance.
MasterRegion No String Availability zone information of the master instance, which is required when you purchase disaster recovery instances.
Port No Integer Custom port. Supported value range: [1024-65535]
Password No String Password of root account, which should be a combination of 8-64 characters comprised of at least two of the following types: letters, numbers, and special characters (_, +, -, &, =, !, @, #, $, %, ^, *, ()). This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
ParamList.N No Array of ParamInfo Parameter list. Format: ParamList.0.Name=auto_increment&ParamList.0.Value=1. You can query supported parameters using the API Query Parameter List.
ProtectMode No Integer Data replication mode. Default is 0. Supported values include: 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
DeployMode No Integer Multiple availability zones. Default is 0. Supported values include: 0 - single availability zone, 1 - multiple availability zones. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
SlaveZone No String Availability zone ID of slave 1. Default is the value of zoneId. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
BackupZone No String Availability zone ID of slave 2. Default is 0. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
SecurityGroup.N No Array of String Security group parameter
RoGroup No RoGroup Read-only instance information
AutoRenewFlag No Integer Auto renewal flag. Supported values: 0 and 1
InstanceName No String Instance name

3. Output Parameters

Parameter Name Type Description
DealIds Array of String Order ID, which is used to call Cloud APIs, such as [Acquire Order Information]
InstanceIds Array of String Instance ID list
RequestId String The unique request ID, which is returned for each request. RequestId is required for locating a problem.

4. Error Codes

The following only lists the error codes related to the API business logic. For other error codes, see [Common Error Codes].

Error Code Description
InternalError.DatabaseAccessError Database's internal error.
InternalError.DfwError Security group operation error.
InternalError.TradeError Internal error with trading system.
InternalError.VpcError VPC or subnet error.
InvalidParameter Parameter error.
OperationDenied.ActionNotSupport Unsupported operation.
OperationDenied.WrongPassword Incorrect password or verification failed.

5. Example

Example 1 Create a database instance (Postpaid)

Input example

https://cdb.tencentcloudapi.com/?Action=CreateDBInstanceHour
&Memory=1000
&Volume=25
&GoodsNum=1
&Zone=ap-guangzhou-3
&UniqVpcId=vpc-0akbol5v
&UniqSubnetId=subnet-fyrtjbqw
&ProjectId=0
&InstanceRole=master
&EngineVersion=5.6
&ProtectMode=0
&DeployMode=0
&SlaveZone=ap-guangzhou-3
&<Common request parameters>

Output example

{
  "Response": {
    "DealIds": [
      "20171201160000002670226599824833"
    ],
    "InstanceIds": [
      "cdb-03brtubb"
    ],
    "RequestId": "6EF60BEC-0242-43AF-BB20-270359FB54A7"
  }
}

6. Other Resources

Cloud API 3.0 comes with the following development tools to make it easier to call the API.