It's all tradeoffs, with MySQL multi-master and multi-source models having their own issues and pg also has other options with their own tradoffs.

ACID+distributed== tradoffs that will always keep this a horses for courses problem.