Re: Reliability with RAID 10 SSD and Streaming Replication

From: Shaun Thomas <sthomas(at)optionshouse(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Tomas Vondra <tv(at)fuzzy(dot)cz>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Date: 2013-05-22 20:01:31
Message-ID: 519D241B.5080404@optionshouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 05/22/2013 02:51 PM, Merlin Moncure wrote:

> s3700 is rated for 10 drive writes/day for 5 years. so, for 200gb
> drive, that's 200gb * 10/day * 365 days * 5, that's 3.65 million
> gigabytes or ~ 3.5 petabytes.

Nice. And on that note:

http://www.tomshardware.com/reviews/ssd-dc-s3700-raid-0-benchmarks,3480.html

They actually over-saturated the backplane with 24 of these drives in a
giant RAID-0, tipping the scales at around 3.1M IOPS. Not bad for
consumer-level drives. I'd love to see a RAID-10 of these.

I'm having a hard time coming up with a database workload that would run
into performance problems with a (relatively inexpensive) setup like this.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2013-05-22 20:06:58 Re: Reliability with RAID 10 SSD and Streaming Replication
Previous Message Merlin Moncure 2013-05-22 19:51:45 Re: Reliability with RAID 10 SSD and Streaming Replication