tencent cloud

文档反馈

实例购买

最后更新时间:2023-09-13 16:04:36
    API
    描述
    CreateDBInstance
    创建云数据库实例(包年包月)
    CreateDBInstanceHour
    创建云数据库实例(按量计费)
    DescribeDBInstances
    查询实例列表
    DescribeDBPrice
    查询数据库价格

    CreateDBInstance 创建云数据库实例(包年包月)

    #!/usr/bin/python
    # -*- coding: utf-8 -*-
    
    # 引入云API入口模块
    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
    
    
    '''购买主实例'''
    def CreateDBInstancedemomaster():
    try:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = credential.Credential("secretId", "secretKey")
    
    #实例化要请求产品(以cdb为例)的client对象
    client = cdb_client.CdbClient(cred, "ap-beijing")
    
    #实例化一个请求对象: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"]
    
    
    # 通过client对象调用想要访问的接口,需要传入请求对象
    resp = client.CreateDBInstance(req)
    # 输出json格式的字符串回包
    print(resp.to_json_string())
    
    
    except TencentCloudSDKException as err:
    msg = traceback.format_exc() # 方式1
    print (msg)
    
    
    
    
    '''购买只读实例'''
    def CreateDBInstancedemoro():
    try:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = credential.Credential("secretId", "secretId")
    
    #实例化要请求产品(以cdb为例)的client对象
    client = cdb_client.CdbClient(cred, "ap-beijing")
    
    #实例化一个请求对象: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"
    
    
    # 通过client对象调用想要访问的接口,需要传入请求对象
    resp = client.CreateDBInstance(req)
    # 输出json格式的字符串回包
    print(resp.to_json_string())
    
    
    except TencentCloudSDKException as err:
    msg = traceback.format_exc() # 方式1
    print (msg)
    
    
    '''购买灾备实例'''
    def CreateDBInstancedemodr():
    try:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = credential.Credential("secretId", "secretKey")
    
    #实例化要请求产品(以cdb为例)的client对象
    client = cdb_client.CdbClient(cred, "ap-shanghai")
    
    #实例化一个请求对象: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"
    
    
    # 通过client对象调用想要访问的接口,需要传入请求对象
    resp = client.CreateDBInstance(req)
    # 输出json格式的字符串回包
    print(resp.to_json_string())
    
    
    except TencentCloudSDKException as err:
    msg = traceback.format_exc() # 方式1
    print (msg)
    
    #CreateDBInstancedemodr()
    #CreateDBInstancedemoro()
    #CreateDBInstancedemomaster()
    

    CreateDBInstanceHour 创建云数据库实例(按量计费)

    '''小时计费要冻结金额,需要账号有钱,如果账号余额为0,则不能购买'''
    #!/usr/bin/python
    # -*- coding: utf-8 -*-
    
    # 引入云API入口模块
    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:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = 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 = 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
    
    
    # 通过client对象调用想要访问的接口,需要传入请求对象
    resp = client.CreateDBInstanceHour(req)
    
    # 输出json格式的字符串回包
    print(resp.to_json_string())
    except TencentCloudSDKException as err:
    msg = traceback.format_exc() # 方式1
    print (msg)

    DescribeDBInstances 查询实例列表

    #!/usr/bin/python
    # -*- coding: utf-8 -*-
    
    # 引入云API入口模块
    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:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = 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() # 方式1
    print (msg)

    DescribeDBPrice 查询数据库价格

    #!/usr/bin/python
    # -*- coding: utf-8 -*-
    
    # 引入云API入口模块
    from tencentcloud.common import credential
    from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
    from tencentcloud.cdb.v20170320 import cdb_client, models
    
    try:
    # 实例化一个认证对象,入参需要传入腾讯云账户secretId,secretKey
    cred = 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 = 1
    req.Memory =2000
    req.Volume =1000
    req.PayType = 'PRE_PAID'
    req.Period=1
    
    
    # 通过client对象调用想要访问的接口,需要传入请求对象
    resp = client.DescribeDBPrice(req)
    
    # 输出json格式的字符串回包
    print(resp.to_json_string())
    except TencentCloudSDKException as err:
    print(err)
    
    
    联系我们

    联系我们,为您的业务提供专属服务。

    技术支持

    如果你想寻求进一步的帮助,通过工单与我们进行联络。我们提供7x24的工单服务。

    7x24 电话支持