real estate linux back up solution [closed]

I did a lot of research..but I couldnt find what I exactly want. Can anyone have any/some knowledge regarding how a real estate company backup strategy should be. I mean, there are different backup types such as full, incremental and differential backups.

Which solution(s) a real estate company should use to backup its resources and how frequently (daily, weekly, etc)?

assume that they have linux servers…

many thanks..

Answer

This belongs to serverfault, However you need to provide more details.

You should run incremental daily backups and a weekly fully backup.

• for MySQL databases check : http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
• for other files you can use rsync with hard copies.
• Check this TLDPhowto and LJ article
• Concider using encryption on the backup drive, either full disk using dmcrypt or if you use tar/cpio pipe it to openssl (ex : tar -xf - path1 path2 | openssl enc -aes-128-cbc -salt > backup.$(date --iso).tgz.aes

Example daily rsync backup script:

#!/bin/sh
BACKUP_DIR=/mnt/backups/
BACKUP_PATHES="/var /home"

cd ${BACKUP_DIR}
rm -rf backup.5 backup.5.log.bz2 &>/dev/null

recycle() {
    i=$1; y=$(($i+1))
    b=${2-backup}
    mv "${b}.$i" "${b}.$y" &>/dev/null
    mv "${b}.$i.log.bz2" "${b}.$y.log.bz2" &>/dev/null
}

recycle 4
recycle 3
recycle 2
recycle 1
recycle 0

OPTS="--numeric-ids --delete --delete-after --delete-excluded"
nice -n20 ionice -c2 -n2 rsync -axlHh -v --link-dest=../backup.1 ${OPTS} ${BACKUP_PATHES} backup.0/ --exclude-from=/root/.rsync-exclude 2>&1 | bzip2 -9 > backup.0.log.bz2
cd /root &>/dev/null