A Primer on Database Replication (2017)
There are solutions to this now:<p><a href="https://cockroachlabs.com" rel="nofollow">https://cockroachlabs.com</a><p><a href="https://foundationdb.org" rel="nofollow">https://foundationdb.org</a><p>Of 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.