Server Backups

We use R1Soft CDP. Great product and you can pull normal files or do an entire bare-metal-restore of your data. Great product but it does have a cost.
 
We used rsync for backing up our servers. If you are looking for a free one then rsync is good and if you are looking for a premium one then i think R1Soft is the best.
 
Hello all,

For those of you offering shared hosting, how do you guys back up your shared hosting servers? I'm currently using rsync to backup the /etc /home and /var directories, however I dont think the MySQL database is being back up.

How do you guys backup you customers MySQL Databases?

I developed a script to perform all whm/cpanel backups and ftp the backups to another server.
 
I use the backup feature in WHM/cPanel to backup to an NFS mount and also use automysqlbackup script to grab all the databases on the server mid-day to have an extra copy of every database.

For the VPS servers, I use the build in FTP backup feature in SolusVM to one of my NAS servers then rsync everything nightly offsite as well.

I like the looks of R1Soft, but I just can't justify the cost when what I've been doing for years has worked, in the heat of crunch time when a failure happens, and I am back up in a matter of hours all restored.
 
I think we're using a CRON job to back up everything (whole sites, plus databases) daily, weekly, and monthly. I've often been glad of having that backup, too!
 
You don't say which control panel you are using.

DirectAdmin is pretty good for doing backups itself, are the servers yours, or a hosts.

R1Soft is good, if you want to bare metal restore, but if you are renting, rather than co-locating your servers, then your host should be able to reinstall the OS with a KickStart server or similar.

As handsonhosting said earlier, if you rsync /var you should be getting the mysql databases as they sit in /var/lib/mysql by default.

I have some scripts for backing up your vhosts and mysql.

These are for "plesk-alike" boxes but you can change /var/ww/vhosts to /home

Backup Home Directories

#!/bin/bash

$DEST_IP=”10.10.10.10″

SOURCE_DIR=”/var/www/vhosts”
DEST_DIR=”/backups”
ARCHIVE_DIR=”archives”

clear

echo “Starting Archiving…”
echo

for i in $(find ${SOURCE_DIR} -type d -name httpdocs)
do

echo “Starting $(date)”

echo “Archiving ${i}”

echo “To ${DEST_DIR}/${ARCHIVE_DIR}/$(date +%y%m%d)$(echo ${i} | sed ‘s/\//./g’).tgz”

tar zcf ${DEST_DIR}/${ARCHIVE_DIR}/$(date +%y%m%d)$(echo ${i}| sed ‘s/\//./g’).tgz ${i}
echo “Completed $(date)”

echo

done


BACKUP MYSQL

#!/bin/bash

MYSQL_DIR=”/var/lib/mysql”

MYSQL_DUMPS=”/archives”

DB_ACCOUNT=”root”

DB_PASSWORD=”password”

echo “Dumping databases”

for i in $(find ${MYSQL_DIR} -type d -exec basename {} \;)

do

case ${i} in

test | mysql | lost+found )

echo “Skipping database: ${i}”

;;

* )

echo “Dumping database: ${i} @ $(date)”

mysqldump -u${DB_ACCOUNT} -p${DB_PASSWORD} –quick ${i} > ${MYSQL_DUMPS}/$(date +%y%m%d).${i}.sql

echo “Compressing dump of ${i} @ $(date)”

gzip ${MYSQL_DUMPS}/$(date +%y%m%d).${i}.sql

;;

esac

done

echo “Completed @ $(date)”


This might help if you are not using a control panel!
 
File Backup, SQL Server Backups and Bare Metal Restore

I have a mixture of cpanel and windows servers and I currently use jungledisk.com server edition which sits in the background and backs all clients files up every night. For databases I have it set to every 6 hours.

It retains backups for 90 days too so I can roll back/restore mysql databases and individual files. You only pay for storage and its very cheap and support Amazon S3 encrypted files etc, my monthly bill is about $50 for 2TB of data.

I found with the cpanel backup, its very resource intensive when its running and if you have a lot of sites on a server, it can take several hours to back everything up.

Jungle Disk uses around 5% cpu and does incremental backup so there is a big cpu saving there alone.

I have to say though, when you run JD first time and you have say 100GB of data on the server, it can take several days to make the first backup, after that though it takes literally minutes to run as its only backing up changed/new files.

IF YOU ARE LOOKING FOR WINDOWS BASED BACKUP FOR SQL SERVER OR BARE METAL RESTORE SOFTWARE FOR WINDOWS.....
I found this totally brilliant backup software from backupassist.com, its the best windows server backup software I think I have found yet, costs about $350 but worth every penny. I do local backups of sql databases, then send that to Amazon S3 with jungle disk. Voila, I can restore sql databases going back 3 months for all clients.

Oh...also backupassist.com software can make BARE METAL restores....for windows server this is a must have. If you have any experience in windows server you wil have in the past had to totally rebuild windows server.

I have heard lots of good things about r1Soft though but am happy with Jungle Disk and Back Up Assist.
 
You could run a shell script a little like this, to backup your databases to the filesystem and then rsync them!

#!/bin/bash

MYSQL_DIR=”/var/lib/mysql”

MYSQL_DUMPS=”/archives”

DB_ACCOUNT=”root”

DB_PASSWORD=”password”

echo “Dumping databases”

for i in $(find ${MYSQL_DIR} -type d -exec basename {} \;)

do

case ${i} in

test | mysql )

echo “Skipping database: ${i}”

;;

* )

echo “Dumping database: ${i} @ $(date)”

mysqldump -u${DB_ACCOUNT} -p${DB_PASSWORD} –quick ${i} > ${MYSQL_DUMPS}/$(date +%y%m%d).${i}.sql

echo “Compressing dump of ${i} @ $(date)”

gzip ${MYSQL_DUMPS}/$(date +%y%m%d).${i}.sql

;;

esac

done

echo “Completed @ $(date)”
 
r1soft is the only way to go. We've been using it here for 3 years without any problem.

If you're rsyncing the /var directories, and you've not changed the default path of mysql (/var/lib/mysql), then the databases ARE backing up.

Personally, I recommend getting an external server and using r1soft's CDP software - you can set it to backup every hour (like we do) or more frequently if you wanted. Your users will appreciate it too as they'll be able to log in and restore the files themselves without having to bother support. MySQL Tables they still need to contact admins to get that done, but regular files in the site they can restore an individual file or folder all on their own.

Have questions about the CDP or need a machine to do that with - drop me a Private Email, we have hundreds of licensed machines running the software.

I plan to get it, so your words are useful, thanks!
 
We use R1Soft for most services. This provides up to 30 + days of backups and full bare-metal-restores of the system should there be a total failure. Of course we take many preventative measures to ensure a bare-metal restore is never needed. R1Soft has worked very good with many of our client's dedicated servers as well. You just have to make sure you learn how to use it for example you need a special add on module to backup MySQL databases and make sure the data is good when you need it. I would recommend R1Soft.
 
We have been using BackupPC for years now with no problems at all.
We have a dedicated backup server running BackupPC exclusively and completely backing up 12 servers.
It has an amazing compression algorithm, as we have used only 47% of its disk capacity to do this.
We are very happy with this software/hardware setup.
It has saved our ... many times ;)
 
backup solution

I was also looking for a backup solution but they are expensive. I found something which could be interesting..... look at <URL snipped>. Greets!
 
R1Soft is a great option and it provides reliable continuous data protection and data recovery for hosting and data centers.
 
There is also the open source software Bacula.

I have never used it myself, but after studying their website, it looks very promising and worth trying out.
 
Back
Top