A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment

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 use...

Descripción completa

Guardado en:

Detalles Bibliográficos
Autores principales:	Ahmed E. Abdel Raouf, Alshaimaa Abo-Alian, Nagwa L. Badr
Formato:	article
Lenguaje:	EN
Publicado:	IEEE 2021
Materias:	Cloud computing data migration data replication service level agreements SLA TPC benchmarks Electrical engineering. Electronics. Nuclear engineering TK1-9971
Acceso en línea:	https://doaj.org/article/2ae0fbffcf484ed394d8c58239cebad4
Etiquetas:	Agregar Etiqueta Sin Etiquetas, Sea el primero en etiquetar este registro!

id	oai:doaj.org-article:2ae0fbffcf484ed394d8c58239cebad4
record_format	dspace
spelling	oai:doaj.org-article:2ae0fbffcf484ed394d8c58239cebad42021-11-18T00:01:03ZA Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment2169-353610.1109/ACCESS.2021.3126582https://doaj.org/article/2ae0fbffcf484ed394d8c58239cebad42021-01-01T00:00:00Zhttps://ieeexplore.ieee.org/document/9606820/https://doaj.org/toc/2169-3536With 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.Ahmed E. Abdel RaoufAlshaimaa Abo-AlianNagwa L. BadrIEEEarticleCloud computingdata migrationdata replicationservice level agreements SLATPC benchmarksElectrical engineering. Electronics. Nuclear engineeringTK1-9971ENIEEE Access, Vol 9, Pp 152015-152031 (2021)
institution	DOAJ
collection	DOAJ
language	EN
topic	Cloud computing data migration data replication service level agreements SLA TPC benchmarks Electrical engineering. Electronics. Nuclear engineering TK1-9971
spellingShingle	Cloud computing data migration data replication service level agreements SLA TPC benchmarks Electrical engineering. Electronics. Nuclear engineering TK1-9971 Ahmed E. Abdel Raouf Alshaimaa Abo-Alian Nagwa L. Badr A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
description	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.
format	article
author	Ahmed E. Abdel Raouf Alshaimaa Abo-Alian Nagwa L. Badr
author_facet	Ahmed E. Abdel Raouf Alshaimaa Abo-Alian Nagwa L. Badr
author_sort	Ahmed E. Abdel Raouf
title	A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
title_short	A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
title_full	A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
title_fullStr	A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
title_full_unstemmed	A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment
title_sort	predictive multi-tenant database migration and replication in the cloud environment
publisher	IEEE
publishDate	2021
url	https://doaj.org/article/2ae0fbffcf484ed394d8c58239cebad4
work_keys_str_mv	AT ahmedeabdelraouf apredictivemultitenantdatabasemigrationandreplicationinthecloudenvironment AT alshaimaaaboalian apredictivemultitenantdatabasemigrationandreplicationinthecloudenvironment AT nagwalbadr apredictivemultitenantdatabasemigrationandreplicationinthecloudenvironment AT ahmedeabdelraouf predictivemultitenantdatabasemigrationandreplicationinthecloudenvironment AT alshaimaaaboalian predictivemultitenantdatabasemigrationandreplicationinthecloudenvironment AT nagwalbadr predictivemultitenantdatabasemigrationandreplicationinthecloudenvironment
_version_	1718425213437214720

A Predictive Multi-Tenant Database Migration and Replication in the Cloud Environment

Ejemplares similares