The boring question people tend to overlook is "How do I do database backup and restore?". If you did everything with distributed transactions, and had a singl

The boring question people tend to overlook is "How do I do database backup and restore?". If you did everything with distributed transactions, and had a single data store that supported it, you could have all backups be at the same transaction checkpoint. When you restored, everything would be in a consistent state. If everyone is managing their own data in different data stores, and just listening to Kafka or similar, you have to deal with the inconsistent state after a DB restore somehow.