Re: [PERFORM] Specifications for a new server

Hello,

here I am - the lonely user of JBOD :-) I use exactly what you describe below, we have a couple of Dell Servers with
batterybacked H700 controllers. On one we let the controller do a RAID10 on others I use the single disks (as you
describein useless RAID0s).  

What we do then is use those disks in a Solaris ZFS Pool as filesystem for our databases. The reason is, that with ZFS
(maybethere are other fs around there which can do this, but far back in good old Sun-times it was the only one) I can
buildup a pool and mix nearline SAS with SSDs in a neat way. ZFS has the concept of an ZFS Intent Log (ZIL), where
writesgo first before migrated to the pool - and you can put them on seperate disks. And you have the adaptive
replacementcache (ARC) you can also put on seperate disks, where hot data is cached. Now guess where we use the
expensiveSSDs. 

It boils down to this:

- slow mechanical drives backed with nvram controller
- SSD expecially for the ARC (and ZIL)
- RAM for ZFS further caching

On my very first try when ZIL and ARC approached in Solaris my first idea was just put one SSD splitted to two
partitionsas ARC and ZIL to our exisiting database. I didn't change anything else  (to be fair, that was a development
systemwith out nvram controller) - gave me a boost in performace of about 10. 

To be a bit more fair (I can, as I do not work for Sun - ehm Oracle): If this would work for someone else, the usage
patternshould be kept in mind. Also setting and tuning a Solaris server is of some more work and ZFS itself uses a good
bunchof CPU and RAM (we leave 8G for ZFS) and one would need much testing and tuning. 

A positive effect we use is for backing up data - since ZFS offers atomic snapshots, we just snapshot the filesystem.
Thedatafiles are guaranteed to be vaild as the WAL. A restore is to put the files back into place and restart Postgres
-it will run a recovery and replay the WAL and everything is done. We used that to provide back in time recovery and
warmstandby with old postgres installations before replication was included into core. 

Cheers,
Roland



> Can this nvram be used also when the configuration is
> jbod(justabunchofdisks) or some kind of raid(0/1/5/6/10 etc) is
> required to use the nvram.

That probably depends on the controller used. Some controllers (e.g.
Dell Perc H700 and such) don't even support JBOD - an easy way around
this is create single-drive RAID0 arrays (never tried it, though).

Why do you even want to use JBOD?



----------------------------------------------------------------
E-Mail-Postfach voll? Jetzt kostenlos E-Mail-Adresse @t-online.de sichern und endlich Platz für tausende E-Mails haben.
http://www.t-online.de/email-kostenlos