How sharding works with stored procedures?
Posted by: A B
Date: April 07, 2017 03:26AM

We are going to use MySQL Fabric with Connector/J. I'm wondering, 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 node1.

Options: ReplyQuote

Written By
How sharding works with stored procedures?
April 07, 2017 03:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.