3 ms·
If you can have a secondary database (at another site or on the cloud) being updated with streaming replication, you can switch over very quickly and with littl
by forinti 1y ago
If you can have a secondary database (at another site or on the cloud) being updated with streaming replication, you can switch over very quickly and with little fuss.
- SoftTalker 1y agoWhich is what you must do if minimizing downtime is critical. And, of course, your disaster recovery plan is incomplete until you've tested it (at scale). You don't want to be looking up Postgres documentation when you need to restore from a cold backup, you want to be following the checklist you have in your recovery plan and already verified.
- zie 1y agoSure, but there are lots of failure modes where the failure goes with the streaming replication and all instances are trashed.
- bityard 1y agoThere needs to be a DBA version of the saying, "RAID is not a backup"
- lmz 1y agoJust expand RAID to "Replicas At Independent Datacenters".
- CoolCold 1y agoWhile I totally agree here, replication/raid vs backups, I must say that having some weak (in terms of HW resources) replica somewhere in the closet is much much better than system with just single master.
- forinti 1y agoIt's not, but they complement each other nicely.