LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Hardware
User Name
Password
Linux - Hardware This forum is for Hardware issues.
Having trouble installing a piece of hardware? Want to know if that peripheral is compatible with Linux?

Notices

Reply
 
Search this Thread
Old 03-14-2012, 05:52 AM   #1
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Rep: Reputation: 0
SSD raid1 vs SSD raid10 advice ?


Hello,

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 :

Setup 1
Raid 1
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)

Setup 2
Raid 10
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

420 Mb /s reading
220 Mb /s writing

What do you think ?

Thanks !

Last edited by wonker; 03-14-2012 at 05:56 AM.
 
Old 03-14-2012, 04:06 PM   #2
jefro
Guru
 
Registered: Mar 2008
Posts: 11,135

Rep: Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362Reputation: 1362
I think I'd run a single revodrive and make backups once in a while. I know they are expensive but if speed is what you want, they would provide that kind of real world numbers all day long.

Last edited by jefro; 03-14-2012 at 04:09 PM.
 
Old 03-16-2012, 05:28 AM   #3
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Original Poster
Rep: Reputation: 0
Thanks,

However, I do not have this option. I only have the option between :

2 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 300Gb
4 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 120Gb
4 drives : 300 Go SAS 15k Seagate Cheetah

I know the SSD's are faster than the 15K SAS thanks to their faster response time but I'm trying to find out which solution I should go with :

Raid 1 - 2 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 300Gb

or

Raid 10 - 4 drives : Intel SSD 320 MAINSTREAM "Postville Refresh" 120Gb
 
Old 03-16-2012, 07:11 AM   #4
cascade9
Senior Member
 
Registered: Mar 2011
Location: Brisneyland
Distribution: Debian, aptosid
Posts: 3,718

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
Quote:
Originally Posted by wonker View Post
The server will have a raid hard controller (1 Gb /s).
Either you've made a minor mistake, you you dont want SSDs. 'b' is bit, 'B' is byte. 1Gbit/sec is 125MB/sec maximum.

I'd go for RAID5 myself. Id also be getting SLC (or maybe eMLC) SSDs over MLC. Mind you, that would cost a fair amount more....but the same thing is true of SATA vs SAS.
 
Old 03-16-2012, 11:47 AM   #5
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Original Poster
Rep: Reputation: 0
Yes I meant Giga Bytes and not Giga bits…

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.
 
Old 05-22-2012, 02:42 PM   #6
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Original Poster
Rep: Reputation: 0
Raid 1 does not have the performance of Raid10 though…
 
Old 05-22-2012, 02:47 PM   #7
273
Senior Member
 
Registered: Dec 2011
Location: UK
Distribution: Debian Sid AMD64&i386, Raspbian Wheezy, various VMs
Posts: 3,230

Rep: Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759Reputation: 759
Quote:
Originally Posted by wonker View Post
Raid 1 does not have the performance of Raid10 though…
The spambot doesn't know that though.
 
Old 05-23-2012, 01:40 AM   #8
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Original Poster
Rep: Reputation: 0
Wow, I didn't know spambots were that clever…
 
Old 05-23-2012, 01:46 AM   #9
wonker
LQ Newbie
 
Registered: Jun 2005
Posts: 23

Original Poster
Rep: Reputation: 0
Just a quick note to say that in the end I will be going with a SSD drive that has double the write speed of the initial drive and only Raid1.

There were too many ambigous articles some saying yed raid10 with SSD is great and others saying no only Raid1 with SSD. So I guess it is safer to choose the faster model and only use Raid1
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SSD MystKid Linux - Hardware 1 04-05-2011 10:23 AM
SSD hydraMax Linux - Hardware 4 01-09-2011 12:09 PM
ssd slack66 Slackware 5 06-24-2010 12:56 AM
Converting existing RAID1 (where /root, /swap, /usr, and /var reside) to RAID10 the_answer_is_no Linux - Newbie 5 06-02-2008 09:17 AM
Many Raid1 vs a Raid10 humbletech99 Linux - Hardware 2 06-21-2006 07:37 AM


All times are GMT -5. The time now is 06:32 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration