API |
Description |
CreateDBInstance |
Creates a TencentDB instance |
CreateDBInstanceHour |
Creates a pay-as-you-go TencentDB instance |
DescribeDBInstances |
Queries the list of instances |
DescribeDBPrice |
Queries the price of a TencentDB instance |
DescribeDBZoneConfig |
Queries the purchasable specifications of TencentDB instances |
InitDBInstances |
Initializes new instances |
CreateDBInstance for Creating a TencentDB Instance
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 a source instance'''
def CreateDBInstancedemomaster():
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-beijing")
req = models.CreateDBInstanceRequest()
req.Memory = 2000
req.Volume = 120
req.Period = 1
req.GoodsNum =1
req.Zone = "ap-beijing-1"
req.Port = 3306
req.InstanceRole = "master"
req.EngineVersion = "5.6"
req.Password = "CDB@Qcloud"
req.ProtectMode = 0
req.InstanceName = "tencentcdb"
req.SecurityGroup = ["sg-eq0hvlzp"]
resp = client.CreateDBInstance(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
'''Purchase a read-only instance'''
def CreateDBInstancedemoro():
try:
cred = credential.Credential("secretId", "secretId")
client = cdb_client.CdbClient(cred, "ap-beijing")
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"
resp = client.CreateDBInstance(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
'''Purchase a disaster recovery instance'''
def CreateDBInstancedemodr():
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-shanghai")
req = models.CreateDBInstanceRequest()
req.Memory = 4000
req.Volume = 200
req.Period = 1
req.GoodsNum =1
req.Port = 3306
req.InstanceRole = "dr"
req.EngineVersion = "5.6"
req.Password = "CDB@Qcloud"
req.ProtectMode = 0
req.DeployMode =0
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.MasterRegion = "ap-beijing"
req.InstanceName = "tencentcdbDR"
resp = client.CreateDBInstance(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
CreateDBInstanceHour for Creating a Pay-as-You-Go TencentDB Instance
'''Hourly billing requires freezing an amount in your account, so if your account balance is negative, no purchase can be made.'''
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:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-beijing")
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
resp = client.CreateDBInstanceHour(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
DescribeDBInstances for Querying the List of Instances
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:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-shanghai")
req = models.DescribeDBInstancesRequest()
req.EngineVersions = ["5.6"]
req.OrderBy = "instanceId"
req.InstanceIds = ["cdb-1j8lumf6"]
resp = client.DescribeDBInstances(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
DescribeDBPrice for Querying the Price of a TencentDB Instance
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-guangzhou")
req = models.DescribeDBPriceRequest()
req.Zone = "ap-guangzhou-3"
req.GoodsNum = 1
req.Memory =2000
req.Volume =1000
req.PayType = 'PRE_PAID'
req.Period=1
resp = client.DescribeDBPrice(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
DescribeDBZoneConfig for Querying the Purchasable Specifications of TencentDB Instances
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-shanghai")
req = models.DescribeDBZoneConfigRequest()
resp = client.DescribeDBZoneConfig(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
InitDBInstances for Initializing New Instances
from tencentcloud.common import credential
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.cdb.v20170320 import cdb_client, models
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-shanghai")
req = models.InitDBInstancesRequest()
req.InstanceIds = ["cdb-c752yqcn"]
req.NewPassword = "CDB@Qcloud"
req.Parameters = [{"name":"max_connections","value":"100"},{"name":"character_set_server","value":"utf8"},{"name":"lower_case_table_names","value":"1"}]
resp = client.InitDBInstances(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
Was this page helpful?