Database high availability implementation method and device

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...

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, however, such a judgment method is inaccurate, when oracle is in the hanging state, hacmp cannot detect of

Images