API | 描述 |
CreateDBInstance | 创建云数据库实例(包年包月) |
CreateDBInstanceHour | 创建云数据库实例(按量计费) |
DescribeDBInstances | 查询实例列表 |
DescribeDBPrice | 查询数据库价格 |
CreateDBInstance 创建云数据库实例(包年包月)
#!/usr/bin/python# -*- coding: utf-8 -*-# 引入云API入口模块import loggingimport tracebackfrom tencentcloud.common import credentialfrom tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKExceptionfrom tencentcloud.cdb.v20170320 import cdb_client, models'''购买主实例'''def CreateDBInstancedemomaster():try:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretKey")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-beijing")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.CreateDBInstanceRequest()req.Memory = 2000req.Volume = 120req.Period = 1req.GoodsNum =1req.Zone = "ap-beijing-1"req.Port = 3306#req.MasterInstanceId = "cdb-7ghaiocc"req.InstanceRole = "master"req.EngineVersion = "5.6"req.Password = "CDB@Qcloud"req.ProtectMode = 0req.InstanceName = "tencentcdb"req.SecurityGroup = ["sg-eq0hvlzp"]# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.CreateDBInstance(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:msg = traceback.format_exc() # 方式1print (msg)'''购买只读实例'''def CreateDBInstancedemoro():try:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretId")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-beijing")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.CreateDBInstanceRequest()req.Memory = 2000req.Volume = 200req.Period = 1req.GoodsNum =1req.Zone = "ap-beijing-1"req.Port = 3306req.InstanceRole = "ro"req.EngineVersion = "5.6"req.Password = "CDB@Qcloud"req.ProtectMode = 0req.DeployMode =1req.GoodsNum =2req.SlaveZone = "ap-beijing-1"req.ParamList = [{"name":"max_connections","value":"1000"},{"name":"lower_case_table_names","value":"1"}]req.BackupZone = "0"req.AutoRenewFlag =0req.MasterInstanceId ="cdb-bgr97hu0"req.RoGroup = {"RoGroupMode":"allinone","RoGroupName":"roweek"}req.InstanceName = "tencentcdbRO"# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.CreateDBInstance(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:msg = traceback.format_exc() # 方式1print (msg)'''购买灾备实例'''def CreateDBInstancedemodr():try:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretKey")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-shanghai")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.CreateDBInstanceRequest()req.Memory = 4000req.Volume = 200req.Period = 1req.GoodsNum =1#req.Zone = "ap-shanghai-2"req.Port = 3306req.InstanceRole = "dr"#req.MasterInstanceIdreq.EngineVersion = "5.6"req.Password = "CDB@Qcloud"req.ProtectMode = 0req.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"# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.CreateDBInstance(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:msg = traceback.format_exc() # 方式1print (msg)#CreateDBInstancedemodr()#CreateDBInstancedemoro()#CreateDBInstancedemomaster()
CreateDBInstanceHour 创建云数据库实例(按量计费)
'''小时计费要冻结金额,需要账号有钱,如果账号余额为0,则不能购买'''#!/usr/bin/python# -*- coding: utf-8 -*-# 引入云API入口模块import loggingimport tracebackfrom tencentcloud.common import credentialfrom tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKExceptionfrom tencentcloud.cdb.v20170320 import cdb_client, modelstry:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretKey")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-beijing")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.CreateDBInstanceHourRequest()req.EngineVersion = "5.6"req.Zone = "ap-beijing-3"req.ProjectId = 0req.GoodsNum = 1req.Memory = 1000req.Volume = 50req.InstanceRole = "master"req.Port =3311req.Password = "CDB@Qcloud"req.ParamList = [{"name":"max_connections","value":"1000"},{"name":"lower_case_table_names","value":"1"}]req.ProtectMode = 1req.SlaveZone = "ap-beijing-3"req.InstanceName = "oneday1"req.AutoRenewFlag = 0# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.CreateDBInstanceHour(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:msg = traceback.format_exc() # 方式1print (msg)
DescribeDBInstances 查询实例列表
#!/usr/bin/python# -*- coding: utf-8 -*-# 引入云API入口模块import loggingimport tracebackfrom tencentcloud.common import credentialfrom tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKExceptionfrom tencentcloud.cdb.v20170320 import cdb_client, modelstry:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretKey")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-shanghai")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.DescribeDBInstancesRequest()req.EngineVersions = ["5.6"]req.OrderBy = "instanceId"req.InstanceIds = ["cdb-1j8lumf6"]# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.DescribeDBInstances(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:msg = traceback.format_exc() # 方式1print (msg)
DescribeDBPrice 查询数据库价格
#!/usr/bin/python# -*- coding: utf-8 -*-# 引入云API入口模块from tencentcloud.common import credentialfrom tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKExceptionfrom tencentcloud.cdb.v20170320 import cdb_client, modelstry:# 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKeycred = credential.Credential("secretId", "secretKey")#实例化要请求产品(以cdb为例)的client对象client = cdb_client.CdbClient(cred, "ap-guangzhou")#实例化一个请求对象:req = models.ModifyInstanceParamRequest()req = models.DescribeDBPriceRequest()req.Zone = "ap-guangzhou-3"req.GoodsNum = 1req.Memory =2000req.Volume =1000req.PayType = 'PRE_PAID'req.Period=1# 通过client对象调用想要访问的接口,需要传入请求对象resp = client.DescribeDBPrice(req)# 输出json格式的字符串回包print(resp.to_json_string())except TencentCloudSDKException as err:print(err)