REPLICATED DATABASE DISTRIBUTION FOR WORKLOAD BALANCING AFTER CLUSTER RECONFIGURATION

摘要

A computer-implemented method for distributing a plurality of data partitions among a cluster of computer nodes includes dividing a database into a plurality of primary partitions, storing the primary partitions on a plurality of nodes associated with a computer network, duplicating the primary partitions to create a plurality of secondary partitions and storing the secondary partitions on the nodes, wherein the primary and secondary partitions are substantially evenly distributed among the nodes, each secondary partition is stored on a different node than its corresponding primary partition, diversity exists with respect to each secondary partition and the node where it is stored, the primary partitions are available to serve a system workload, and one or more secondary partitions corresponding to one or more primary partitions of a failed node are available to be upgraded to primary status to maintain workload balancing and data availability after one of the computer nodes fails.

主权项

1. A method for distributing a plurality of data partitions among a cluster of computer nodes, comprising:
dividing a database into a plurality of primary partitions; storing the primary partitions on a plurality of nodes associated with a computer network, wherein the primary partitions are substantially evenly distributed among the nodes and the primary partitions are available to serve a system workload; duplicating the primary partitions to create a plurality of secondary partitions; and storing the secondary partitions on the nodes, wherein the secondary partitions are substantially evenly distributed among the nodes, each secondary partition is stored on a different node than its corresponding primary partition, diversity exists with respect to each secondary partition and the node where it is stored, and one or more secondary partitions corresponding to one or more primary partitions of a failed node are available to be upgraded to primary status to maintain workload balancing and data availability after one of the computer nodes fails.