Sign inSign up

jerrydo/mysqldump

By jerrydo

Updated over 6 years ago

Image
0

235

jerrydo/mysqldump repository overview

latest (Dockerfile) 镜像基于alpine:3.10,非常轻小!

本镜像集成mysql-client,rsync,crontab 聚合定时、数据库备份、远程文件同步于一体

简单示例如下:

docker-compose.yml
version: '3'
services:
  cron:
    image: jerrydo/mysqldump
    restart: always
    volumes:
      - /home/crontab:/var/spool/cron/crontabs/root
      - /home/backup:/usr/local/bin/backup
    environment:
      MYSQL_HOST: db
      MYSQL_USER: user
      MYSQL_PASSWORD: pwd
      MYSQL_DATABASE: db
crontab
#minute hour    day     month   week    command
0       0       *       *       *       /usr/local/bin/backup

chmod 600 crontab

backup
nowdate=$(date "+%Y%m%d%H%M%S")
db_path="/home/${nowdate}-mysql.sql"
/usr/bin/mysqldump --opt -h mysql-master.middleware -u 'root' -p'123456' hxnj > $db_path
echo '本地备份完毕'
rsync --port=873 -avz --password-file=/etc/rsync.pwd $db_path [email protected]::common
echo '远程备份完毕'

chmod 777 backup

Tag summary

Content type

Image

Digest

Size

11.6 MB

Last updated

over 6 years ago

docker pull jerrydo/mysqldump