通过python调用阿里api定时备份阿里云RDS

发表评论
4,105

A+

需求：全量备份数据库，但是数据库比较大，如果采用mysqldump在其他机器备份会大量占用mysql，所以采用全量备份，可以采用登录RDS控制台来手动点击备份，全量备份。但是太麻烦，所以研究了阿里api文档写了python 脚本放在linux下用定时任务自动备份

说明：

1.每天最多备份10次

2.RDS必须支持全量备份（集群版都支持，单机版不支持）

python环境

py3.6

pip install aliyun-python-sdk-rds

#/usr/bin/env python
from aliyunsdkcore.client import AcsClient
from aliyunsdkcore.acs_exception.exceptions import ClientException
from aliyunsdkcore.acs_exception.exceptions import ServerException
from aliyunsdkrds.request.v20140815.CreateBackupRequest import CreateBackupRequest

from aliyunsdkcore.profile import region_provider
region_provider.modify_point('Rds', 'cn-shenzhen', 'rds.aliyuncs.com')

import json
client = AcsClient(
        "**********",
        "*************",
        "cn-shenzhen"
        )

#备份RDS
request = CreateBackupRequest()
request.set_DBInstanceId("**********")
request.set_action_name("CreateBackup")

try:
    response = client.do_action_with_exception(request)
except Exception as e:
    print(e)

#/usr/bin/env python

from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkrds.request.v20140815.CreateBackupRequest import CreateBackupRequest

from aliyunsdkcore.profile import region_provider

region_provider.modify_point('Rds', 'cn-shenzhen', 'rds.aliyuncs.com')

import json

client = AcsClient(

"**********",

"*************",

"cn-shenzhen"

)

#备份RDS

request = CreateBackupRequest()

request.set_DBInstanceId("**********")

request.set_action_name("CreateBackup")

try:

response = client.do_action_with_exception(request)

except Exception as e:

print(e)

参数说明

1.client里面AcsClient填写的参数

client = AcsClient( "<access-key-id>", "<access-key-secret>", "<region-id>")

<access-key-id><access-key-secret>是阿里云RAM编程管理的
region-id参考https://help.aliyun.com/document_detail/100865.html?spm=a2c4g.11186623.6.1362.1f4f38875goRqN下表1，如我是深圳就是cn-shenzhen

client = AcsClient( "<access-key-id>", "<access-key-secret>", "<region-id>")

<access-key-id><access-key-secret>是阿里云RAM编程管理的

region-id参考https://help.aliyun.com/document_detail/100865.html?spm=a2c4g.11186623.6.1362.1f4f38875goRqN下表1，如我是深圳就是cn-shenzhen

2.modify_point参数说明，第二个是<region-id>

region_provider.modify_point('Rds', 'cn-shenzhen', 'rds.aliyuncs.com')
region-id参考https://help.aliyun.com/document_detail/100865.html?spm=a2c4g.11186623.6.1362.1f4f38875goRqN下表1

1 2	region_provider.modify_point('Rds', 'cn-shenzhen', 'rds.aliyuncs.com') region-id参考https://help.aliyun.com/document_detail/100865.html?spm=a2c4g.11186623.6.1362.1f4f38875goRqN下表1