Results 1 to 25 of 31
Thread: Raid 1 - is it really needed
-
04-14-2011, 01:27 AM #1Web Hosting Evangelist
- Join Date
- Mar 2009
- Posts
- 542
Raid 1 - is it really needed
I am now going to move from a vps to a dedicated server soon. My concern is if raid1 is really needed. What are the chances of having your hdd failing.
I will be hosting a forum on this new server and my budget is very tight so I dont think if I can afford the raid 1 option offered by securedservers.
-
04-14-2011, 01:30 AM #2WHT Addict
- Join Date
- Mar 2011
- Posts
- 136
Raid 1 is needed to mitigate downtime for fast data recovery. Raid shouldn't be used as a backup service, but should be used for high availability. So yes, if you are worried about downtime due to hardware related issues, some sort of disk array with parity is probably necessary--raid 1 just happens to be the fastest way to rebuild the array (I think, not sure about raid 10).
Last edited by phil29; 04-14-2011 at 01:35 AM.
Respectfully,
Phillip
-
04-14-2011, 01:33 AM #3Retired Moderator
- Join Date
- May 2006
- Location
- San Francisco
- Posts
- 7,325
Can you afford the downtime caused by a HDD failure? Software RAID1 is a pretty cheap solution - you really only have to pay for the secondary hard drive.
-
04-14-2011, 01:38 AM #4WHT Addict
- Join Date
- Mar 2011
- Posts
- 136
-
04-14-2011, 01:41 AM #5Retired Moderator
- Join Date
- May 2006
- Location
- San Francisco
- Posts
- 7,325
-
04-14-2011, 01:45 AM #6Web Hosting Master
- Join Date
- Jan 2011
- Location
- Varna, Bulgaria
- Posts
- 1,276
With todays hardware prices it is cheaper to "waste" an extra HDD and go for RAID10 instead of sacrifice performance and go for RAID5. Besides for servers used mostly for web hosting HDD write performance is very important and RAID5 is not good...
I am comparing a 3x HDD RAID5 with 4x HDD RAID10 here.
-
04-14-2011, 01:48 AM #7Web Hosting Industry Expert
- Join Date
- Dec 2007
- Location
- Indiana, USA
- Posts
- 19,196
Since the OP is comparing no raid (i.e. 1 drive) to raid1 (assumed 2 drives) I'm not sure why we're even discussing raid5, raid10, etc... I mean sure - they're better from a performance and reliability standpoint than a set of two drives in raid1 but that's not really what has been asked.
@OP: I would at the least go with Raid1 and do also have external backups - Raid1 is NOT A SUBSTITUTION FOR BACKUPS.█ Michael Denney - MDDHosting.com - Proudly hosting more than 37,700 websites since 2007.
█ Ultra-Fast Cloud Shared and Pay-By-Use Reseller Hosting Powered by LiteSpeed!
█ cPanel • Free SSL • 100% Uptime SLA • 24/7 Support
█ Class-leading support that responds in minutes, not days.
-
04-14-2011, 01:58 AM #8Web Hosting Master
- Join Date
- Jul 2007
- Location
- Tech Belt
- Posts
- 8,160
If all you're running is a forum and you don't mind taking the time to restore backups (if the hdd crashes), then don't worry about using RAID. If it's a decent sized forum and you care about downtime, then go with RAID 1 as a safety measure and should a drive die, you'll be able to replace it quicker.
Either way, always remember that hardware failure is unpredictable - even both drives can fail which is why you would also need to make sure you have some backups as well.Nothing here right now.
-
04-14-2011, 02:02 AM #9Web Hosting Industry Expert
- Join Date
- Dec 2007
- Location
- Indiana, USA
- Posts
- 19,196
Or for the sake of example - your server becomes compromised and the hacker deletes all of your databases - this would mirror to both drives in Raid1 and without backups your data would be permanently lost.
Raid + Backups is the best option if you care about reliability and data protection.█ Michael Denney - MDDHosting.com - Proudly hosting more than 37,700 websites since 2007.
█ Ultra-Fast Cloud Shared and Pay-By-Use Reseller Hosting Powered by LiteSpeed!
█ cPanel • Free SSL • 100% Uptime SLA • 24/7 Support
█ Class-leading support that responds in minutes, not days.
-
04-14-2011, 02:08 AM #10WHT Addict
- Join Date
- Mar 2011
- Posts
- 136
To sum up all of this: use raid for high availability and off-site backups for redundancy. Redundancy is a must, raid is your call.
Respectfully,
Phillip
-
04-14-2011, 02:10 AM #11Web Hosting Evangelist
- Join Date
- Mar 2009
- Posts
- 542
I guess i will have to up my budget for the RAID 1 as mike suggested.
I am actually rsyncing my files to a remote server for backup every 30 minutes. And I use mysqldump to backup my database every midnight the only problem is sometimes mysqldump takes too long to finish. Does anyone here knows how to backup a large .mysql database faster?Last edited by HypeKoder; 04-14-2011 at 02:16 AM.
-
04-14-2011, 02:21 AM #12Web Hosting Industry Expert
- Join Date
- Dec 2007
- Location
- Indiana, USA
- Posts
- 19,196
█ Michael Denney - MDDHosting.com - Proudly hosting more than 37,700 websites since 2007.
█ Ultra-Fast Cloud Shared and Pay-By-Use Reseller Hosting Powered by LiteSpeed!
█ cPanel • Free SSL • 100% Uptime SLA • 24/7 Support
█ Class-leading support that responds in minutes, not days.
-
04-14-2011, 02:29 AM #13WHT Addict
- Join Date
- Mar 2011
- Posts
- 136
I'm not sure if you want it, but I recently made a script for rsync backups that automatically reconnects if there is a disconnect and continues the transfer. Let me know and I'll post it.
Respectfully,
Phillip
-
04-14-2011, 03:21 AM #14Web Hosting Evangelist
- Join Date
- Mar 2009
- Posts
- 542
-
04-14-2011, 04:46 AM #15Web Hosting Guru
- Join Date
- Aug 2010
- Posts
- 297
Raid 1 is preferred as compared to normal HDD. Go for it
██ l Host Monsterz Pvt Ltd • Superb Support Network • DES 64 bit Secured Network
██ l Linux Shared/Reseller Hosting • Virtual Server • Dedicated Server • cPanel®
██ l Nginx • Softaculous • Fantastico • RVSite Builder • WHMCS • 24x7 Available Server Admin
██ l Premium Managed VPS • Reliable & Sustainable • Instant Setup • Raid Drives
-
04-14-2011, 04:51 AM #16Web Hosting Evangelist
- Join Date
- Apr 2009
- Posts
- 481
R1Soft MySQL is the best way. Unfortunately not free though..
-
04-14-2011, 06:05 AM #17Retired Moderator
- Join Date
- Feb 2005
- Location
- Australia
- Posts
- 5,849
If you have several large tables then you'd probably benefit from dumping each one individually. You might also want to look at mysqlhotcopy.
Chris
"Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter
-
04-14-2011, 06:13 AM #18Junior Guru
- Join Date
- Mar 2007
- Location
- United Kingdom
- Posts
- 207
This - definitely.
Talk to your hosting provider about it. They should have some suitable backup options for you.
Doing it via mysqldump / rsync is a bit inadequate! Also remember that slow backup implies slow restore as well. Obviously a slow backup restore beats no backup, but really you need to be able to restore as quickly as possible - so rsync from a slow remote network is a bit lame.
Other point is that if you use a decent backup solution you can run more frequent backups. For example just lose 1 hour of posts instead of 1 day!
An alternative you can consider/combine is to backup a replicated slave db instance.UK, Chicago, & Singapore Fully Managed Plesk VPS
UK, Arizona & Singapore Jelastic Java, PHP & Ruby PaaS
Comprehensive SLAs, backups, full SSD, rebootless kernel updates.
Experienced managed hosting provider since 2001. True 24x7 Support & Server Management
-
04-14-2011, 06:21 AM #19Junior Guru
- Join Date
- Mar 2007
- Location
- United Kingdom
- Posts
- 207
Sorry for the double post, but had to reply to this ...
You might take your backup with less disruption this way, but it's a bad idea because you will end up with an inconsistent snapshot of your data.
Imagine that you insert some rows of data into multiple tables, "joined" by a foreign key of course. You backup one of those tables before the insert, and another afterwards.
Then you have some sort of disaster, and need to restore the entire database from backup.
Now you have broken referential integrity within your database (orphaned records) - for example that might mean you have a user's posts but not the user account itself (so no username, password, email address etc. for that user). It's a big problem to deal with!
Taking a backup isn't even half of the battle. You have to be able to successfully restore the backup or it doesn't mean a thing - successful meaning that everything works properly.UK, Chicago, & Singapore Fully Managed Plesk VPS
UK, Arizona & Singapore Jelastic Java, PHP & Ruby PaaS
Comprehensive SLAs, backups, full SSD, rebootless kernel updates.
Experienced managed hosting provider since 2001. True 24x7 Support & Server Management
-
04-14-2011, 06:29 AM #20Retired Moderator
- Join Date
- Feb 2005
- Location
- Australia
- Posts
- 5,849
Chris
"Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter
-
04-14-2011, 08:09 AM #21Web Hosting Industry Expert
- Join Date
- Dec 2007
- Location
- Indiana, USA
- Posts
- 19,196
The 2.0 version of the MySQL agent works wonderful however the 3.0 version takes around 5 to 10 seconds per table so it's ok for a small server with only a few sites databases but for a shared server of any real scale it's not really usable.
We do use R1Soft + MySQL agent for our own site as it's the only site on the server and it does work well.█ Michael Denney - MDDHosting.com - Proudly hosting more than 37,700 websites since 2007.
█ Ultra-Fast Cloud Shared and Pay-By-Use Reseller Hosting Powered by LiteSpeed!
█ cPanel • Free SSL • 100% Uptime SLA • 24/7 Support
█ Class-leading support that responds in minutes, not days.
-
04-14-2011, 12:38 PM #22
You can setup a cronjob to backup MySQL databases with rsync using:
rsync -vrplogDtH /var/lib/mysql /home/MYSQL-BACKUP/
and then before doing the restore, you can Check, Repair, and Optimize all databases using:
mysqlcheck -Aor
Just one way of going about it.Last edited by HostXNow; 04-14-2011 at 12:45 PM. Reason: typo
HostXNow - Shared Web Hosting | Semi Dedicated Hosting | Enterprise Reseller Hosting | VPS Hosting
-
04-14-2011, 12:41 PM #23Web Hosting Master
- Join Date
- Jan 2011
- Location
- Varna, Bulgaria
- Posts
- 1,276
Copying a live database that is currently being written to with rsync or whatever sounds like a bad idea to me. Better to mysqldump, compress the result and copy that.
-
04-14-2011, 01:13 PM #24Junior Guru
- Join Date
- Nov 2000
- Location
- Holland
- Posts
- 246
If you are serious about MySQL backups you could setup replication just for the sake of backups (this requires at least one other server/VPS).
Setting up replication (especially if all your tables are InnoDB) is really simple and (assuming the replication is working) you always have a copy of the database that is 100% up-to-date.
To guard against hackers wiping your database (which will also get replicated!) you can (and should) also do regular mysqldump's on the backup replication slave (and because such a backup slave isn't serving any queries it doesn't matter if the backup slave then takes a few minutes to re-sync)..
-
04-14-2011, 01:21 PM #25
I doubt there would be much storage space being used just for a forum. Raid would be unnecessary if only a little storage space is being used. It doesn't take long to restore a cPanel account with a small forum.
You could just setup WebHostManager to back up the cPanel account (includes emails, forum folders/files, databases, etc), + use a cronjob to copy the cPanel backups to an offsite backup account using rsync. It would only take a few minutes to rsync the cPanel account from the offsite backup account back to the live server and restore the forum.
Raid does not cost that much extra though. If you can pay extra, get Raid too.HostXNow - Shared Web Hosting | Semi Dedicated Hosting | Enterprise Reseller Hosting | VPS Hosting
Similar Threads
-
please recommend raid 1 and raid 10 sata raid card
By joelin in forum Colocation, Data Centers, IP Space and NetworksReplies: 13Last Post: 08-14-2008, 01:28 PM -
400GB Hard Disk Drives in RAID 0, RAID 5 and RAID 10 Arrays: Performance Analysis
By donniesd in forum Hosting Security and TechnologyReplies: 0Last Post: 03-07-2007, 03:19 PM -
advice needed on SCSI RAID 0
By eL-ankebut in forum Dedicated ServerReplies: 13Last Post: 11-23-2005, 12:53 AM