It is important to choose a strong sharding key aka primary Vindex when creating your VSchema, so the qualities you should look at are the following:
Frequency in WHERE clause of queries Uniqueness (of the mapping function) This means that a vindex will
...moreVitess provides a CLI command ApplyVSchema to make updates to the vschema within Vitess.
...moreThere are a couple of special cases for when you don’t have a VSchema in place.
For example, if you add a table called foo to an unsharded keyspace called ks1 the following routing will enable you to access the table:
use ks1; select * from foo; From the
...more