I'm considering moving a large database from mechanical disks to SSDs. My initial instinct was to go for RAID 10, but further research suggests that this configuration can significantly reduce the random access performance of the SSDs.
The database is very much read heavy and it's generally generating large data reports, so my assumption is that there is very little by way of sequential workload.
The main alternative suggested to RAID 10 when it comes to SSDs is RAID 1. Of course, this limits me to the size of a singe disk which is, realistically, going to be less than 1TB. This is not ideal.
I guess my question is, just how significant is the random access hit and, assuming I need greater capacity than a single drive can offer, what is a good alternative? Bear in mind this is a Server 2008 box so fancy ZFS solutions or the like are, sadly, not an option.
"I'm new to this particular exchange board so perhaps I broke a rule or something with this post, but I was surprised to see a bunch of downvotes so quickly."
- Probably because you provide a piece of information that is contrary to generally accepted ideas without providing a link to a credible source or your own benchmarking results to prove it. That's like saying "Research shows that the Sun revolves around the Earth. How does this effect the estimated distance between us and other stars?" You can't just expect people to take your word that the sun revolves around the Earth, can you?