We will be expanding the storage for a PostgreSQL server and one of the things we are considering is using SSDs (Intel 520 Series) instead of rotating discs (10k RPM). Price per GB is comparable and we expect improved performance, however we are concerned about longevity since our database usage pattern is quite write-heavy. We are also concerned about data corruption in case of power failure (due to SSDs write cache not flushing properly).
We currently use RAID10 with 4 active HDDs (10k 146GB) and 1 spare configured in the controller. It's a HP DL380 G6 server with P410 Smart Array Controller and BBWC.
What makes more sense: upgrading the drives to 300GB 10k RPM or using Intel 520 Series SSDs (240GB)?
Best Answer
If you're using a server equipped with a Smart Array P400 controller, you're dealing with a G5-era 300-series ProLiant (DL360 G5, DL380 G5, etc.) or a G4/G5-era 500-series ProLiant (DL580, ML570). All of those systems were eclipsed in 2009 or before, so your system is several revisions behind and you're leaving performance on the table...
That said, you can use the Intel SSD's on your P400 controller. Understand that the P400 is only a 3Gb/s SAS controller.
Upgrade the controller firmware first.
They will provide some advantage on writes. Adjust your RAID controller's cache ratio to 75:25 write:read. By having a battery-backed unit (BBWC), the lack of a supercapacitor on your Intel 520 SSD is not an issue. (you'd have the same concern with spinning disks and no BBWC, right?)
Since storage space is your goal, you could also add four more 146GB disks and expand your existing array. There's a benefit there if you have the drive bays to support.
Either way, you have several options.
Edit:
Notes on SSD's and P410 controllers:
What RAID controller comes with DL360 G7?
HP P410 RAID + Samsung 830 SSDs + Debian 6.0 - What performance to expect?