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 database management and shared storage database management field, can solve problems such as undetectable by hacmp and inaccurate judgment methods, and achieve easy implementation and maintenance, short failover time, and high-availability services Effect

Active Publication Date: 2019-07-16
CERTUS NETWORK TECHNANJING
View PDF4 Cites 0 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 high availability of a database server based on shared storage, which includes: the database server detects its own network service quality and local database instance status; the database server detects its own network quality, its own local database instance status and other The state of the local database instance of the database server judges whether to open the local database instance of its own node; in addition, the present invention also relates to a system for realizing high availability of the database server based on shared storage, and each database server of the system includes a service detection module and an instance management module . Using the method and system for realizing high availability of database server based on shared storage of the present invention, high availability is realized by means of self-testing of instance node status, node supervision of other node instance status, and self-management process, without distinction between active and standby nodes, and without resorting to The third-party node has a simple structure, is easy to implement, and has a wider range of applications.

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 Patents(China)
IPC IPC(8): G06F16/178
Inventor 逯利军钱培专张军姜健李克民宋聚平张树民
Owner CERTUS NETWORK TECHNANJING