Database node health condition detection method and detection device

Abstract

The invention discloses a database node health condition detection method and a detection device. The database node health condition detection method includes a first step of capturing an active session state of a database node in a lately first session-timeout within every sampling period for any oracle real application clusters (RAC) database node, a second step of computing the percentage of abnormal waiting sessions of the database node within the sampling period according to the active session state, a third step of judging whether the percentage of the abnormal waiting sessions is larger than a preset first threshold value, if so, a fourth step of judging whether the most serious waiting sessions exist in the database node within the sampling period, judging, if existing, a fifth step of judging the database node within the sampling node is an unhealthy node and continuing judging whether the database node within a plurality of continuous preset sampling periods is judged to be the unhealthy node, and if so, a sixth step of executing closing and stopping operation to the database node. The database node health condition detection method and the detection device achieve automatic real-time detection to the health conditions of the oracle RAC database nodes.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for detecting the health status of database nodes. Background technique [0002] The introduction of the concept of Oracle Real Application Clusters (RAC, Real Application Clusters) is to improve the high availability of the system, and achieve disaster recovery through cluster software and shared storage. Since each instance (instance) shares physical storage, but each has an independent memory structure, it is necessary to allocate some resources synchronously in real time. In some abnormal situations, it will cause poor node performance, and in severe cases, it will cause the database to hang (HANG). In the case of one of the nodes running out of performance and losing response, it will lead to the suspension of resource synchronization between nodes, affecting the normal operation of the entire database, and causing the business system to fail to provid...

AI Technical Summary

Problems solved by technology

At this time, the database is generally in the stop responding or extremely slow response or HANG state, causing a large area of ​​business to be affected, and it is impossible to effectively and quickly discover performance problems, and then take further processing measures

[0010] Therefore, the original technical points are only simple and one-sided information collection and simple performance judgment, which are obviously not enough for complex OLTP large-scale database systems that require quick response.

Except for some specific and obvious system error messages, the evaluation of the health status of other database nodes largely depends on the experience and judgment of the maintenance personnel, and cannot be implemented in a standardized manner.

Images