Authors:
Manuel I. Capel
1
;
Oscar I. Aporta
1
and
María C. Pegalajar-Jiménez
2
Affiliations:
1
Department of Software Engineering, ETSI Informática and Telecomunicación, University of Granada, Periodista Daniel Saucedo Aranda s/n, 18015 Granada, Spain
;
2
Department of Computer Science and AI, ETSI Informática and Telecomunicación, University of Granada Periodista Daniel Saucedo Aranda s/n, 18015 Granada, Spain
Keyword(s):
Multitenancy, Multitenant DBMS, Quality of Service, DBMS Located in the Cloud, IaaS, OpenNebula.
Abstract:
This article proposes a new study of Quality of Service (QoS) in Database Management Systems with multitenancy in which it is experimentally verified that tenants follow interference patterns between them when they concurrently access the DBMS. The interference degree depends on characteristics of the database used by each tenant. A testing architecture with virtual machines (VM), managed with OpenNebula, has been designed. In each VM one DBMS is loaded managing many databases, one for each tenant. Five experiments were designed and numerous measurements performed using benchmarks of reference, such as TPCC, in a Cloud computing-based system. The results of the experiments are presented here, for which the latency and performance were measured with respect to different workloads and tenant configurations. To carry out the experiments, a multitenant environment model known as shared database/separate schema or shared instance was deployed, which is widely used at moment and presents t
he best ratio between resource use, performance and response.
(More)