[lurkerasdfh8]

Even if the author assumptions are true and valid, this is like saying mirroring RAID is a safe backup option :)

it is not. if you have 10 DB hosts with the same brand of nvme, and they fail under a workload, what good is it that you have 10 hot-hot failover hosts? you just bought yourself a few days, or hours if you are specially unlucky and using consumer grade.

[tyingq]

Yep. Mirroring happily mirrors mistakes very well, and very quickly.

[alisonkisk]

Replication also replicates mistakes.

[isotopp]

Correct.

For that you have time delayed replicas and of course backups. But time delayed replicas are usually much faster to restore than a backup.