MySQL Backup Cron

This will take periodic MySQL or MariaDB backups, gzip them and upload the files to Amazon S3.

This is based off of the excellent docker-mysql-backup-cron image by nickbreen, but adds additional customization options, more readable timestamps - and it's a bit easier to use, with more examples.

Configuration

Per default, the cronjob will run every 8 hours, but any of the settings can be overwritten with the following environment variables:

ACCESS_KEY=YOUR_AWS_ACCESS_KEY
SECRET_KEY=YOUR_AWS_SECRET_KEY
BUCKET=YOUR_AWS_S3_BUCKET_NAME
MYSQL_USERNAME=YOUR_MYSQL_USERNAME
MYSQL_PASSWORD=YOUR_MYSQL_PASSWORD
MYSQL_HOSTNAME=YOUR_MYSQL_HOSTNAME
DBS=DATABASE_NAME_OR_LEAVE_EMPTY_FOR_ALL_DBS
REGION=us-east-1

You can also specify multiple databases by separating them with a space:

DBS="database1 database2"

# Every 8 hours
CRON_D_BACKUP="0 1,9,17 * * * root /backup.sh | logger\n"

# Every night at 1am
CRON_D_BACKUP="0 1 * * * root /backup.sh | logger\n"

Note: The "\n" at the end of the line is required by cron to be able to recognize the job

See also .env.example

Example

docker run --rm --name=backup \
    -e ACCESS_KEY=X \
    -e SECRET_KEY=X \
    -e BUCKET=x \
    -e MYSQL_USERNAME=root \
    -e MYSQL_PASSWORD=x \
    -e MYSQL_HOSTNAME=mysql \
    -e DBS=app \
    geocodio/docker-mysql-backup-cron

You can manually test that the settings are working without waiting for the cronjob to trigger, by running docker exec -t backup /backup.sh. You should see no error messages or warnings.

Developing

# Build docker image
make build

# Push docker image
make deploy

# Run docker image (using .env file)
make run