You can use the primary Vindex column to query the Vindex and discover the shard ID. Once you have determined the shard ID you can use manual shard targeting to send that specific shard a query. Note that if the query contains the primary Vindex column, or an appropriate secondary Vindex column, you do not need to do this, and vtgate can route the query automatically.
How can I know which shard contains a row for a table? Print
Created by: Marla Potterveld
Modified on: Wed, Jun 30, 2021 at 12:13 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.