RDS自动备份

1、在https://help.aliyun.com/KnowledgeDetail.htm?spm=5176.2020520129.113.1.3e3246aeIR3dG5&knowledgeId=55515下载阿里云工具get_rds_backup.tar

2、将tar包上传到备份服务器中，解压得到get_rds_backup.py

# tar xvf get_rds_backup.tar 
get_rds_backup.py

3、安装Python

#yum install python

4、安装阿里云sdk

#yum install epel-release
#yum install python-pip
#pip install aliyun-python-sdk-core
#pip install aliyun-python-sdk-rds

5、下载

注：在阿里云管理平台头像下拉有accesskeys，里边有accesskeyid和accesskeysecret

#python /data/sh/get_rds_backup.py rm-2ze*** accesskeyid accesskeysecret /data/rds/

6、脚本

#vi /data/sh/rds_backup.sh
脚本内容如下：
#download rds backup files to directory
dir_name=$(date +%Y%m%d%H%M)
mkdir /data/rds/$dir_namepython /data/sh/get_rds_backup.py rm-2ze*** accesskeyid accesskeysecret /data/rds/$dir_name/
#delete x days before directory
list_alldir(){
    for file2 in `ls -a $1`
    do
        if [ x"$file2" != x"." -a x"$file2" != x".." ];then
            if [ -d "$1/$file2" ];then
                if [ $file2 -lt $dir ];then
                    rm -rf $1/$file2
                fi
            fi
        fi
    done
}
dir=$(date -d "-15 days" +%Y%m%d%H%M)
list_alldir /data/rds

#chmod +x /data/sh/rds_backup.sh

7、计划任务

#vi /etc/crontab
0 6 * * * * root /data/sh/rds_backup.sh

PS：这样子就可以在每天凌晨6点自动备份RDS数据库了

有图有真相：