You don't always need this at the db level. depending on your use case backups or high availability in multiple datacenters can do fine.

But then what is the recovery scenario.. the story could get hairy and complex quickly.

you either restore from your snapshot/backup of the database, or replicate from the HA node that didn't fail.

it depends on the nature of your app as to whether either of those scenarios are acceptable. the former comes with downtime.