Forum: VoltDB Architecture

Post: What if store procedure access multiple of data on multiple server?

What if store procedure access multiple of data on multiple server?
duydx
Feb 17, 2015
Dear all,
What if store procedure access multiple of data on multiple server, so will this transaction split to run on all of this server?
I'm looking forward to hearing from you.

Duydx
pzhao
Feb 18, 2015
Duydx,

When you develop stored procedures, you must decide if they are to be partitioned or not, in which case it will run as a multi-partition transaction. If the procedure needs to access data from all of the partitions, then you should not partition the procedure.
A multi-partition procedure invocation is executed simultaneously on all of the partitions in the cluster. One partition acts as a coordinator to merge query results from the other partitions. This is managed transparently and automatically by the database. As with all transactions in VoltDB a multi-partition transaction is an ACID transaction.

How VoltDB works/URL] is a great chapter regarding this topic.

Peter Zhao