-
-
Save yomybaby/8162489b84a6f94029495adb0d1ea257 to your computer and use it in GitHub Desktop.
Automatically backup a MongoDB database to S3 using mongodump, tar, and awscli (Ubuntu 14.04 LTS) (using bitnami image)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
# Make sure to: | |
# 1) Name this file `backup.sh` and place it in /home/ubuntu | |
# 2) Run sudo apt-get install awscli to install the AWSCLI | |
# 3) Run aws configure (enter s3-authorized IAM user and specify region) | |
# 4) Fill in DB host + name | |
# 5) Create S3 bucket for the backups and fill it in below (set a lifecycle rule to expire files older than X days in the bucket) | |
# 6) Run chmod +x backup.sh | |
# 7) Test it out via ./backup.sh | |
# 8) Set up a daily backup at midnight via `crontab -e`: | |
# 0 0 * * * /home/bitnami/backup.sh > /home/bitnami/backup.log | |
# DB host (secondary preferred as to avoid impacting primary performance) | |
HOST=localhost | |
# DB name | |
DBNAME= | |
DBUSER= | |
DBPASSWORD= | |
# S3 bucket name | |
BUCKET=xxxx-db-backup | |
# Linux user account | |
USER=bitnami | |
# Current time | |
TIME=`/bin/date +%d-%m-%Y-%T` | |
# Backup directory | |
DEST=/home/$USER/tmp | |
# Tar file of backup directory | |
TAR=$DEST/../$TIME.tar | |
# Create backup dir (-p to avoid warning if already exists) | |
/bin/mkdir -p $DEST | |
# Log | |
echo "Backing up $HOST/$DBNAME to s3://$BUCKET/ on $TIME"; | |
# Dump from mongodb host into backup directory | |
/opt/bitnami/mongodb/bin/mongodump -h $HOST --password $DBPASSWORD --username $DBUSER -d $DBNAME -o $DEST --port 27017 | |
# Create tar of backup directory | |
/bin/tar cvf $TAR -C $DEST . | |
# Upload tar to s3 | |
/home/bitnami/.local/bin/aws s3 cp $TAR s3://$BUCKET/ | |
# Remove tar file locally | |
/bin/rm -f $TAR | |
# Remove backup directory | |
/bin/rm -rf $DEST | |
# All done | |
echo "Backup available at https://s3.amazonaws.com/$BUCKET/$TIME.tar" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment