REORGANIZATION OF DATA UNDER CONTINUOUS WORKLOAD

摘要

Architecture that provides the capability to automatically (e.g., dynamically) reorganize (repartition) an existing partition by dividing (splitting) or recombining (merging) logical databases. This reorganization can be performed to logical databases belonging to the same customer, and based on the partitioning of the tables in these databases. This can include not only splitting secondary replicas of a partition or merging secondary replicas of the partition, but also splitting off secondary replicas of the partition to create a new partition and merging two partitions into one partition. Moreover, these operations can occur while the logical databases are accepting workload (online).

主权项

1. A computer-implemented database management system, comprising:
a distributed database defined by performance parameters and having a composition of logical database units that provide online data; and a reorganization component of a replication component configured to monitor the performance parameters relative to performance limits and perform dynamic adjustment of the database composition to increase or decrease the logical database units of the composition in response to at least one change that impacts database performance, the dynamic adjustment including a split of a first logical database unit into at least a second logical database unit and a third logical database unit.