3 ms·
It would only fail if the host hardware failed in a way that damaged all three discs, which seems unlikely. It's for data backup, not uptime redundancy.
by mbrameld 7y ago
It would only fail if the host hardware failed in a way that damaged all three discs, which seems unlikely. It's for data backup, not uptime redundancy.
- mjard 7y agoYou never know: https://support.hpe.com/hpesc/public/docDisplay?docId=emr_na-a00092491en_us https://support.hpe.com/hpesc/public/docDisplay?docId=emr_na...
- bzzzt 7y agoA power surge caused by a lightning strike would kill your master as well as your backup. Besides that, do you also keep all your WAL logs so you can roll back an accidentally dropped database?
- megous 7y agoA power surge here where I am may kill the power supply. It's low probability that it would kill everything. Anyway, I don't fear the lightnings/storms/power surges where I am as much as I do the inevitable failures of the storage devices, or kernel bugs. This is just a part of layered protection I have. Offline backups are nice, and I have them too, but they are out of sync all the time by definition. So unless absolutely needed, having a real-time synchronized replica is much more prefered.