Database virtualization

Abstract: Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increasingly be run in virtualized environments, inside virtual machines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we discuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new "tuning knobs" that control resource allocation to virtual machines in the virtualized environment. We present a formulation of the visualization design problem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solution to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware "what-if" mode. We also discuss the next steps in solving this problem, and present some long-term research directions.

Abstract: In recent years, cloud computing is the most popular topic on the IT industry. The underlying virtualization technologies, that make cloud computing possible, also get more and more attention. Gradually, companies move their services to the virtual host. These services include: desktop virtualization, application virtualization and database virtualization etc. Among these services, database virtualization can improve flexibility, maximize efficiency, lower costs and ease administrative overhead. In this paper, we use on-demand features of cloud computing and sharding features of MongoDB to provide an auto-scaling database virtualization solution that satisfy the service-level agreement (SLA) requirements. First, we apply an auto-scaling mechanism of route server in the database system. The experimental results show that the average response time of auto-scaling DB solution and none-scaling DB solution are 4.3 seconds and 7.1 seconds, respectively. Second, in order to minimize the impact when moving data to a new VM, we also design a shard data migration algorithm for the database system. The auto-scaling DB solution uses the algorithm to determine how many VM should be added and which data should be moved to those added VM.

Abstract: The invention discloses a database virtualization method and device in testing environments. The method includes the steps: acquiring data in a database by a server; generating corresponding mirror image information according to acquired data; respectively transmitting generated mirror image information to connected testers; respectively generating database mirror images by each tester according to received mirror image information; testing applications to be tested based on the generated database mirror images. According to the method, the testers have the database mirror images of the testers, process of data services provided by the database mirror images happens on locality of each tester in the automatic testing process, calling conflict of data is avoided, and the testers read the data in data mirror images generated by applications to be tested in the testers and cannot read dirty data generated by other testers, so that stability and efficiency of automatic test are ensured.

Abstract: Database virtualization is understood by different people in different ways; either it is executing or storing databases on virtual machine or a full virtualization of database. It helps in masking the actual physical location of the databases from the programs and users using it. With the aid of virtualization, databases can be decentralized thus increasing availability and usability of databases. But as we step into the world of virtualization, the central requirement becomes performance. It becomes an important task for DBA to provide excellent performance by putting minimum efforts and cost. Performance confines various extensions. A database residing in a virtual machine must act commensurable with the application which is using it. It is also considered that resource sharing between multiple virtual machines running on same host must be effective and efficient. In this paper, the performance criteria on the basis of parameters involved in running queries on virtual databases are discussed and a report is prepared analyzing the results of different tuning techniques.