Обсуждение: HW recommendatons

So, if price were not an option and you had a system that needed to average 10K+ inserts per second what HW would you recommend? (Obviously there's mega architectural issues here)

Server?
(Dell PowerEdge 905? , HP Proliant DL700?)

Direct Attached Storage:
(Dell MD3000? HP MSA70?)

RAID/Storage array cards?

Other?

Thanks in advance

On Wed, Jun 10, 2009 at 6:19 PM, Kevin
Kempter<kevink@consistentstate.com> wrote:
> So, if price were not an option and you had a system that needed to average
> 10K+ inserts per second what HW would you recommend? (Obviously there's mega
> architectural issues here)

This really depends on how it's going to be used.  Do these inserts
need to be made to the same exact image to prevent collisions? Can
they go to multiple servers and be aggregated at a later date?  Are
you running thousands of inserts in the same transaction? couple? one?

> Server?
> (Dell PowerEdge 905? , HP Proliant DL700?)

I find their solutions kind of limited and overly expensive in the big db realm.

> Direct Attached Storage:
> (Dell MD3000? HP MSA70?)

Lots of companies make and sell JBOD solutions.  Again, I find the big
vendors tend to overcharge for storage boxes.

> RAID/Storage array cards?

Areca 1680ix w/ bbu cache

> Other?

As many hard drives and controllers as you can afford to throw at it?

On Donnerstag 11 Juni 2009 Scott Marlowe wrote:
> Areca 1680ix w/ bbu cache

Yeah, Areca rocks. http://www.areca.com.tw/

> > Other?
> As many hard drives and controllers as you can afford to throw at it?

Intel SSD, if you have the money.

We recently bought HP DL385 G5p servers with Fibre Channel, and
connected it to Infortrend FC RAID ( http://starline.de/infortrend-
eonstor-s12f-G1433-R1432/index.htm ) as you are not bound to buy HP
disks there and this is a lot cheaper than the HP MSA (the box itself is
nearly the same price, but it disk is not). Stuffed in some Fujitsu
15krpm SAS disks. Nice iron...

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4