Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm in need to upgrade my MySQL machine, as currently I am running 2x SATA 7200rpm drives in RAID0. This of course is quite dangerous incase one of the drives fails.

As I do not need too much storage (all my db's together are about 20 - 25gb), I have been thinking about getting 2 SSD's (80 or 120gb) and putting them in RAID1 setup, so incase one of the SSD's fails, there is a backup present.

Price wise, I can also go for a RAID10 setup with 4x SATA drives. But I think 2 SSD's in RAID1 will still perform better.

For a heavily used MySQL machine, do you think the latest generation SSD's are reliable enough yet? And would this be a recommendable setup?

share|improve this question
    
1  
SSD's will inevitably fail due to write/erase cycle exhaustion. So in RAID1 setup, they'd theoretically fail at exactly the same moment. –  Berzemus Jun 27 '11 at 11:14
2  
Wouldn't that hold true for any raid level then? –  3molo Jun 27 '11 at 11:22
    
@Berzemus In theory yes; however, that is the anticipated failure. There could still be other faults where the mirror would be useful. –  Daniel Ball Jun 27 '11 at 12:46
    
My database has quite a lot of writes/deletes going on. At least 70+ writes per second to the database. Running this 24/7/365 do you think SSD's are not the way to go? I can only afford the Intel X25-M series. –  Mr.Boon Jun 27 '11 at 14:19
show 4 more comments

1 Answer

up vote 1 down vote accepted

That depends on the environment, and the disks you use. You're probably wanting to look at "Enterprise Flash Drives" rather than SSD. I would make the distinction as the longevity difference is significant.

This article discusses viability of EFDs in enterprise environments. This one discusses longevity of Seagate's "Pulsar" drive. According to Anandt's math, the 200TB version offers about 6 TB of writes before it fails, assuing 4k random read/write over 5 years. The smaller drives add up to less.

You may wish to check the comment string on Chopper 3's post in this question, he has a real world example that may be pertinent to you.

The long and short of it is that it depends on just how write-heavy your environment is. Remember that the wear on SSD/EFD drives is from writes not reads, so if people are just reading from your database, You could conceivably get 2-5 years out of your RAID.

You will get very good performance out of the raid. Switching from spinning disk to SSD has been the single most noticeable performance change in my home PC in the past two years.

share|improve this answer
    
I should also point out that RAID 1 is not a backup solution. It's a nice failsafe which will help you keep your system running through a single disk failure, but you should have a real backup (offsite is good but at least outside the server) to protect you from a catastrophic failure. –  Daniel Ball Jun 27 '11 at 13:53
    
Is TRIM possible/necessary/favorable in RAID1? –  alfish Aug 9 '11 at 23:25
    
It would certainly increase the longevity of your drives. As far as being possible, depends on your OS and drivers. It wouldn't be absolutely necessary: it'll run without it, but if the option were there I would use it. –  Daniel Ball Aug 28 '11 at 15:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.