A Primer on Database Replication (2017)
There are solutions to this now:https://cockroachlabs.comhttps://foundationdb.orgOf course, there are still tradeoffs, but for many applications, a distributed database with strong consistency guarantees is likely to be a good choice for many projects.