RDS自動Snapshot取得シェル

credential.txt

AWSAccessKeyId=your AccessKey
AWSSecretKey=your SecretKey

rds-snapshot_prod.sh

#!/bin/sh -l

export JAVA_HOME=/usr/lib/jvm/jre
export AWS_BIN=/opt/aws/bin
export PATH=$PATH:$EC2_HOME/bin:$AWS_BIN
export EC2_REGION=ap-northeast-1
export AWS_CREDENTIAL_FILE=/opt/aws/rds/credential.txt

BACKUP_DATE=`date '+%Y%m%d'`
rds-create-db-snapshot -i YOUR DBNAME -s backup-$BACKUP_DATE

COUNT=0
# 世代をここで設定
MAX=3

for i in `rds-describe-db-snapshots | cut -f3 -d ' ' | sort -r`
do
  if [ $COUNT -ge $MAX ]
  then
    echo "DELETE:$i"
    rds-delete-db-snapshot $i -f
  fi
  COUNT=`expr $COUNT + 1`
done