CENTREON – script de sauvegarde BDD heure par heure

clear

echo ""
echo " = = = = Sauvegarde = = = = "
echo ""

dtstring=$(date +"%A-%d")
dtbackup=$(date +"%D")
DATE_DAY=$(date +"%Y-%m-%d")
DATE_HOUR=$(date +"%H-%M")
DATE_HOURHOUR=$(date +"%H")

BACKUPFULL_DIR=/var/lib/mysql/BACKUPS
BACKUPINC_DIR=/var/lib/mysql/BACKUPS/
BACKUPINCDAY_DIR=/var/lib/mysql/BACKUPS/${DATE_HOURHOUR}
DATADIR=/var/lib/mysql/BACKUP
BACKUP_PASS=PasswOrd
BACKUP_USER=mysqlbackup

USER_ARGS=" --user=${BACKUP_USER} --password=${BACKUP_PASS}"

ARGS="--rsync $USER_ARGS --no-timestamp --parallel=10 --compress --compress-threads=4"

BACKUP_LOG=/var/lib/mysql/BACKUPS/LOGS
BACKUP_LOG_FOLDER=/var/lib/mysql/BACKUPS/LOGS/BACKUP
BACKUP_LOG_FILE=/var/lib/mysql/BACKUPS/LOGS/BACKUP/backup-${DATE_DAY}.${DATE_HOUR}.log

# Creation du repertoire de log
if [ -d ${BACKUP_LOG} ]; then
if [ -d ${BACKUP_LOG_FOLDER} ]; then
echo "-- Dossier de Logs deja existant "
echo "-- Dossier de Logs deja existant" >>${BACKUP_LOG_FILE}
fi
else
echo "-- Creation des dossiers de Logs"

mkdir ${BACKUP_LOG}
mkdir ${BACKUP_LOG_FOLDER}
fi

if [ ${DATE_HOURHOUR} = "07" ]; then
innobackupex ${ARGS} ${BACKUPFULL_DIR}/07 &>>${BACKUP_LOG_FILE}

for bf in `find ${BACKUPFULL_DIR}/07 -iname "*\.qp"`; do qpress -d $bf $(dirname $bf) ;echo "processing" $bf; rm $bf; done &>>${BACKUP_LOG_FILE}

innobackupex --apply-log --redo-only ${BACKUPFULL_DIR}/07 &>>${BACKUP_LOG_FILE}
else
innobackupex ${ARGS} --incremental ${BACKUPINCDAY_DIR} --incremental-basedir=${BACKUPFULL_DIR}/07 &>>${BACKUP_LOG_FILE}

for bf in `find ${BACKUPINCDAY_DIR} -iname "*\.qp"`; do qpress -d $bf $(dirname $bf) ;echo "processing" $bf; rm $bf; done &>>${BACKUP_LOG_FILE}
fi