Which raid level to use

October 14, 2010 at 23:40:58
Specs: suse 10

I want to increse my database strage as well as performance, till now we are using the single disk, but in feature it is not good enough, So I am planning to go for the RAID level data storage.
Can any one suggest me that which RAID I can use for my data storage, I am not bothering about the data looose because, we have the replication as well as backup in regular interval. So always my data will be safe.

I need to implement the RAID where I an get the more storage and better performance both read and write.


See More: Which raid level to use

Report •

October 19, 2010 at 14:08:35
I think you are barking up the wrong tree. RAID was never meant to increase performance and if you want more storage you buy another or bigger hard disk.

RAID is designed for redundancy in case of system failure. Not for any of the things you are trying to achieve.


Report •

December 16, 2010 at 15:15:09
Well, Just as StuartS said, RAID provides redundancy in the case of a failure, that's the main objective of implementing a RAID. Now, there are some side effects that may help in some way the I/O, like the multiple writing/reading heads. The faster of RAID is RAID 0, since you have no redundancy, but then if you lose one disk you will lose all the data, which it's not really very nice, so don't use it unless you're absolutely sure that you couldn't care less for the data that you will be losing.
Between the other RAID configurations, the fastest it's said to be the RAID 1+0. For example, I have heard that Microsoft recommends the use of RAID 1+0 and partitions with blocks of 64KB for datafiles and 8KB for log files SQL Server installations. What I can recommend you is to take a look at the documentation from the database engine provider, in which you will surely find some recommendation about a disk configuration that will suit your needs better.

Report •

Related Solutions

Ask Question