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数据库了
有图有真相: