API |
説明 |
ModifyInstanceParam |
インスタンスパラメータを変更する |
CloseWanService |
インスタンスのインターネットアクセスを無効にする |
OpenWanService |
インスタンスのインターネットアクセスを有効にする |
RestartDBInstances |
インスタンスを再起動する |
OpenDBInstanceGTID |
インスタンスのGTIDを有効にする |
ModifyDBInstanceName |
MySQLのインスタンス名を変更する |
ModifyDBInstanceProject |
MySQLインスタンスの所属プロジェクトを変更する |
ModifyDBInstanceVipVport |
MySQLインスタンスのIPとポート番号を変更する |
DescribeDBInstanceCharset |
MySQLインスタンスの文字セットを問い合わせする |
DescribeDBInstanceConfig |
MySQLインスタンスのコンフィグレーション情報を問い合わせする |
DescribeDBInstanceGTID |
MySQLインスタンスのGTIDが有効になっているかを問い合わせする |
DescribeDBInstanceRebootTime |
MySQLインスタンスの再起動予定時間を問い合わせする |
ModifyInstanceParam インスタンスパラメータを変更する|
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.ModifyInstanceParamRequest()
req.InstanceIds = ["cdb-1y6g3zj8","cdb-7ghaiocc"]
req.ParamList = [{"name":"max_connections","currentValue":"100"},{"name":"character_set_server","currentValue":"utf8"},{"name":"lower_case_table_names","currentValue":"1"}]
print req
resp = client.ModifyInstanceParam(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
CloseWanService インスタンスのインターネットアクセスを無効にします
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.CloseWanServiceRequest()
req.InstanceId = "cdb-1y6g3zj8"
resp = client.CloseWanService(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
OpenWanService インスタンスのインターネットアクセスを有効にします
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.OpenWanServiceRequest()
req.InstanceId = "cdb-1y6g3zj8"
resp = client.OpenWanService(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
RestartDBInstances インスタンスを再起動します
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.RestartDBInstancesRequest()
req.InstanceIds = ["cdb-7ghaiocc"]
resp = client.RestartDBInstances(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
OpenDBInstanceGTID インスタンスのGTIDを有効にします
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.OpenDBInstanceGTIDRequest()
req.InstanceId = "cdb-7ghaiocc"
resp = client.OpenDBInstanceGTID(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
ModifyDBInstanceName MySQLのインスタンス名を変更します
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.ModifyDBInstanceNameRequest()
req.InstanceId = "cdb-cukm86n2"
req.InstanceName = "1s中国語"
resp = client.ModifyDBInstanceName(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
ModifyDBInstanceProject MySQLインスタンスの所属プロジェクトを変更します
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 DescribeDBInstancesList():
try:
cred = credential.Credential("secretId", "secretKey")
client = cdb_client.CdbClient(cred, "ap-shanghai")
req = models.ModifyDBInstanceProjectRequest()
req.InstanceIds = ["cdb-7ghaiocc"]
req.NewProjectId =1
resp = client.ModifyDBInstanceProject(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
DescribeDBInstancesList()
ModifyDBInstanceVipVport MySQLインスタンスのIPとポート番号を変更します
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.ModifyDBInstanceVipVportRequest()
req.InstanceId = "cdb-7ghaiocc"
req.DstIp = "10.0.0.13"
req.DstPort =1025
req.UniqVpcId = 1111
resp = client.ModifyDBInstanceVipVport(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
msg = traceback.format_exc()
print (msg)
DescribeDBInstanceCharset MySQLインスタンスの文字セットを問い合わせします
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.DescribeDBInstanceCharsetRequest()
req.InstanceId = "cdb-1y6g3zj8"
resp = client.DescribeDBInstanceCharset(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
DescribeDBInstanceConfig MySQLインスタンスのコンフィグレーション情報を問い合わせします
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.DescribeDBInstanceConfigRequest()
req.InstanceId = "cdb-1y6g3zj8"
resp = client.DescribeDBInstanceConfig(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
DescribeDBInstanceGTID MySQLインスタンスのGTIDが有効になっているかを問い合わせします
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.DescribeDBInstanceGTIDRequest()
req.InstanceId = "cdb-1y6g3zj8"
resp = client.DescribeDBInstanceGTID(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
DescribeDBInstanceRebootTime MySQLインスタンスの再起動予定時間を問い合わせします
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.DescribeDBInstanceRebootTimeRequest()
req.InstanceIds = ["cdb-1y6g3zj8"]
resp = client.DescribeDBInstanceRebootTime(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
この記事はお役に立ちましたか?