Backup question?

Portal Home > Knowledgebase > Articles Database > Backup question?

Posted by Ricjustsaid, 01-26-2013, 09:44 PM
Hey guys, I'm just looking for suggestions on a better linux backup solution. Right now I run SQL backups every night and take full file backups of /home every week. The backups are stored on a secondary drive, and I'll download the backups to my pc a few times per month, and store copies of them on an external drive. It's a real pain, because my backups are easily 1GB in size. What I'd like to do is store my backups on a second server, just in case of a disaster (eg the drives both get fried). Preferably, I'd like the backup server to "dial in" to the server to grab the backups, just in case of a compromise. What's the best way to do this, without adding a significant increase in cost?
Posted by net, 01-26-2013, 09:53 PM
Why not get a remote backup? You can check bqbackup.com also.
Posted by TravisT-[SSS], 01-26-2013, 10:52 PM
For our clients, we set them up with rsnapshop and even configure it for hourly backups. I would look into that. It can "dial in" and we also use it for our servers.
Posted by Ricjustsaid, 01-27-2013, 02:18 AM
Is bqbackup reliable? There seem to be mixed feelings around here about it? Any other well known remote backup providers? Also, does bqbackup pull files from the server. or does the server push the files to be backed up? I guess my main concern is if a hacker manages to gain access to the server, and delete the backups just to be extra mean. If the server pushes the files, couldn't the attacker (if very determined) gain access to the remote server and remove the backups? That would require another server/VPS, wouldn't it? rsync and rsnapshot seem like good options, as long as I can find enough space (100GB would be nice) for a reasonable price.
Posted by TravisT-[SSS], 01-27-2013, 02:21 AM
Yes, it would. You could also code a PowerShell script for windows box or just setup a Linux box at home and use it to dial in and grab the backups, but rsnapshop is basically rsync just with a nice configuration on top.
Posted by Ricjustsaid, 01-28-2013, 12:04 AM
Well, I've been looking at remote backups, and I've come up with the following list: rsync.net is too expensive for the amount of space I need (I like to keep at least a month of daily backups, and a month-by-month archive for the past year, one complete backup per month). There's not much info about fxhbackup around here, besides a few recommendations. It seems like jaguarpc is having a lot of downtime lately? Steadfast and BQBackup seem like decent choices. But my main concerns are: - are they trusted? - are they reliable? - security; will my backups be safe should an attacker compromise the server being backed up? Are the backups safe on the remote server?
Posted by Zachary McClung, 01-28-2013, 12:11 AM
The downtime that we had wasn't our network, it was our upstream provider. It was a 55 Gbps DDoS which is likely to bring down most networks. That is apart of the business unfortunately. And, it was only one of our facilities which affected and that facility is limited in the number of servers we have. Things like this happens when you manage to be in business for 14 years. Our backup NAS were not affected by this outage.
Posted by colo4data, 01-28-2013, 12:31 AM
Find a DC that offers R1Soft as a back-up solution.
Posted by iskandarreza, 01-28-2013, 12:35 AM
If you're already doing backups daily and weekly on the database and files respectively, why not just get one of the cheap VPS with plenty of space and bandwidth in the offers section and rsync the backups you've already made with a script? Just a couple lines of command in a bash script set to run in cron and you're done. You could probably get it all set up in under $5 a month this way. What are you hosting on right now? A whole server/vps or a shared hosting account? I can share my backup script with you if you'd like.
Posted by cartika-andrew, 01-28-2013, 01:48 AM
bqbackup has been around a long time and have a very good track record - I wouldnt hesitate using them
Posted by Scott.Mc, 01-28-2013, 03:06 PM
Agreed you should give them a try. They simply provide you ssh/ftp on a system and you setup what you need. You should ask them if crond is available that way you can setup your own "pull" scripts.
Posted by brentedwardsgomez, 01-28-2013, 07:39 PM
You could try backupbranch.com which I highly recommend. 100gb: $14.95 200gb: $25.95 Cheapest I have found online and thus far, very reliable.
Posted by joshuayip, 01-29-2013, 01:24 AM
I am also shopping for a backup service and I came across this in the WHT offer section kerpluncdev.com - 7.00 per month for 100GB
Posted by Richard-BCS, 01-29-2013, 03:16 AM
If you are concerned about privacy, you do have the option to encrypt your backups but if you use encryption then your choices are pretty limited. The encryption key would need to be stored on the device creating the backups so you would need to push the backups to the backup server. We usually recommend clients to setup their backup task so that the backup server grabs the files from your server. That way you are protected in case anybody hacks your server but there is no way to make backups 100% secure that's why you should always have a plan B in case your plan A fails or the other way around
Posted by Ricjustsaid, 01-30-2013, 02:21 AM
BQ is at the top of my list, emailed sales on 1/28 and awaiting a reply about the use of crond. In the meanwhile, I'm still weighing my options. I'm not quite sure which would be better - a backup service, or a cheap and reliable VPS. I'm leaning towards a backup service for the sake of not having another box to manage, but that $9/mo VPS from FDC Servers is tempting (with a HDD space upgrade)! @Richard-BCS - Really nice website you have for backup-spot, looks like a solid service! So with your service, I can write a shell script to grab backups from my server?
Posted by Jag, 02-01-2013, 02:02 AM
We do, r1 doesnt exist, unless your on some EOL version. We're rolling out Idera v5 (r1sosfts new platform) and yes our costs include that, we are still grandfathered in from being an original investor of r1 before it was sold, resold, and renamed, again.
Posted by cartika-andrew, 02-01-2013, 02:21 AM
and if they were smart enough to grandfather in all of their original investors (instead of trying to enforce a 700% price increase), they still wouldnt have any competition
Posted by UH-Matt, 02-03-2013, 08:52 AM
Not to mention fix their crappy software

Add to Favourites Print this Article