Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for realizing high availability of database server based on shared storage

A shared storage and database technology, applied in the field of shared storage database management and database management, it can solve the problems of inaccurate judgment methods and undetectable hacmp, and achieve short failover time, easy implementation and maintenance, and high-availability services. Effect

Active Publication Date: 2015-04-29
CERTUS NETWORK TECHNANJING
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Taking hacmp as an example, to judge whether oracle is available, just check whether the oracle process exists. However, such a judgment method is inaccurate. When the oracle database is in a hanging state, hacmp cannot detect Arrived

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for realizing high availability of database server based on shared storage
  • Method and system for realizing high availability of database server based on shared storage
  • Method and system for realizing high availability of database server based on shared storage

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to be able to describe the technical content of the present invention more clearly, further description will be given below in conjunction with specific embodiments.

[0029] In one embodiment, the method and system for achieving high availability of database servers based on shared storage of the present invention are used to control multiple database servers to complete the startup and shutdown of database instances, such as figure 1 with 2 As shown, the system includes a service detection module (including a network quality detection unit and a local database instance status detection unit) and an instance management module (including an instance status judgment unit and a local database instance start-stop unit). The method includes the following steps:

[0030] S1. The service detection module in the database server is started to detect the network service quality of the database server (including the communication quality of the heartbeat network between the dat...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method for realizing the high availability of a database server based on shared storage. The method comprises the following steps: the database server detects the network service quality and the local database instance state of the database server; the database server judges whether the local database instances of nodes of the database server are started up or not according to the network quality and the local database instance state of the database server and the local database instance states of other database servers. In addition, the invention also relates to a system for realizing high availability of the database server based on shared storage. Each database server of the system comprises a service detection module and an instance management module. According to the method and the system for realizing the high availability of the database server based on shared storage, provided by the invention, high availability is realized by a mode that the instance nodes detect themselves, the nodes supervise other node instance states and the process is self-managed, no difference among master nodes and standby nodes exists, and the third-party nodes are not needed. The method and the system have the advantages of simple structure, easiness in realization, and relatively broad application range.

Description

Technical field [0001] The invention relates to the field of database management, in particular to the field of database management of shared storage, and specifically refers to a method and system for realizing high availability of a database server based on shared storage. Background technique [0002] With the advent of the era of big data and cloud computing, database applications continue to extend from large enterprises to small and medium-sized enterprises. Traditional high-availability cluster software for large enterprises is not only technically complex and expensive, but also high maintenance costs. The economic and technical strength of small and medium-sized enterprises is relatively weak, and an inexpensive solution is urgently needed to solve the database availability problem in the project. High ailability here refers to improving the availability of systems and applications by minimizing downtime caused by routine maintenance operations (planned) and sudden syst...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/217G06F16/21
Inventor 逯利军钱培专张军姜健李克民宋聚平张树民
Owner CERTUS NETWORK TECHNANJING