Python脚本之RDS备份到阿里云OSS - 爱运维 | 爱运维

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

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

Shell

/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

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

/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.脚本运行前需要安装

Shell

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

1

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

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

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

运行后截图：

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

原网址: 访问
创建于: 2020-12-10 11:16:29
目录: default
标签: 无

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到

请先后发表评论
  • 最新评论
  • 总共0条评论