Method for establishing database cluster by utilizing virtualization

Abstract

The invention provides a method for establishing a database cluster by utilizing virtualization, which utilizes the technical advantages of virtualization, ensures that all processing units in the database cluster obtain optimal resources, simultaneously improves the resource utilization rate of a physical hardware, and realizes the rapid deployment, expansion of the database cluster, the dynamic migration, the resource isolation of a multi-cluster system and the dynamic management of system resources, wherein the all processing units in the database cluster obtain optimal resources, i.e. a CPU, a memory and IO resources are customized and allocated in advance for a virtual machine according to the requirements of the processing unit in the database cluster for the resources in an underlying server system of the virtual machine; the improvement of the utilization rate of system resources means that a plurality of virtual machines are deployed and operated on the underlying server system of the virtual machine so as to improve the resource utilization rate of the underlying server of the virtual machine; the rapid deployment and expansion of the database cluster mean that the rapid expansion of the database cluster is realized through the mirroring replication function of a virtualized software; and the dynamic migration means that the dynamic migration of the virtual machine is realized by utilizing the virtualized software, and the service of the database cluster is not interrupted.

Description

Technical field [0001] The invention relates to the application field of database clusters, in particular to a method for constructing database clusters by using virtualization, which utilizes virtual machine technology to optimize resources, rapid deployment and expansion, dynamic migration and dynamic resource management of the database cluster system. Background technique [0002] The database cluster (Oracle Real Application Cluster referred to as Oracle RAC) provides extremely high performance and perfect error correction functions for most critical business-required database environments. It not only allows multiple nodes in a cluster system or a large-scale parallel system to share the same physical database, and automatically performs load balancing, fault repair and planned downtime among multiple nodes to support high-availability applications, and it is combined with parallel query options Provides parallelism between nodes and parallelism within nodes, significantly i...

AI Technical Summary

Problems solved by technology

However, from the overall situation of the actual operation of the business system, it is not satisfactory

A survey of database cluster application issues shows that: nearly 1 / 3 of the relevant persons in charge said that the system did not play a real role, the average system load was less than 20%, and there was a large waste of resources; nearly 1 / 5 of the persons in charge said that the database cluster The system deployment process is cumbersome, and it is difficult to troubleshoot during the deployment process; more than 1 / 10% of the persons in charge said that system upgrades, migrations, and expansions were complicated and could only be achieved by relying on professional technical support; at the same time, nearly 2 / 5 of the relevant persons in charge indicated that the system resources The management is opaque, often at a loss for system resource usage and management

Images