|
| 1 | +#!/bin/env python |
| 2 | +# -*- coding:utf-8 -*- |
| 3 | +# _author:kaliarch |
| 4 | + |
| 5 | +from aliyunsdkcore import client |
| 6 | +from aliyunsdkrds.request.v20140815 import CreateBackupRequest |
| 7 | +import time |
| 8 | +import os |
| 9 | +import logging |
| 10 | + |
| 11 | +class rdsOper(): |
| 12 | + def __init__(self,logger): |
| 13 | + self.clentoper = client.AcsClient('LTAIhfXlcjyln6tW','GwfAMvR4K2ELmt76184oqLTVgRfAso','cn-shanghai') |
| 14 | + self.logger = logger |
| 15 | + self.logger.info("------------------------start exec rds backup API log-------------") |
| 16 | + def backup_instance(self): |
| 17 | + # 设置参数 |
| 18 | + request = CreateBackupRequest.CreateBackupRequest() |
| 19 | + request.set_accept_format('json') |
| 20 | + request.add_query_param('DBInstanceId', 'rm-uf6xv35u1x842y61y') |
| 21 | + |
| 22 | + #如果为单库备份，可以添加DBName |
| 23 | + # request.add_query_param('DBName', 'mydb') |
| 24 | + |
| 25 | + #BackupMethod为备份方式：Logical：逻辑备份，Physical：物理备份 |
| 26 | + request.add_query_param('BackupMethod', 'Physical') |
| 27 | + #BackupType为备份类型： Auto：自动计算是全量备份还是增量备份；FullBackup：全量备份。默认值为Auto。 |
| 28 | + request.add_query_param('BackupType', 'Auto') |
| 29 | + |
| 30 | + response = self.clentoper.do_action_with_exception(request) |
| 31 | + self.logger.info("rdsbackup mission submission successful!") |
| 32 | + self.logger.info(response) |
| 33 | + print(response) |
| 34 | + |
| 35 | + |
| 36 | +class Rds_Log: |
| 37 | + def __init__(self,filename): |
| 38 | + self.filename = filename |
| 39 | + def createDir(self): |
| 40 | + _LOGDIR = os.path.join(os.path.dirname(__file__), 'rdsbackuplog') |
| 41 | + print(_LOGDIR) |
| 42 | + _TIME = time.strftime('%Y-%m-%d', time.gmtime()) + '-' |
| 43 | + _LOGNAME = _TIME + self.filename |
| 44 | + print(_LOGNAME) |
| 45 | + LOGFILENAME = os.path.join(_LOGDIR, _LOGNAME) |
| 46 | + print(LOGFILENAME) |
| 47 | + if not os.path.exists(_LOGDIR): |
| 48 | + os.mkdir(_LOGDIR) |
| 49 | + return LOGFILENAME |
| 50 | + |
| 51 | + def createlogger(self,logfilename): |
| 52 | + logger= logging.getLogger() |
| 53 | + logger.setLevel(logging.INFO) |
| 54 | + handler = logging.FileHandler(logfilename) |
| 55 | + handler.setLevel(logging.INFO) |
| 56 | + formater = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s') |
| 57 | + handler.setFormatter(formater) |
| 58 | + logger.addHandler(handler) |
| 59 | + return logger |
| 60 | + |
| 61 | +if __name__ == "__main__": |
| 62 | + glploger = Rds_Log('rdsbackup.log') |
| 63 | + logfilename = glploger.createDir() |
| 64 | + logger = glploger.createlogger(logfilename) |
| 65 | + |
| 66 | + app = rdsOper(logger) |
| 67 | + app.backup_instance() |
| 68 | + |
| 69 | + |
0 commit comments