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

Database high availability method and device

A database and main database technology, applied in the database field, can solve the problem of low efficiency of manual operation and achieve the effect of efficient failover

Pending Publication Date: 2020-11-27
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] However, in related technologies, it is necessary to manually restart the management process in the slave library node to restore the management process
Due to the low efficiency of manual operation, the failover of the main library node cannot be efficiently performed in related technologies

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
  • Database high availability method and device
  • Database high availability method and device
  • Database high availability method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0084] Embodiment 2 Amplifies on the basis of Embodiment 1, and also includes the following steps after step S104:

[0085] Step S201: After the standby master database node is successfully switched, monitor whether the database instance of the original master database node is normal.

[0086] After the original main database node fails, there will be maintenance personnel to repair it. Therefore, after the standby node is successfully switched, the management process can monitor whether the database instance of the original master database node is normal.

[0087] The management process can remotely log in to the original master database node to monitor whether the database instance in the original master database node is normal; if normal, it means that the database instance of the original master database node is normal; The database instance of the original master database node is abnormal.

[0088] Step S202: If the database instance of the original master database node...

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 provides a database high availability method and device, and the method comprises the steps: monitoring whether the working state of an original master library node is normal or not under the condition that a current node is recognized as a first slave library node provided with a management software package; if the working state of the original main library node is abnormal, executing a switching operation from the original main library node to a standby main library node; monitoring whether the standby main library node is successfully switched or not; and if the standby masterlibrary node is successfully switched, restarting a management process in the first slave library node, so that the management process monitors whether the working state of the standby master librarynode is normal or not. According to the method, the first slave library node can automatically restart the management process in the first slave library node after the standby master library node issuccessfully switched, and maintenance personnel do not need to manually restart the management process, so that fault switching of the master library node can be efficiently carried out.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to methods and devices for high availability of databases. Background technique [0002] A database (for example, MySQL) can deploy a high-availability technology based on MHA (Master High Availability, high availability of the main database) on a multi-slave cluster with one master. A master-multiple-slave cluster may include a master-two-slave cluster (one master node and two slave nodes), a master-three-slave cluster (one master node and three slave nodes), and the like. [0003] The MHA software consists of a management software package (that is, MHA Manager software package) and a node software package (MHA Node software package). The method of separately deploying the management software package on a slave library node in each one-master-many-slave cluster is called MHA independent management. [0004] In the MHA independent management mode, after the management ...

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): G06F16/27G06F16/21
CPCG06F16/27G06F16/211
Inventor 王良元卢星辰
Owner CHINA CONSTRUCTION BANK