Database high availability implementation method and device

An implementation method and database technology, which are applied in the field of database high availability implementation method and its device, can solve the problems of inaccurate judgment method and undetectable by hacmp, etc., and achieve the effect of accurate judgment

Inactive Publication Date: 2013-04-24
ALIBABA GRP HLDG LTD
View PDF4 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Take hacmp as an example, to judge whether oracle is available, just check whether the oracle process exists

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] Specific embodiments of the present application will be described in detail below. It should be noted that the embodiments described here are for illustration only, and are not intended to limit the present application.

[0011] figure 1 It is a flow chart of an embodiment of the method for implementing database high availability in this application. The database high availability implementation method of this embodiment is used to realize the switching between the active database (hereinafter referred to as the main database) and the standby database (hereinafter referred to as the standby database), as shown in the figure, the method includes the following steps S1, S2 and S3.

[0012] S1, the heartbeat table sub-thread is set to judge whether the update of the heartbeat table of the main library fails, the backup library sub-thread is set to judge whether the backup library is available, and the gateway sub-thread is set to judge the main library and the backup lib...

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 database high availability implementation method and a device. The method includes (S1) setting a heartbeat meter sub thread to judge whether update of a heartbeat meter of a primary library fails or not, setting a standby library sub thread to judge whether a standby library is available or not, setting a gateway sub thread to judge whether gateways where the primary library and the standby library are located are available or not, (S2) setting a primary thread to detect judge results of the heartbeat meter sub thread, the standby library sub thread and the gateway sub thread in a circulating mode, and proceeding the step (S3) if the judge results of the heartbeat meter sub thread, the standby library sub thread and the gateway sub thread are positive, and (S3) executing switching from the primary library to the standby library. According to the method and the device, whether the heartbeat meter is successfully updated serves as a standard to judge whether a database is available, whether the standby library is available ( whether the standby library delay meets requirements, whether the standby library can be visited, and the like) serves as a standard to judge whether the standby library can be used for switching, and the switch between the primary library and the standby library is effectively controlled through flexible configuration for switching conditions.

Description

technical field [0001] The present application relates to the field of information technology, in particular to a method and device for realizing high availability of a database. Background technique [0002] In recent years, various industries have utilized computer systems to provide timely and reliable information and services; however, failures of both computer hardware and software are inevitable. Once the system fails, it needs manual identification as well as error analysis, testing and system recovery. Therefore, system failure may lead to a long-term suspension of the system, or even the termination of the entire service and the paralysis of the network, which will bring inestimable economic losses to the enterprise. It can be seen that for some industries (such as: network service providers, financial institutions, POS system servers in supermarkets, etc.), the fault tolerance and uninterruptibility of the system are particularly important. Therefore, appropriate...

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
IPC IPC(8): G06F17/30G06F9/46
Inventor 熊中哲吕海波张瑞
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap