Added by Peter Romianowski, last edited by Peter Romianowski on Mai 07, 2008  (view change)
HSCALE - MySQL Partitioning

ModulusPartitionLookup

As the name implies this partition lookup module just takes a column value and computes the modulus with a predefined value.

For non-numeric column types a simple checksum of the string value is calculated.

For detailed information take a look at the sources.

Configuration options

Option: partitionLookupModule
Value: optivo.hscale.modulusPartitionLookup
Required:
Option: tableKeyColumns
Description: A map with table name as key and column name as value. Each pair marks a partitioned table and the column that is used for partitioning.
Example: 
config.tableKeyColumns = {
    ["tbl_a"] = "category",
    ["tbl_b"] = "folder"
}
Required:
Option: partitionsPerTable
Description: The number of partitions to be used per table. (This is the modulus value).
Example: 3
Required: