3 ms·
I am no expert, but are you sure that uncommitted data on the ssd is an issue? The Intel DC P3600 has a built in capacitor that should give it econoff backup p
by runarb 12y ago
I am no expert, but are you sure that uncommitted data on the ssd is an issue?
The Intel DC P3600 has a built in capacitor that should give it econoff backup power to commit the data. The SanDisk Extreme Pro disks don't have volatile cache, but instead uses SLC NAND flash for cashing, that will survive a power loss.
There is of course still the issue that data send to the server and stored in main memory will be lost if you loses power, but a HW RAID controller with battery backup would not have prevented that (but an UPS of course might).
- mrmondo 12y agoI tend to agree with you here runarb, I truly don't believe there is much that a hardware RAID contrôlée and battery will protect you from with modern flash storage, at this point I think time is better spent on improving / tuning the database and filesystem for resiliency.
- otterley 12y agoIt would definitely prevent an uncommitted data problem if fsync or O_DIRECT were used (which should always be used for critical writes). UPSes defend against power outages, but they're only one rung on the data-integrity ladder. Controller BBUs, on the other hand, protect against both power outages AND kernel panics.