VTGate knows both the Vschema and the schema of your tables in the backing MySQL databases.
This enables VTGate to look at the WHERE clause of the query and then route the queries to the correct shards. VTGate is also aware of the sharding metadata,
...moreTo do this you will need to use the Vitess MySQL Go client. We have a Golang compatible gRPC driver and a Java driver.
Once you have the appropriate driver you will need to add the --service_map grpc-vtgateservice VTGate flag and set the port --grpc_port.
...more