"Some summary of Ssd,fio,sas selection" Some summary of Ssd,fio,sas selection

Source: Internet
Author: User
Tags web database

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.