首页 > 技术文章 > 数据库定时备份 与 日志分割

huobi 2018-10-10 10:00 原文

数据库定时备份 定时任务查询:crontab -l -u root

backupDatabase=biconmgr
fileName=${backupDatabase}`date +%Y%m%d`
baseDir=/home/mysqlBackup/

mysqldump -u用户名 -p密码 ${backupDatabase} > ${baseDir}${fileName}.sql

tar -zcPvf ${baseDir}${fileName}.sql.tar.gz ${baseDir}${fileName}.sql

rm -rf ${baseDir}${fileName}.sql

find ${baseDir} -mtime +7 -name "${backupDatabase}*.tar.gz" -exec rm -rf {} \;

 

日志分割

nginx日志目录:LOGS_PATH=/usr/local/nginx/logs
nginx日志分割与删除一周前文件的shell:/usr/local/nginx/logs/nginxLogRotate.sh
定时任务:0 1 * * * /usr/local/nginx/logs/nginxLogRotate.sh

shell:
LOGS_PATH=/usr/local/nginx/logs
YESTERDAY=$(date -d "yesterday" +%Y-%m-%d)

mv ${LOGS_PATH}/access.log ${LOGS_PATH}/access_${YESTERDAY}.log
mv ${LOGS_PATH}/error.log ${LOGS_PATH}/error_${YESTERDAY}.log

kill -USR1 $(cat /usr/local/nginx/logs/nginx.pid)

find ${LOGS_PATH} -mtime +7 -name "access_*.log" -exec rm -rf {} \;
find ${LOGS_PATH} -mtime +7 -name "error_*.log" -exec rm -rf {} \;

 

tomcat日志分割

1.修改tomcat下bin目录 中的catalina.sh
修改
if [ -z "$CATALINA_OUT" ] ; then
***CATALINA_OUT="$CATALINA_BASE"/logs/catalina.out***
fi
修改为:
if [ -z "$CATALINA_OUT" ] ; then
CATALINA_OUT="$CATALINA_BASE"/logs/catalina.%Y-%m-%d.out
fi

@参考资料 https://blog.csdn.net/sunxm1992/article/details/54582222


2.删除一周之外的日志
2.1 定时任务 0 0 * * * /home/tomcat/autoDelLog47days.sh
2.2 文件内容
tBase=/home/tomcat/logs
tomcatLogCatalinaName=catalina
tomcatLogAccessName=localhost_access_log

find ${tomcatBase} -mtime +7 -name "${tomcatLogCatalinaName}*.out" -exec rm -rf {} \;
find ${tomcatBase} -mtime +7 -name "${tomcatLogAccessName}*.txt" -exec rm -rf {} \;

推荐阅读