Send mysql dump to Alibaba Object Storage Service (OSS)

MySQLDumpToalibabaOSS

# -*- coding: utf-8 -*-
import oss2
import os
import subprocess
from datetime import datetime as dt

path = '/tmp/mysqldump.sql.gz'

result = subprocess.run('mysqldump --defaults-extra-file=/root/.my.cnf --single-transaction --default-character-set=utf8 --all-databases | /usr/bin/gzip > ' + path, shell=True)

auth = oss2.Auth ('アクセスキー', 'シークレットキー')
bucket = oss2.Bucket (auth, 'リージョンURL', 'バケット名')

date = dt.now().strftime('%Y%m%d')

remotefile = 'mysqldump.sql.gz.' + date

bucket.put_object_from_file(remotefile, path)

os.remove(path)