The cost of migrating DBMS from a conventional environment to virtual machines

  • Authors:
  • Mohamed Helmy Khafagy;Amr Ahmad Salem

  • Affiliations:
  • Fayoum University, Egypt;University of Nottingham, United Kingdom

  • Venue:
  • TELE-INFO'11/MINO'11/SIP'11 Proceedings of the 10th WSEAS international conference on Telecommunications and informatics and microelectronics, nanoelectronics, optoelectronics, and WSEAS international conference on Signal processing
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Virtualization becomes a very common solution in enterprise and small systems. Therefore, virtualization decreases financial costs and decreases system administration efforts. Also virtualization has been proven to be one of the most efficient approaches to implementing highly available systems. One of the most common software systems deployed in virtualized environments is Database Systems. The key reasons behind these migrations are the great flexibility regarding database administration tasks and also the high availability that virtualized systems offer, which is a very critical factor for some database systems, so it is important to understand the cost of migration from a conventional environment to a virtualized one. In this paper we present an experimental study of the overhead of DBMS migration from a conventional environment to a virtualized one, we use TPC-H Benchmark to calculate this overhead. We show that the average overhead can be around 7% for normal DBMS operations and 97% for fetching data directly from the external disks and we also present details of the different causes of this overhead. Our study shows that for normal DBMS operations the benefits of virtualization come at an acceptable cost.