Disclaimer: I am a Vitess Maintainer. Please find my answer inline 1. You can't have single database view of all shards - Vitess does query planner and routi

Disclaimer: I am a Vitess Maintainer. Please find my answer inline 1. You can't have single database view of all shards - Vitess does query planner and routing for the application so application does not have to know about shards. Yes, Vitess gives a view of a single database. 2. No distributed ACID - This has been talked a lot feature and it is in our roadmap to provide. Currently, we have a twoPC implementation which we do not recommend for production use. Right now the users of vitess either choose their sharding key in such a way that all the queries in a transaction goes to single shard or the application can handle best effort multi shard transaction. 3. No distributed JOINs - Vitess does support distributed joins, aggregation, subqueries and other complex queries. Vitess thrive to be 100% Mysql compatible. If anyone encouter such query, a github issue helps in knowing and prioritizing.