VoltDB distributes data and processing across
partitions. Other systems use the terms “shards” or “regions”. There are two steps to configuring partitioning in VoltDB.
- Tell the database how to distribute data.
- Tell the database how to route transactions to the data.
Distributing Data: Partitioned Tables
Partitioning a table is easy. Use the
PARTION TABLE DDL statement to designate the table attribute (column) that is the partitioning attribute. Each row of the table will be automatically distributed by hashing the partitioning attribute’s value to a partition. For example, if your DDL contains a table of towns, you can partition (shard) … Read more