Abstract
With the rapid adoption of multi-tenant databases, the cloud provider consolidates multiple tenants’ database on server machines, where the tenants share a common application and database instances. To ensure the quality of service (QoS) for the leased resources, both sides (i.e., the user and the provider) create a Service Level Agreement (SLA). Higher SLA violations result in high SLA contractual penalties and increase the possibility of losing the tenant. In addition, the unusual workload patterns of each tenant transactions require seamless adjustments due to the sudden burden changes and variability. As a result, to satisfy simultaneously availability and performance tenant requirements, it is necessary to perform reliable tenant migration and replication to distribute the workload to a flexible set of sites and avoid SLA violations. In this research, a cluster-based multi-tenant database management system (CB-MT DBMS) is proposed, which takes the migration and replication decisions in advance by monitoring and acting before the violation of the SLA occurs. In addition, a dynamic proactive multi-tenant database migration and replication MTDB-MR algorithm is proposed to reduce collisions and inconsistencies between migration and replication decisions for a group of violated tenants. Experimental results show that the proposed MTDB-MR algorithm is the ideal candidate for migration and replication of the violated multi-tenant databases, as it minimizes the total number of SLA violations, the number of multi-tenant clients SLA violations, client sites average response time and total execution time of each multi-tenant client site as compared to the previous algorithms.
Highlights
In a multi-tenant SaaS architecture, the tenants subscribe to a shared database to store their data
The OLTPBenchmark has over a decade's worth of experience in providing industry standard workloads, which is designed to produce the variable mixture, the variable rate load against any relational database
A multi-tenant database has a predominant role in hosting multiple tenants within a single DBMS with the active sharing of resources enabled
Summary
In a multi-tenant SaaS architecture, the tenants subscribe to a shared database to store their data. Performance Service Level Agreement (SLA) is an agreement between tenants and service providers, which sets the minimum performance and availability requirements for a rental service. The main requirement for the multitenant data storage system is to provide a reliable Quality of Service (QoS) for the multi-tenants by satisfying SLA agreements. It should reduce the cloud service provider operational costs, maximize the utilization of their hardware and software resources. Designing such multi-tenant cloud intelligent data storage system has several critical challenges.
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
