alian87/mysql-backup-rclone repository overview

# Create rclone configuration volume
docker volume create rclone_config

# Configure rclone
docker run --rm -it --entrypoint bash -v rclone_config:/root/.config/rclone alian87/mysql-backup-rclone:latest

# Inside the container, run: rclone config
# ⚠️ For Google Drive authentication, you'll need rclone installed locally.
# The container will show a command like:
#   rclone authorize "drive" "eyJzY29wZSI6ImRyaXZlIn0"
# Copy the EXACT command from your terminal (each config has unique code!)
# Run the copied command on your LOCAL machine, then paste the token back.
# Install rclone locally: https://rclone.org/downloads/

docker run -d \
  --name mysql-backup \
  -e MYSQL_HOST=mysql-server \
  -e MYSQL_USER=root \
  -e MYSQL_PASSWORD=your_password \
  -e MYSQL_DATABASES=db1,db2,db3 \
  -e RCLONE_REMOTE=gdrive:backups/mysql \
  -v rclone_config:/root/.config/rclone \
  alian87/mysql-backup-rclone:latest

version: '3.8'

services:
  mysql-backup:
    image: alian87/mysql-backup-rclone:latest
    restart: unless-stopped
    environment:
      MYSQL_HOST: "mysql"
      MYSQL_PORT: 3306
      MYSQL_USER: "root"
      MYSQL_PASSWORD: "your_password"
      MYSQL_DATABASES: "db1,db2,db3"
      RCLONE_REMOTE: "gdrive:backups/mysql"
      CRON_SCHEDULE: "0 2 * * *"
      BACKUP_RETENTION: 7
      TZ: "America/Sao_Paulo"
    volumes:
      - rclone_config:/root/.config/rclone
      - backup_data:/backup
    healthcheck:
      test: ["CMD-SHELL", "test -f /var/log/cron.log && pgrep cron > /dev/null"]
      interval: 1m
      timeout: 10s
      retries: 3

volumes:
  rclone_config:
  backup_data:

docker run -d \
  -e MYSQL_HOST=mysql-server \
  -e MYSQL_DATABASES=mydb \
  -e MYSQL_PASSWORD=password \
  -v rclone_config:/root/.config/rclone \
  alian87/mysql-backup-rclone:latest

docker run -d \
  -e MYSQL_HOST=mysql-server \
  -e MYSQL_DATABASES=mydb \
  -e WEBHOOK_URL=https://hooks.slack.com/services/YOUR/WEBHOOK/URL \
  -v rclone_config:/root/.config/rclone \
  alian87/mysql-backup-rclone:latest

docker exec mysql-backup /scripts/backup.sh

# Daily at 2 AM
CRON_SCHEDULE="0 2 * * *"

# Every 6 hours
CRON_SCHEDULE="0 */6 * * *"

# Weekly on Sunday at 3 AM
CRON_SCHEDULE="0 3 * * 0"

# Monthly on the 1st at midnight
CRON_SCHEDULE="0 0 1 * *"

# Check container health
docker ps

# View health check logs
docker inspect mysql-backup | jq '.[0].State.Health'

-- Create dedicated backup user
CREATE USER 'backup_user'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON *.* TO 'backup_user'@'%';
FLUSH PRIVILEGES;