[mastachecka]

Hi guys,

I did search the forum but didn't find a matching topic. So here is my problem: I need to replace my current mysql Server configuration (HP DL380G5 w. ten 10kSAS Disks.
Performance is definitely an issue and therefore I want to use SSDs, to be more precise: Kingstons SSDNow E100, probably 4 of the 200GB model in Raid10 + 1 spare.

So, the big question is: Will the new system (DL360G7) with his integrated HP Smartarray P410i and 1GB Controller Cache limit the performance of the 4 SSDs - and if, how much? Any suggestion for another controller with better performance and linux compatibility?

Workload profile is 80% write, 20% read, 4K chunks - quite random.

I appreciate every constructive comment. Thanks in advance,

Stefan

//oh, sorry, totally wrong here. Could someone move the thread in the right subforum? thx

This post has been edited by mastachecka: 16 January 2013 - 08:33 AM

[mastachecka]

FYI: For a test setup I just purchased an LSI 9271-8i controller with 2 PNY Elite 480GB SSDs (RAID1). Initial Tests in a Workstation on Windows are looking quite good. Here are some results:

IOMETER random 4KB 80% write, 100GB Testfile (to eliminate eventual OS und Ctrl.Cache impact) , Windows/NTFS, Q-Depth=4, 4 Workers,

25863 IOPS
avg IO Resp Time 0,6ms

IOMETER random 4KB 80% read, 100GB Testfile (to eliminate eventual OS und Ctrl.Cache impact) , Windows/NTFS, Q-Depth=4, 4 Workers,

30600 IOPS
avg IO Resp Time 0,52ms

When using smaller Testfiles I get approximately 65000 IOPS, probably due to caching.