22

✏️ Editing: check_a2_omni_mysql_backup.sh

#!/bin/bash
#
# mysql_backup_check.sh a bash script that checks if the backup of databases defined in $MONITORED_DB were successful
# it monitors mysql backups that are created by /opt/bin/mysql_backup.sh script
# REF: SYSENG-23785
# author: mfranczak@a2hosting.com

# Comma separated list of the backups of databases we want to monitor.
MONITORED_DB="omni,supersekrit,mysql,information_schema"
# Backup location
BACKUP_LOCATION="/opt/backup/"
FAILED_BCKP=''

# Set the Internal Field Separator (IFS) to a comma
IFS=','
# Convert the variable into an array
read -ra DBS <<< "$MONITORED_DB"

# Loop through the array of monitored DBs  and echo each value separately
for DB in "${DBS[@]}"; do
  ERROR=$(find "${BACKUP_LOCATION}" -type f -name ".backup_failed_${DB}" | wc -l)
  # Alert if backup number is 0
  if [ "${ERROR}" != "0" ]; then
    if [ -z "${FAILED_BCKP}" ]; then
      FAILED_BCKP="${DB}"
    else
      FAILED_BCKP="${FAILED_BCKP}, ${DB}"
    fi
  fi
done

if [ -z "${FAILED_BCKP}" ]; then
  echo "check_a2_omni_mysql_backup.sh - mysql backups successful"
  exit 0
else
  echo "check_a2_omni_mysql_backup.sh - backup of the database ${FAILED_BCKP} failed"
  exit 2
fi

MR SKB