Обсуждение: OT hardware recommend
Hi all. I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed. Needs to be cheap though, so linux with software raid, rack mount preferred but not required. Anyone have any experience with anything like that? $2K might be possible, painful, but possible. Suggestions? Thanks for your time, -Andy
Hi all.
I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed.
Needs to be cheap though, so linux with software raid, rack mount preferred but not required.
Anyone have any experience with anything like that? $2K might be possible, painful, but possible.
Suggestions?
Thanks for your time,
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 18/06/16 08:36, Andy Colson wrote: > Hi all. > > I have access to quite a few laptop HD's (10 to 15 of them at least), > and thought that might make a neat test box that might have some good > IO speed. > > Needs to be cheap though, so linux with software raid, rack mount > preferred but not required. > > Anyone have any experience with anything like that? $2K might be > possible, painful, but possible. > > Suggestions? > > Thanks for your time, > > -Andy > > It would be a good idea to say what country you are in, and what city (or locality). What I know about Auckland in New Zealand may not be relevant to you... :-) Cheers, Gavin
On 6/17/2016 2:33 PM, John W Higgins wrote: > http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw > > With it being 2U you can then pop out the motherboard and go with > anything more modern you wanted in terms of the motherboard/cpu/ram. I would, however, also buy a LSI/Avago SAS 9207-8i card and remove that 3ware 9750 'hardware' raid controller, which you can probably get $200 for on ebay. -- john r pierce, recycling bits in santa cruz
Hi all.
I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box that might have some good IO speed.
Needs to be cheap though, so linux with software raid, rack mount preferred but not required.
Anyone have any experience with anything like that? $2K might be possible, painful, but possible.
Suggestions?
On 18/06/16 14:23, Scott Marlowe wrote: > On Fri, Jun 17, 2016 at 2:36 PM, Andy Colson <andy@squeakycode.net > <mailto:andy@squeakycode.net>> wrote: > > Hi all. > > I have access to quite a few laptop HD's (10 to 15 of them at > least), and thought that might make a neat test box that might > have some good IO speed. > > Needs to be cheap though, so linux with software raid, rack mount > preferred but not required. > > Anyone have any experience with anything like that? $2K might be > possible, painful, but possible. > > Suggestions? > > > Sell them all and buy a couple of 800G SSDs? :) You can get 4TB SSD's now - but somewhat pricey!!! (besides, you'd still need backups)
On 06/17/2016 04:33 PM, Gavin Flower wrote: > On 18/06/16 08:36, Andy Colson wrote: >> Hi all. >> >> I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box thatmight have some good IO speed. >> >> Needs to be cheap though, so linux with software raid, rack mount preferred but not required. >> >> Anyone have any experience with anything like that? $2K might be possible, painful, but possible. >> >> Suggestions? >> >> Thanks for your time, >> >> -Andy >> >> > It would be a good idea to say what country you are in, and what city (or locality). > > What I know about Auckland in New Zealand may not be relevant to you... :-) > > > Cheers, > Gavin > > > Iowa, USA.
On 06/17/2016 09:23 PM, Scott Marlowe wrote: > On Fri, Jun 17, 2016 at 2:36 PM, Andy Colson <andy@squeakycode.net <mailto:andy@squeakycode.net>> wrote: > > Hi all. > > I have access to quite a few laptop HD's (10 to 15 of them at least), and thought that might make a neat test box thatmight have some good IO speed. > > Needs to be cheap though, so linux with software raid, rack mount preferred but not required. > > Anyone have any experience with anything like that? $2K might be possible, painful, but possible. > > Suggestions? > > > Sell them all and buy a couple of 800G SSDs? :) Gaaa.. math! Yep, had not thought about that. But do I want speed or space? How much could we sell them for? So many questions I hadnot thought about. I'd just thought, "huh, a pile of laptop drives, I'd better raid them", and not much else. We have good production boxes, so this would only be for test/play. I don't even really have a purpose, other than maybelearning something new. Thanks all for the suggestions. -Andy
On 06/17/2016 04:39 PM, John R Pierce wrote: > On 6/17/2016 2:33 PM, John W Higgins wrote: >> http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw >> >> With it being 2U you can then pop out the motherboard and go with anything more modern you wanted in terms of the motherboard/cpu/ram. > > I would, however, also buy a LSI/Avago SAS 9207-8i card and remove that 3ware 9750 'hardware' raid controller, which youcan probably get $200 for on ebay. > Thanks John and John. (Thank the John's!) Seems Like I could also get an HP D2700 off ebay pretty cheap, but I'd probably also have to buy a raid card that supportsmini-sas, and I'd have to find a computer to attach it to. Anyone with experience with those (or similar)? Any idea's if 15 5400 laptop drives in raid 10 attached to a D2700 would be performant at all? There's a pretty good chance I'll get a few more. I might get 5 more, would that make a difference? Would the Supermicro and an HP D2700 use about the same amount of power? Thanks all. -Andy
On 06/18/2016 11:52 AM, Andy Colson wrote: > On 06/17/2016 04:39 PM, John R Pierce wrote: >> On 6/17/2016 2:33 PM, John W Higgins wrote: >>> http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw >>> >>> >>> With it being 2U you can then pop out the motherboard and go with >>> anything more modern you wanted in terms of the motherboard/cpu/ram. >> >> I would, however, also buy a LSI/Avago SAS 9207-8i card and remove >> that 3ware 9750 'hardware' raid controller, which you can probably get >> $200 for on ebay. >> > > Thanks John and John. (Thank the John's!) > > Seems Like I could also get an HP D2700 off ebay pretty cheap, but I'd > probably also have to buy a raid card that supports mini-sas, and I'd > have to find a computer to attach it to. Anyone with experience with > those (or similar)? > > Any idea's if 15 5400 laptop drives in raid 10 attached to a D2700 would > be performant at all? Sure, especially if you get a caching controller and use RAID 10. That said, a single SSD will blow the doors off of it. JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them.
From: Adam Brusselback
Sent: Saturday, June 18, 2016 1:26 PM
Subject: Re: [GENERAL] OT hardware recommend
It's really amazing how much solid state drives transferred the database bottleneck away from disk.
Adam – so very true. We used to spend ungodly amounts of time/money/effort to mitigate disk performance limitations. It is almost MAGIC what SSDs do now.
Real numbers don’t lie: 5400 rpm disks can muster no more than 65 IOPS (7200s get ~90-100, 10k get 140-150). So:
15 x 65 = 975 IOPS (aka boohoo)
Using the AS SSD Benchmark, the Samsung 480gb m2 850 EVO in my core i7 laptop measures (IOPS then MB/s):
Random 4k blocks: 7,235 iops read, 14,012 iops
Random 4K-64Threads: 97,743 iops read, 68,864 iops write
Random 512B: 14,380 iops read, 19,858 iops write (db comparison here)
MB/s:
Sequential: 500 MB/s read, 449 MB/s write
Random 4K: 28.26 MB/s read, 54.74 MB/s write
4K-64Threads: 381.81 MB/s read, 269.00 MB/s write (this is closer to what db access looks like).
Access Times: 0.070 ms read, 0.050 ms write
Thusly,
1 x SSD = 14.75 times faster than a 15 drive array on reads, and 20 times faster on writes.
Like everyone else has said, just buy a 1 TB Samsung EVO 850 for $300 (USD) and call it a day. J
Mike