Bash Scripts for Automatic DOS Attack Blocking and MySQL Database Backup

1. DOS attack prevention (automatic IP blocking)

#!/bin/bash
DATE=$(date +%d/%b/%Y:%H:%M)
LOG_FILE=/usr/local/nginx/logs/demo2.access.log
ABNORMAL_IP=$(tail -n5000 $LOG_FILE |grep $DATE |awk '{a[$1]++}END{for(i in a)if(a[i]>10)print i}')
for IP in $ABNORMAL_IP; do
  if [ $(iptables -vnL |grep -c "$IP") -eq 0 ]; then
    iptables -I INPUT -s $IP -j DROP
    echo "$(date +'%F_%T') $IP" >> /tmp/drop_ip.log
  fi
done

2. MySQL database backup

#!/bin/bash
DATE=$(date +%F_%H-%M-%S)
HOST=localhost
USER=backup
PASS=123.com
BACKUP_DIR=/data/db_backup
DB_LIST=$(mysql -h$HOST -u$USER -p$PASS -s -e "show databases;" 2>/dev/null | egrep -v "Database|information_schema|mysql|performance_schema|sys")
for DB in $DB_LIST; do
  BACKUP_NAME=$BACKUP_DIR/${DB}_${DATE}.sql
  if ! mysqldump -h$HOST -u$USER -p$PASS -B $DB > $BACKUP_NAME 2>/dev/null; then
    echo "$BACKUP_NAME backup failed!"
  fi
done

---end---

If you found this article helpful, please like, view, and share to support further quality content creation.