Is there a way to dispatch stored procedure invocation on particular shard, based on sharding key (passed as procedure argument or somehow separately)?
For example we have a table, sharded between 3 nodes using HASH sharding strategy. All rows with key
A are stored on
node 1. I'd like to be sure that when I run
procedure(A), it applies on
We are going to use Mysql Fabric tool, but other options considered as well.