Python脚本之RDS备份到阿里云OSS

OSS:https://www.aliyun.com/product/oss?spm=5176.10695662.1996646101.searchclickresult.188e5ad3X4byEr&accounttraceid=4643c775-71fa-4b3d-b2ee-05a5c5197fb3

脚本里面填写的信息请在阿里云相关控制面板查找：

#/usr/bin/env python
#coding:utf-8
#yum install -y python-pip.noarch && pip install --upgrade pip&&pip install oss2&&pip install requests&&pip install crcmod
#
import os,time
#MYSQL setting
MYSQLDUMP='/usr/local/mysql/bin/mysqldump'
HOST='RDS地址'
DB='数据库名字'
USER='数据库用户'
PASSWD='数据库密码'
BACKDIR='/tmp'
###oss setting
import oss2
AccessKeyId="阿里云AccessKeyId"
AccessKeySecret="阿里云AccessKeySecret"
Endpoint='https://oss-cn-qingdao.aliyuncs.com'#这是Bucket域名区域地址
Bucket='OSS  Bucket 名字'

DATE=time.strftime("%Y-%m-%d-%H-%M-%S", time.localtime())
COMMOND="%s --no-defaults -h%s -u%s -p%s -P3306 --set-gtid-purged=off --hex-blob --single-transaction --events --routines --skip-add-locks  %s|gzip>%s/%s_%s.sql.gz" %(MYSQLDUMP,HOST,USER,PASSWD,DB,BACKDIR,DB,DATE)
os_return=os.popen(COMMOND).read()
#oss update
auth = oss2.Auth(AccessKeyId, AccessKeySecret)
bucket = oss2.Bucket(auth,Endpoint, Bucket)
with open(BACKDIR+'/'+DB+'_'+DATE+'.sql.gz', 'rb') as fileobj:
    bucket.put_object(DB+'_'+DATE+'.sql.gz', fileobj)
os.popen('rm -f '+BACKDIR+'/'+DB+'_'+DATE+'.sql.gz').read()

注意点：

    1.脚本运行前需要安装

        

yum install -y python-pip.noarch && pip install --upgrade pip&&pip install oss2&&pip install requests&&pip install crcmod

    2.Endpoint是OSS的区域域名，不是你的外网访问域名

运行后截图：