You move over into the world of distributed transactions, which can be really expensive. Thankfully sharding works great for a large number of applications (or

You move over into the world of distributed transactions, which can be really expensive. Thankfully sharding works great for a large number of applications (or in other cases you can accept eventual consistency).