Distributed systems are cool, but people I think got carried away with complexity. Hardest part here is active-active replication, but this is needed for very f

Distributed systems are cool, but people I think got carried away with complexity. Hardest part here is active-active replication, but this is needed for very few who need true 100% availability and big scaling. For majority of people active-backup setups are perfectly fine. You can also run frontend-backend mode where frontend takes care of caching, passing write to backend nodes. I run couple of systems like this and lives good. Failure of frontend node is absolutly no brainer. Failure of backend node with active-backup is also easy. You just lose last not commited and not synced transactions.