Abstract
In a multi-tenant environment, the companies referred to as tenants share a common application and Relational Database Management System (RDBMS) instances to store their data. However, with the rapid adoption of multi-tenant databases, the cloud provider faces two challenges: Tenants have irregular workload patterns. Also, tenants require a strict guarantee of their rental services’ quality and performance, known as a Service Level Agreement (SLA). In this research, a Multi-Tenant Database Management System (MT DBMS) is presented. A multi-tenant migration algorithm called MT-M is presented, which migrates the violated tenants on an elastic cluster of machines to mitigate the SLA Violations. Experiment results show that the proposed MT-M algorithm is ideal for the migration of the violated multi-tenant databases, reducing SLA violations’ total number compared to the previous migration algorithms.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Tos, U., Mokadem, R., Hameurlain, A., Ayav, T., Bora, S.: A performance and profit oriented data replication strategy for cloud systems. In: 2016 International IEEE Conferences on Ubiquitous Intelligence & Computing, Advanced and Trusted Computing, Scalable Computing and Communications, Cloud and Big Data Computing, Internet of People, and Smart World Congress (UIC/ATC/ScalCom/CBDCom/IoP/SmartWorld), pp. 780–787. IEEE, Toulouse (2016)
Ni, J., Li, G., Wang, L., Feng, J., Zhang, J., Li, L.: Adaptive database schema design for multi-tenant data management. IEEE Trans. Knowl. Data Eng. 26, 2079–2093 (2013)
Floratou, A., Patel, J.M.: Replica placement in multi-tenant database environments. In: 2015, IEEE International Congress on Big Data, pp. 246–253. IEEE, New York (2015)
Ji, Y., Lin, Z., Rong, T.: AdaptiveSLA: a two-stage scheduling framework for SLA profit maximization in multi-tenant database. J. Phys: Conf. Ser. 1187, 052002 (2019)
Sakr, S., Liu, A.: Sla-based and consumer-centric dynamic provisioning for cloud databases. In: 2012 IEEE Fifth International Conference on Cloud Computing, pp. 360–367. IEEE, Honolulu (2012)
Abdel Raouf, A.E., Badr, N.L., Tolba, M.F.: Dynamic data reallocation and replication over a cloud environment. Concurrency Comput. Pract. Experience 30, e4416 (2018)
Marinho, C.S., Coutinho, E.F., Filho, J.S.C., Moreira, L.O., Sousa, F.R., Machado, J.C.: A predictive load balancing service for cloud-replicated databases. In: SBBD (Short Papers), pp. 210–215, Brazil (2017)
Sousa, F.R., Moreira, L.O., Costa Filho, J.S., Machado, J.C.: Predictive elastic replication for multi-tenant databases in the cloud. Concurrency Comput. Pract. Experience 30, e4437 (2018)
Moreira, L.O., Farias, V.A., Sousa, F.R., Santos, G.A., Maia, J.G., Machado, J.C.: Towards improvements on the quality of service for multi-tenant RDBMS in the cloud. In: 2014 IEEE 30th International Conference on Data Engineering Workshops, pp. 162–169. IEEE, Chicago (2014)
Marinho, C.S., Moreira, L.O., Coutinho, E.F., Costa Filho, J.S., Sousa, F.R., Machado, J.C.: LABAREDA: a predictive and elastic load balancing service for cloud-replicated databases. J. Inf. Data Manage. 9, 94 (2018)
Andreolini, M., Casolari, S.: Load prediction models in web-based systems. In: Proceedings of the 1st International Conference on Performance Evaluation Methodolgies and Tools, pp. 27-es. ACM, New York (2006)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2021 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Raouf, A.E.A., Abo-alian, A., Badr, N.L. (2021). Towards Improvements on Multi-tenant RDBMS Migration in the Cloud Environment. In: Hassanien, AE., Chang, KC., Mincong, T. (eds) Advanced Machine Learning Technologies and Applications. AMLTA 2021. Advances in Intelligent Systems and Computing, vol 1339. Springer, Cham. https://doi.org/10.1007/978-3-030-69717-4_56
Download citation
DOI: https://doi.org/10.1007/978-3-030-69717-4_56
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-69716-7
Online ISBN: 978-3-030-69717-4
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)