An efficient resource sharing technique for multi-tenant databases

Abstract

Multi-tenancy is a key component of Software as a Service (SaaS) paradigm. Multi-tenant software has gained a lot of attention in academics, research and business arena. They provide scalability and economic benefits for both cloud service providers and tenants by sharing same resources and infrastructure in isolation of shared databases, network and computing resources with Service level agreement (SLA) compliances. In a multitenant scenario, active tenants compete for resources in order to access the database. If one tenant blocks up the resources, the performance of all the other tenants may be restricted and a fair sharing of the resources may be compromised. The performance of tenants must not be affected by resource-intensive activities and volatile workloads of other tenants. Moreover, the prime goal of providers is to accomplish low cost of operation, satisfying specific schemas/SLAs of each tenant. Consequently, there is a need to design and develop effective and dynamic resource sharing algorithms which can handle above mentioned issues. This work presents a model referred as Multi-Tenant Dynamic Resource Scheduling Model (MTDRSM) embracing a query classification and worker sorting technique enabling efficient and dynamic resource sharing among tenants. The experiments show significant performance improvement over existing model.

A native enhanced elastic extension tables multi-tenant database

“…Many companies desire to outsource their data to a third party which hosts a multi-tenant database system to provide the data management service with much fewer resources, through the same server instance. The main benefit of multi-tenancy is to minimize the operating costs of running software from the provider's perspective [5]. Many problems appeared while achieving this target such as lacking the tenant privileges and the long time required to perform a single query.…”