These containers can be use to schedule periodic offsite backup via kubernetes cron job functionality.

How to use: https://www.sainsmograf.com/blog/2020/05/25/setting-up-automatic-daily-database-backup-on-kubernetes/

Build

• docker buildx build -t arifwn/container-backup:mysql ./mysql/
• docker buildx build -t arifwn/container-backup:mariadb ./mariadb/
• docker build -t arifwn/container-backup:postgresql-12 ./postgresql-12/
• docker buildx build -t arifwn/container-backup:postgresql-15 ./postgresql-15/
• docker build -t arifwn/container-backup:b2 ./backblaze-b2
• docker build -t arifwn/container-backup:rsync ./rsync
• docker build -t arifwn/container-backup:clamav ./clamav

Run

• Periodically dump a MySQL database into a volume: docker run --rm --tty --interactive --volume "/volume-dir/:/dump/" --env HOST=host --env PORT=3306 --env DBNAME=dbname --env USER=root --env PASSWORD=password arifwn/container-backup:mysql

• Periodically dump ALL MySQL database into a volume: docker run --rm --tty --interactive --volume "/volume-dir/:/dump/" --env HOST=host --env PORT=3306 --env DBNAME=ALL --env USER=root --env PASSWORD=password arifwn/container-backup:mysql

• Periodically dump a Postgresql database into a volume: docker run --rm --tty --interactive --volume "/volume-dir/:/dump/" --env HOST=host --env PORT=5432 --env DBNAME=dbname --env USER=root --env PASSWORD=password arifwn/container-backup:postgresql-12

• Periodically dump ALL Postgresql database into a volume: docker run --rm --tty --interactive --volume "/volume-dir/:/dump/" --env HOST=host --env PORT=5432 --env DBNAME=ALL --env USER=root --env PASSWORD=password arifwn/container-backup:postgresql-12

• Periodically archive every files inside a volume to an external server docker run --rm --tty --interactive --volume "/volume-dir/:/source/" --env HOST=user@targetserver:/targetpath/ --env PRIVATE_KEY="$(cat ~/.ssh/id_rsa)" arifwn/container-backup:rsync

• Periodically archive every top-level folder inside a volume into a separate archive and upload it into a b2 bucket, retaining the last 7 daily backups, the last 8 weekly backups, and the last 12 monthly backups docker run --rm --tty --interactive --volume "<target dir>:/source" \ --env SYSTEM_NAME=name \ --env BUCKET_NAME=bucker \ --env B2_ACCOUNT_ID=accountid \ --env B2_API_KEY=key \ --env SOURCE_DIR=/source/ arifwn/container-backup:b2

• ClamAV

  • run server: docker run -d -p 3310:3310 --volume "/malware-definition-store:/var/lib/clamav" arifwn/container-backup:clamav
  • run scanner: docker run -it --rm --volume "/source-volume-to-scan/:/source/" --volume "/malware-definition-store:/var/lib/clamav" --env SYSTEM_NAME=system-name --env MAIL_RECIPIENTS=user@example.com --env MAILGUN_DOMAIN=mg.example.com --env MAILGUN_API_KEY="API-KEY" arifwn/container-backup:clamav /usr/bin/scan.sh