Database node health condition detection method and detection device

A health status and database technology, applied in the database field, can solve problems such as insufficiency, business impact, and inability to achieve standardized implementation, and achieve the effect of fast detection results and poor sensitivity of abnormal detection.

Active Publication Date: 2013-03-20
CHINA MOBILE GROUP ZHEJIANG
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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 node health condition detection method and detection device
  • Database node health condition detection method and detection device
  • Database node health condition detection method and detection device

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0055] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0056] figure 1 A flow chart of a method for detecting the health status of an oracle RAC database node provided by Embodiment 1 of the present invention, such as figure 1 As shown, the specific steps are as follows:

[0057] Step 101: For any oracle RAC database node, in each sampling period, grab the active session status of the database node in the first time period recently, and calculate the abnormal waiting session of the database node in the sampling period according to the active session status Proportion.

[0058] Step 102: Determine whether the proportion of abnormally waiting sessions is greater than a preset first threshold, if so, perform step 103; otherwise, perform step 106.

[0059] Step 103: Determine whether the database node has the most serious waiting session in the sampling period, if yes, execute step 104; ot...

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

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/30
Inventor 王晓征肖爱元
Owner CHINA MOBILE GROUP ZHEJIANG
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