What is called the "raid" is the "redundant array of independent disks", which means "stand-alone disk array".
It was also said that "redundant array of inexpensive Drives"﹙ low-cost HDD array ﹚,
This is the full name of the initial raid technique, but it is the former that is used by more people.
raid0-performance is to combine multiple (minimum 2) hard drives into 1 logical disks, while data reads and writes to each drive simultaneously,
Different hard disks write different data, fast.
Raid1-security is the simultaneous reading and writing of 2 hard drives (same data). Emphasize the security of your data. Compare waste.
Raid5-saving is also the combination of multiple (minimum 3) hard drives into 1 logical disks, the data read and write will establish parity information,
and the parity information and the corresponding data are stored on separate disks. When a RAID5 disk data is damaged,
Use the remaining data and the corresponding parity information to recover the corrupted data. Equivalent to the synthesis of RAID0 and RAID1.
Raid10-Strong (performance + security) is RAID1+RAID0, more suitable for high speed requirements, but also complete fault tolerance, of course, ¥ is a lot of time.
A minimum of 4 hard drives (note: Do RAID10 to make RAID1, and then make a few RAID1 RAID0, so than to do RAID0 first,
To do RAID1 have higher reliability)
The differences between raid0+1 and raid1+0 are referenced below:
Http://www.hsiaoi.com/blog/?p=44
1. The disk cabinet has 14 disks of 73G, the database is 200G size including log files, how to set up the disk (to explain how the 14 disk is used)? this should be a matter of examining hardware knowledge and database physical deployment. first you need to know if these disks are to be used to hold database backup files and database performance (read/write) requirements. To determine the level of RAID. 1), if the emphasis on performance considerations, and do not have to store the database backup files, consider using raid0+1, so that the disk capacity to use is: 14*73*50%=511g. 2), if the read/write performance requirements are not high, but also relatively stingy, you can consider RAID5, so you can use the disk capacity is: 13*73=949g. As to how to use should be said database physical files of deployment. Note that tempdb,data file,log file are stored separately to reduce I/O competition. In fact, now the striped disk will automatically save the file, artificial distribution has become less important.
Server performance-Disk settings