PROVIDING CONSISTENT TENANT EXPERIENCES FOR MULTI-TENANT DATABASES

摘要

The present invention extends to methods, systems, and computer program products for providing consistent tenant experiences at multi-tenant database. Embodiments of the invention include an import service that facilitates data imports without any distribution logic on a tenant. A tenant (caller) provides data in essentially any order. The import service understands the distribution of data across multiple databases and determines for any given piece of import data what database the import data is to be inserted into. Accordingly, the tenant (caller) is relieved from having to know how the data is distributed across a set (of potentially hundreds or thousands) of databases. The import service can optimize an import process to provide load balancing and fairness across a dynamic distributed database system. For example, the import service can insure that a large import by one tenant does not deprive the import other tenants of appropriate resources.

主权项

1. An apparatus for dynamic load allocation in a multi-tenant distributed database, comprising:
memory configured to store a mapping scheme, wherein the mapping scheme contains information associating a first tenant with a first database of the distributed system and a second tenant with a second database of a distributed system; a scheduler configured to initiate import of a first data portion associated with a first tenant into the first database in accordance with the mapping scheme; and a resource manager configured to:
reallocate bandwidth by initiating a suspend command to the scheduler to suspend importation of the first data portion in accordance with a fairness scheme; andissue a command to the scheduler to schedule import of a second data portion associated with the second tenant into the second database in accordance with the mapping scheme.