Database Backup Automation

#!/bin/bash # Backup Monitoring Script BACKUP_DIR="/backups" LOG_FILE="/var/log/backup_monitor.log" ALERT_EMAIL="admin@company.com" # Check backup success check_backup_success() { local backup_type=$1 local expected_count=$2 actual_count=$(find $BACKUP_DIR -name "*${backup_type}*" -mtime -1 | wc -l) if [ $actual_count -lt $expected_count ]; then echo "ALERT: Missing ${backup_type} backups. Expected: $expected_count, Found: $actual_count" | tee -a $LOG_FILE echo "Missing ${backup_type} backups" | mail -s "Backup Alert" $ALERT_EMAIL fi } # Check disk space check_disk_space() { usage=$(df $BACKUP_DIR | awk 'NR==2 {print $5}' | sed 's/%//') if [ $usage -gt 85 ]; then echo "ALERT: Backup disk space usage is ${usage}%" | tee -a $LOG_FILE echo "Backup disk space critical: ${usage}%" | mail -s "Disk Space Alert" $ALERT_EMAIL fi } # Check backup integrity check_backup_integrity() { local backup_file=$1 if [[ $backup_file == *.gz ]]; then if ! gzip -t $backup_file; then echo "ALERT: Corrupted backup file: $backup_file" | tee -a $LOG_FILE echo "Corrupted backup: $backup_file" | mail -s "Backup Integrity Alert" $ALERT_EMAIL fi fi } # Run checks check_backup_success "mysql_full" 1 check_backup_success "postgresql_full" 1 check_backup_success "mongodb_full" 1 check_disk_space # Check recent backups find $BACKUP_DIR -name "*_$(date +%Y%m%d)*" -exec bash -c 'check_backup_integrity "$0"' {} \;