latest (Dockerfile) 镜像基于alpine:3.10,非常轻小!
本镜像集成mysql-client,rsync,crontab 聚合定时、数据库备份、远程文件同步于一体
简单示例如下:
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
#minute hour day month week command
0 0 * * * /usr/local/bin/backup
chmod 600 crontab
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
Content type
Image
Digest
Size
11.6 MB
Last updated
over 6 years ago
docker pull jerrydo/mysqldump