MySQL backup for Docker

A docker container to backup MySQL or MariaDB database to a S3 bucket or SFTP server.

Configuration

Create a configuration file as described in the ten7.mysql_backup Ansible role.

Once created, you have three ways to provide it to the container:

As a base64-encoded value of the MYSQL_BACKUP_CONFIG environment variable
As a mounted file at the location specified by the MYSQL_BACKUP_CONFIG_FILE environment variable
As a mounted file at /config/mysql-backup/mysql-backup.yml inside the container.

To run the Docker image as part of a script or in cron, use the following command:

docker run --rm -v /path/to/mysql-backup.yml:/config/mysql-backup/mysql-backup.yml ten7/mysql-backup

Note, that if your mysql-backup.yml file depends on other files (such as TLS keys) you will need to add multiple -v switches to mount each one.

Create the following Docker Compose file.

version: '3'
services:
  backup:
    image: ten7/mysql-backup
    volumes:
      - /path/to/mysql-backup.yml:/config/mysql-backup/mysql-backup.yml

Again, if your mysql-backup.yml depends on other files (such as TLS keys) you will need to add additional items under volumes to mount them.

Once the docker-compose.yml file is created, you can run backups using:

docker-compose run backup

GPL v3

This Docker image was created by TEN7.