API |
説明 |
CreateDBInstance |
TencentDBインスタンスを作成します |
CreateDBInstanceHour |
TencentDBインスタンス(従量課金)を作成します |
DescribeDBInstances |
インスタンスリストのクエリーを行います |
DescribeDBPrice |
データベース料金のクエリーを行います |
DescribeDBZoneConfig |
TencentDBの販売可能な仕様を取得します |
InitDBInstances |
新規インスタンスを初期化します |
CreateDBInstance TencentDBインスタンスを作成します
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:
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)
'''読み取り専用インスタンスの購入'''
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)
'''ディザスタリカバリインスタンスの購入'''
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 TencentDBインスタンス(従量課金)を作成します
'''1時間単位の課金の場合、凍結された金額が必要で、アカウントに残額が必要です。アカウント残額が0の場合は購入できません'''
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インスタンスリストのクエリーを行います
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 データベースの価格のクエリーを行います
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 TencentDBの販売可能な仕様を取得します
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 新規インスタンスを初期化します
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)
この記事はお役に立ちましたか?