recently re-spread on the database, the company's core database every day IO full, in the study with SAS 16*RAID10, or RAID10 ssd*6, or FIO;
the principle, no raid-5 for database; eh; the root of all evil ;
No.2 principle, most of the time, the database does not need too high CPU, now 2 sockets are basically enough, more MySQL is not used;
No.3 principle, large memory, high IO, is the necessary condition of modern web-based database;
now the big companies have all turned to Ssd,fio;
Fio no matter from which aspect, is the absolute best choice, of course, the price is the most expensive, FIO also has built-in basic RAID function, generally do not need, also not good configuration raid, because it is based on pci-e card, so there is no way to do host-based RAID card configuration ; raid can only be done through LVM at the OS level;
the response time of FIO is the lowest; the throughput is the highest;
SSD has not run, dare not raid directly run SSD;6*200GB SSD do RAID10, capacity and price are similar to the same specifications of FIO; now it seems that the cost is relatively low;
A lot of people are saying that SSD does not go through the RAID card performance better; I totally disagree;
First, SSDs do not have a raid at all to produce use;
second, the performance of the raid card degrade, even if there is not within the scope of measure; many people comment, but no one can give performance degrade percentage; personal believe less than 10%;
third, the raid card may become a performance bottleneck, but the level of the Dell H710 RAID card is basically a bottleneck that the normal application cannot reach; H 710 theoretical limit is 150K IOPS;
SAS, as a high-performance web database, has fallen; for low-end applications or traditional enterprise applications, you can run a run;
minimum configuration, RAID10, the number of disks to go up, or can top a top; 8*200=1600 write ioPS, can read IOPS to 3000? For a MySQL, it is almost the same;
Initial decision, the core system first on the SAS RAID10, safe and heavy;
SSD and Fio on the standby; in the long run, all core systems are replaced by FIO;SSD.
*2013-08-10 Update:
* After 419,719 two times system promotion, the actual situation under update
1. MySQL in the case of version 5.5 and 5.1 + InnoDB Plugin, the use of multi-core CPU is still limited;
can not believe that the CPU uses 30%, in the absence of other bottlenecks, the system can withstand 3x pressure;
2. mysql in high-pressure situation, should run in high CPU frequency, + Flash card machine above;
3. In the case of less development ability, flash card or best solution to quickly work around many business problems;
4. Flash is the king and on the web;
"Some summary of Ssd,fio,sas selection" Some summary of Ssd,fio,sas selection