The easiest way to run a database is to set it up as a SPoF.
You want to be serious and set everything up with redundancy, but then in case of problems it is just too easy to mess something up by doing the wrong thing when switching back or promoting a stale replica or something.
I don't even know if there are proper hosted replicated SQL-ACID databases-as-a-service available one would consider using for financial services and similar use cases.
There seems to be merit in paying DBAs proper money to handle these things.