Linux - HardwareThis forum is for Hardware issues.
Having trouble installing a piece of hardware? Want to know if that peripheral is compatible with Linux?
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
I'm about to setup a mysql server and am hesitant about two different drive setups. The server will have a raid hard controller (1 Gb /s).
My supplier suggests the first one but I have seen some benchmarks that suggest that the second one would be faster :
2 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 300Gb
Maximum speeds per drive (intel site) :
Reading : 270 Mb /s
Writing : 205 Mb /s
Total setup cost : € 1,000 (499 per drive)
4 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 120Gb
Maximum seeds per drive (intel site)
Reading : 270 Mb /s
Writing : 130Mb /s
Total setup cost : € 800 (199 per drive)
Setup 2 is cheaper and the difference would allow me to get 2 SAS 1Tb drives (Raid1) for mysql logs which I have read can speed up mysql even more. (Nb : setup fees include installation, I'm not looking for other cheaper makes etc.)
I'm not sure what the speed impact of raid10 would be on small files but here is what speeds I think I could hope for (based on intels annonced speeds) on large files
Raid5 is good for a web server that has alot more reads than writes but not good for mysql. A mysql server with enough memory will perform most reads from the ram and will only create tempory tables that contain text or blob on the disk. Sadly I cannot control what queries are run and lots of them are created on disk (about 30%) even though high amounts of memory have been allowed. It is therefore important that the disk can write small files very quickly.
As for the type of memory, I don't have the option, this is going to be a rented server on which I can choose what disks from a list of disks/drives.
I have continued my search on this question and have come up with the following so far :
Raid 10 with SSD's can sometimes only have the same write performance as a Raid1. This is caused by the higher latency of the extra raid level.
In this case it is better to go for Raid 1 with a model that has a 200MB/s write speed that to have a Raid10 with 4 disks that have 130Mb/s write speed as the Raid10 write speed could be less than 150MB/s. It is also a good idea to have mechanical drives for the logs as they are cheaper than SSD's and have good sequential write speeds.
I'm thinking about getting 2 300Gb SSD's for the non sequential data and 2 SAS disks (raid1) for the logs.