Hello,I am doing config specs for SR1625URR server, currently with 2x Xeon E5645 and 48GB RAM (using 8GB modules), with option to add another 48 using same modules. Now the tricky part is the IO, with a database/application server, this is the main performance bottleneck as long the DB indexes fit in the memory. I was checking other options such as SSD, which look like outperform SAS easily for DB transactions effectively 1SSD drive as 1 whole SAS raidWould this setup be good choice instead?
- 2-4x Intel SSD 520 (120GB) w/out any RAID (DB tablespace on each drive)
- 2x SATA 300GB/600GB in RAID1 (system, temp folders, periodic backups of the DB files on the SSD drives, lets say 1-3 hrs or any shorter interval not affecting the performance)
for RAID1 the SSD disks cant use Trim so they degrade faster, my SSD experience is limited still. I read that also Raid5/0 is nice with SSD but I would like to find some real usage feedbacks first before i set it up. From what I read that unless the SSD disk die completely due hw failure, the other fail scenario is they switch to readonly mode. Sometimes its also some temporary situation due firmware problems.
Now in case such event happens, I know how the controller would work with SAS/SATA disks, but unsure about the SSD especialy with the read only mode and raid5.
The RAID5 with SSD is safer or same/worse compared to regular disks?
I was thinking that instead going to pure SAS 15K in RAID10, I can try use hybrid setup such as SATA+SSD or SAS+SSD that can bring increased performance. So if somebody has already good RAID1 or RAID5 setups working with SSD, I would like to hear.