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 have initiated AWS high I/O instance. I will like to know if MySQL will perform better with RAID0. As per the following article...

http://www.rustyrazorblade.com/2012/07/setting-up-raid0-in-ubuntu-12-04-in-aws-high-io/

With each instance you get 2x1TB of disk. 
In this tutorial I’ll be setting it up as a RAID0 to get a single 2TB disk which should deliver excellent performance.

I will like to know how much performance benefit will I get before trying to attempt it on my Instance.

share|improve this question

closed as not a real question by symcbean, voretaq7 Nov 11 '12 at 3:22

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
It's totally dependant on your workload - of which you've provided no details. –  symcbean Jul 24 '12 at 8:19
    
Maybe I have not explained my question correctly. I need to know only the performance difference between RAID-0 and not using RAID at-all. –  shantanuo Jul 24 '12 at 12:10
    
Still depends on workload. If the issue is latency then striping is not faster than a single disk. –  symcbean Jul 24 '12 at 17:58

2 Answers 2

up vote 1 down vote accepted

I don't know about AWS instances and have never used them. RAID 0 gives better IO throughput because it stripes the data across the available disk.

There is a high risk of data loss when running RAID 0, therefore RAID 10 is a preferred alternative to it. Gives you the benefit of RAID 0 with redundancy (RAID 1) but requires 2x the number of disks.

Wiki link explaining different types of RAID

share|improve this answer

I would agree with Sameer that for a database application RAID 10 is best for performance and redundancy. Here is a another good link with a good chart on RAID and typical application associated.

http://www.adaptec.com/en-us/_common/compatibility/_education/raid_level_compar_wp.htm

share|improve this answer

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