tencent cloud

TencentDB for MySQL

Instance Purchase

Download
Focus Mode
Font Size
Last updated: 2026-10-12 10:09:21
AI-Translated
API
Description
CreateDBInstance
Creating a Cloud Database Instance (Yearly/Monthly Subscription)
CreateDBInstanceHour
Creating a TencentDB for MongoDB Instance (Pay-as-You-Go)
DescribeDBInstances
Queries the instance list
DescribeDBPrice
Query the database price

Creating a Cloud Database Instance with CreateDBInstance (Yearly/Monthly Subscription)

#!/usr/bin/python
# -*- coding: utf-8 -*-

# Import the TencentCloud API entry module
import logging
import traceback
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models


Purchase Primary Instance
def CreateDBInstancedemomaster():
try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-beijing")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.CreateDBInstanceRequest()
req.Memory = 2000
req.Volume = 120
req.Period = 1
req.GoodsNum =1
req.Zone = "ap-beijing-1"
req.Port = 3306
#req.MasterInstanceId = "cdb-7ghaiocc"
req.InstanceRole = "master"
req.EngineVersion = "5.6"
req.Password = "CDB@Qcloud"
req.ProtectMode = 0
req.InstanceName = "tencentcdb"
req.SecurityGroup = ["sg-eq0hvlzp"]


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.CreateDBInstance(req)
# Output the response as a json string.
print(resp.to_json_string())


except TencentCloudSDKException as err:
msg = traceback.format_exc() # Method 1
print (msg)




Purchase Read-Only Instance
def CreateDBInstancedemoro():
try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-beijing")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.CreateDBInstanceRequest()
req.Memory = 2000
req.Volume = 200
req.Period = 1
req.GoodsNum =1
req.Zone = "ap-beijing-1"
req.Port = 3306
req.InstanceRole = "ro"
req.EngineVersion = "5.6"
req.Password = "CDB@Qcloud"
req.ProtectMode = 0
req.DeployMode =1
req.GoodsNum =2
req.SlaveZone = "ap-beijing-1"
req.ParamList = [{"name":"max_connections","value":"1000"},{"name":"lower_case_table_names","value":"1"}]
req.BackupZone = "0"
req.AutoRenewFlag =0
req.MasterInstanceId ="cdb-bgr97hu0"
req.RoGroup = {"RoGroupMode":"allinone","RoGroupName":"roweek"}
req.InstanceName = "tencentcdbRO"


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.CreateDBInstance(req)
# Output the response as a json string.
print(resp.to_json_string())


except TencentCloudSDKException as err:
msg = traceback.format_exc() # Method 1
print (msg)


Purchase Disaster Recovery Instance
def CreateDBInstancedemodr():
try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-shanghai")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.CreateDBInstanceRequest()

req.Memory = 4000
req.Volume = 200
req.Period = 1
req.GoodsNum =1
#req.Zone = "ap-shanghai-2"
req.Port = 3306
req.InstanceRole = "dr"
#req.MasterInstanceId
req.EngineVersion = "5.6"
req.Password = "CDB@Qcloud"
req.ProtectMode = 0
req.DeployMode =0
#req.SlaveZone = "ap-guangzhou-3"
req.ParamList = [{"name":"max_connections","value":"1000"},{"name":"lower_case_table_names","value":"1"}]
req.BackupZone = "0"
req.AutoRenewFlag =0
#req.RoGroup = {"RoGroupMode":"alone","RoGroupName":"roweek"}
#req.RoGroup = {"RoGroupName":"roweek"}
#param = models.RoGroup()
#param.RoGroupMode = "alone"
#param.RoGroupName = "roweek"
#param.MinRoInGroup = 1
#req.RoGroup = [param]


#ro = [{"roGroupMode":"allinone"},{"RoGroupName":"ro_www"}]
#req.RoGroup = [ro]
req.MasterInstanceId ="cdb-bgr97hu0"
req.MasterRegion = "ap-beijing"
#roGroup = [RoGroupMode="allinone", RoGroupName="weekro",RoOfflineDelay=1,MinRoInGroup=5,MinRoInGroup=1]
#req.RoGroup = [roGroup]
req.InstanceName = "tencentcdbDR"


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.CreateDBInstance(req)
# Output the response as a json string.
print(resp.to_json_string())


except TencentCloudSDKException as err:
msg = traceback.format_exc() # Method 1
print (msg)

#CreateDBInstancedemodr()
#CreateDBInstancedemoro()
#CreateDBInstancedemomaster()


Creating a Cloud Database Instance with CreateDBInstanceHour (Pay-as-You-Go)

For hourly billing, funds must be frozen in the account. The account must have a sufficient balance. If the account balance is 0, the purchase cannot be made.
#!/usr/bin/python
# -*- coding: utf-8 -*-

# Import the TencentCloud API entry module
import logging
import traceback
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models

try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-beijing")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.CreateDBInstanceHourRequest()
req.EngineVersion = "5.6"
req.Zone = "ap-beijing-3"
req.ProjectId = 0
req.GoodsNum = 1
req.Memory = 1000
req.Volume = 50
req.InstanceRole = "master"
req.Port =3311
req.Password = "CDB@Qcloud"
req.ParamList = [{"name":"max_connections","value":"1000"},{"name":"lower_case_table_names","value":"1"}]
req.ProtectMode = 1
req.SlaveZone = "ap-beijing-3"
req.InstanceName = "oneday1"
req.AutoRenewFlag = 0


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.CreateDBInstanceHour(req)

# Output the response as a json string.
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc() # Method 1
print (msg)

Querying the Instance List with DescribeDBInstances

#!/usr/bin/python
# -*- coding: utf-8 -*-

# Import the TencentCloud API entry module
import logging
import traceback
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models

try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-shanghai")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.DescribeDBInstancesRequest()
req.EngineVersions = ["5.6"]
req.OrderBy = "instanceId"
req.InstanceIds = ["cdb-1j8lumf6"]


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.DescribeDBInstances(req)

# Output the response as a json string.
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc() # Method 1
print (msg)

Querying Database Prices with DescribeDBPrice

#!/usr/bin/python
# -*- coding: utf-8 -*-

# Import the TencentCloud API entry module
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models

try:
# Instantiate an authentication object. The input parameters must include the Tencent Cloud account secretId and secretKey.
cred = credential.Credential("secretId", "secretKey")

# Instantiate the client object for the product to be requested (using cdb as an example)
client = cdb_client.CdbClient(cred, "ap-guangzhou")

# Instantiate a request object: req = models.ModifyInstanceParamRequest()
req = models.DescribeDBPriceRequest()
req.Zone = "ap-guangzhou-3"
req.GoodsNum = 1
req.Memory =2000
req.Volume =1000
req.PayType = 'PRE_PAID'
req.Period=1


# Call the API you want to access through the client object. You need to pass in the request object.
resp = client.DescribeDBPrice(req)

# Output the response as a json string.
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)



Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback