How common is mysql database data loss on virtual hosting? - GoFuckYourself.com

Bitchboy · 05-19-2008, 11:01 PM

My partner has some RAID setup of sorts for our main server, but I want to put test things on low cost virtual server like Servage, DreamHost, LunarPages... How big of a risk is mysql data loss? Do most of these places have RAID on their sql servers?

pussyserver - BANNED FOR LIFE · 05-19-2008, 11:06 PM

Quote:

Originally Posted by Bitchboy

My partner has some RAID setup of sorts for our main server, but I want to put test things on low cost virtual server like Servage, DreamHost, LunarPages... How big of a risk is mysql data loss? Do most of these places have RAID on their sql servers?

You are more likely to lose data due to RAID issues than mysql issues

vending_machine · 05-19-2008, 11:21 PM

Cheap hosting solutions probably will not host you on a RAID solution - and if they do, you're most likely sharing the load with a bunch of other clients.

Bottom line, the only reason you need RAID is to protect yourself from harddrive failure, which sadly happens much too often these days with cheaper drives. Only run on non-RAID if you are hosted on SCSI.. that's your best bet. Otherwise, go with RAID.

CaroMark · 05-19-2008, 11:29 PM

Your database shouldn't be anymore as risk than anything else but that said, in the world of hosting, Backup, Backup, Backup!

soukee · 05-19-2008, 11:35 PM

If your hosting provider do backups, it's OK

d-null · 05-19-2008, 11:37 PM

Quote:

Originally Posted by soukee

If your hosting provider do backups, it's OK

they will all tell you they do, if you ask, but whether they always do or not is a different matter..... bottom line is you better do it yourself

rowan · 05-20-2008, 03:21 AM

Quote:

Originally Posted by jetjet

they will all tell you they do, if you ask, but whether they always do or not is a different matter..... bottom line is you better do it yourself

Yeah, it's not the backup that's important, it's the restore.

How many times have we heard about webmasters losing the lot because a backup file "failed" ?

Iron Fist · 05-20-2008, 03:31 AM

Hosted on virtual for 4+ years and never a problem... then again, fully managed with daily backups...

Jace · 05-20-2008, 03:44 AM

I would test them out first

put a bunch of crap data on a site on a virtual host, then fill up the database...run it for 2 days, then delete everything and tell them you need a backup restored

I do this all the time, and you wouldn't believe the amount of hosts that are "premiere" in the adult industry that say "oops, sorry, we don't have any backups"

Ron Bennett · 05-20-2008, 04:34 AM

Backup is the key as others have posted already.

RAID is fine for maintaining uptime / improving performance, but it won't save you in some types of hardware / software failures...

I've seen data loss numerous times on RAID setups - folks with full, current backups get through such problems fine, those without are doubly surprised to learn that data even mirrored / striped across multiple drives can still be lost.

Be aware that open databases may not always be configured to be backed up - typically more an issue for dedicated / colo server customers ... goes to show that even higher priced server setups are no guarantee of full, reliable backups.

Good suggestion Jace about the delete everything and see if they can get it back test.

Ron

d-null · 05-20-2008, 06:52 AM

Quote:

Originally Posted by Jace

I would test them out first

put a bunch of crap data on a site on a virtual host, then fill up the database...run it for 2 days, then delete everything and tell them you need a backup restored

I do this all the time, and you wouldn't believe the amount of hosts that are "premiere" in the adult industry that say "oops, sorry, we don't have any backups"

Sosa · 05-20-2008, 08:44 AM

Quote:

Originally Posted by Jace

I would test them out first

put a bunch of crap data on a site on a virtual host, then fill up the database...run it for 2 days, then delete everything and tell them you need a backup restored

I do this all the time, and you wouldn't believe the amount of hosts that are "premiere" in the adult industry that say "oops, sorry, we don't have any backups"

I have found out that you need to ask more hosts to actually do the sql backups. Some will even run daily full backups of all your domains if you ask them.

Jace · 05-20-2008, 09:13 AM

Quote:

Originally Posted by Sosa

I have found out that you need to ask more hosts to actually do the sql backups. Some will even run daily full backups of all your domains if you ask them.

yeah, very true

I found this cool little script a while ago that does automated daily backups of your sql databases, been using it on my non-wordpress sites since I found it...it emails the backup to you every day

for wordpress I just use the automated backup plugin

05-19-2008, 11:01 PM	#1
Bitchboy Confirmed User Join Date: Jan 2006 Posts: 3,183	How common is mysql database data loss on virtual hosting? My partner has some RAID setup of sorts for our main server, but I want to put test things on low cost virtual server like Servage, DreamHost, LunarPages... How big of a risk is mysql data loss? Do most of these places have RAID on their sql servers?

05-19-2008, 11:21 PM	#3
vending_machine Confirmed User Join Date: Jun 2002 Location: Seattle Posts: 1,062	Cheap hosting solutions probably will not host you on a RAID solution - and if they do, you're most likely sharing the load with a bunch of other clients. Bottom line, the only reason you need RAID is to protect yourself from harddrive failure, which sadly happens much too often these days with cheaper drives. Only run on non-RAID if you are hosted on SCSI.. that's your best bet. Otherwise, go with RAID. __________________

05-19-2008, 11:29 PM	#4
CaroMark Confirmed User Join Date: Sep 2002 Location: Tampa, Florida Posts: 1,357	Your database shouldn't be anymore as risk than anything else but that said, in the world of hosting, Backup, Backup, Backup! __________________ Mark M, 727-433-0745 [email protected] Support is everything! ICQ# 40467849, AIM MMemmer333

05-19-2008, 11:35 PM	#5
soukee Confirmed User Join Date: Feb 2004 Location: EU Posts: 1,108	If your hosting provider do backups, it's OK __________________ I am still looking for new mature trades. Let's trade

05-20-2008, 03:31 AM	#8
Iron Fist Too lazy to set a custom title Join Date: Dec 2006 Posts: 23,400	Hosted on virtual for 4+ years and never a problem... then again, fully managed with daily backups... __________________ i like waffles

05-20-2008, 03:44 AM	#9
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	I would test them out first put a bunch of crap data on a site on a virtual host, then fill up the database...run it for 2 days, then delete everything and tell them you need a backup restored I do this all the time, and you wouldn't believe the amount of hosts that are "premiere" in the adult industry that say "oops, sorry, we don't have any backups"

05-20-2008, 04:34 AM	#10
Ron Bennett Confirmed User Join Date: Oct 2003 Posts: 1,653	Backup is the key as others have posted already. RAID is fine for maintaining uptime / improving performance, but it won't save you in some types of hardware / software failures... I've seen data loss numerous times on RAID setups - folks with full, current backups get through such problems fine, those without are doubly surprised to learn that data even mirrored / striped across multiple drives can still be lost. Be aware that open databases may not always be configured to be backed up - typically more an issue for dedicated / colo server customers ... goes to show that even higher priced server setups are no guarantee of full, reliable backups. Good suggestion Jace about the delete everything and see if they can get it back test. Ron __________________ Domagon - Website Management and Domain Name Sales