Jumpserver高可用集群部署:(八)MariaDB及Redis数据库定时备份
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Jumpserver高可用集群部署:(八)MariaDB及Redis数据库定时备份,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2427字,纯文字阅读大概需要4分钟。
内容图文
1、编写MariaDB及Redis数据库备份脚本vi /sas/jumpserver/tools/db-backup.sh
#!/bin/bash
MariadbPath=/sas/db-backup/mariadb/
RedisPath=/sas/db-backup/redis/
SaveDays=7
echo "[$(date +"%Y-%m-%d %H:%M:%S")] ============ Start database backup task ============" &>> /var/log/db-backup.log
# mariadb backup
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Start mariadb backup task ..." &>> /var/log/db-backup.log
mysqldump -uroot -pXXXXXXXX jumpserver >$MariadbPath$(date +"%Y%m%d-%H%M%S").sql
if [ $? -eq 0 ]; then
# only delete old backup files when new backup success !
ExistBackupFiles=`ls $MariadbPath | wc -l`
if [ $ExistBackupFiles -gt $SaveDays ]; then
# only delete old backup files when exist backup files more then 7 days !
# mariadb backup files clean
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Start mariadb backup files clean task ..." &>> /var/log/db-backup.log
find $MariadbPath -type f -mtime +$SaveDays | xargs rm -rvf &>> /var/log/db-backup.log
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Mariadb backup files clean task finished ! " &>> /var/log/db-backup.log
fi
fi
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Mariadb backup task finished ! " &>> /var/log/db-backup.log
# redis backup
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Start redis backup task ..." &>> /var/log/db-backup.log
redis-cli -a xxxxxxxx SAVE &>> /var/log/db-backup.log
cp -v /ssd/redis/dump.rdb $RedisPath$(date +"%Y%m%d-%H%M%S").rdb &>> /var/log/db-backup.log
if [ $? -eq 0 ]; then
# only delete old backup files when new backup success !
ExistBackupFiles=`ls $RedisPath | wc -l`
if [ $ExistBackupFiles -gt $SaveDays ]; then
# only delete old backup files when exist backup files more then 7 days !
# redis backup files clean
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Start redis backup files clean task ..." &>> /var/log/db-backup.log
find $RedisPath -type f -mtime +$SaveDays | xargs rm -rvf &>> /var/log/db-backup.log
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Redis backup files clean task finished ! " &>> /var/log/db-backup.log
fi
fi
echo "[$(date +"%Y-%m-%d %H:%M:%S")] Redis backup task finished ! " &>> /var/log/db-backup.log
# 添加执行权限
chmod +x /sas/jumpserver/tools/db-backup.sh
2、配置计划任务
vi /etc/crontab
# database backup task
0 2 * * * root /sas/jumpserver/tools/db-backup.sh
原文:https://blog.51cto.com/dusthunter/2547213
内容总结
以上是互联网集市为您收集整理的Jumpserver高可用集群部署:(八)MariaDB及Redis数据库定时备份全部内容,希望文章能够帮你解决Jumpserver高可用集群部署:(八)MariaDB及Redis数据库定时备份所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。