Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method, device and server for processing database cluster automatically and optimally

An automatic optimization and processing method technology, applied in the field of database processing, can solve problems such as untimely discovery, high cost of manual intervention, unreasonable settings or failures, etc., to achieve the effect of reducing labor costs and improving performance and service quality

Inactive Publication Date: 2017-11-24
BEIJING QIHOO TECH CO LTD
View PDF7 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the prior art, for the problems to be optimized and faults in the database cluster, it is mainly to adjust the unreasonable parameters in the database cluster through manual intervention, or to manually detect and deal with the generated faults. When solving the above problems, unreasonable settings or faults cannot be discovered in time, and the problems cannot be dealt with in a targeted manner, resulting in long processing time, high resource consumption, and high cost of manual intervention.

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
  • Method, device and server for processing database cluster automatically and optimally
  • Method, device and server for processing database cluster automatically and optimally
  • Method, device and server for processing database cluster automatically and optimally

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0031] figure 1 A schematic flowchart of a method for automatically optimizing a database cluster according to an embodiment of the present invention is shown. Such as figure 1 As shown, the method includes the following steps:

[0032] Step S101, monitor the state information of the database cluster, and collect the state index feature information of the database cluster corresponding to the preset state index.

[0033] The ope...

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 method, device, server and computer storage medium for processing a database cluster automatically and optimally. The method includes the steps of monitoring state information of the database cluster, and collecting the state index characteristic information, corresponding to a preset state index, of the database cluster; according to the state index characteristic information of the database cluster, analyzing operation status of the database cluster; for the operation status, triggering a corresponding fault handling measure and / or an optimization measure for automatic and optimal processing. According to the technical scheme, for different operation status of the database cluster, the corresponding fault handling measure and / or the optimization measure can be triggered for automatic and optimal processing, and compared with the prior art, no investment of excessive human resources is needed, so that the human cost is reduced; besides, various failures and to-be-optimized problems in a database can be discovered in time, and the problems can be automatically processed, so that the performance and the service quality of the database are improved.

Description

technical field [0001] The invention relates to the field of database processing, in particular to a database cluster automatic optimization processing method, device, server and computer storage medium. Background technique [0002] A database cluster is to use at least two or more database servers to form a virtual single database logical image, and provide transparent data services to clients like a single database system. In the process of database clusters providing services to clients, with the development of the Internet, the amount of business data stored by enterprises is also increasing rapidly. In this case, it is necessary to continuously improve the performance of database clusters and ensure the quality of external services provided by database clusters. Stablize. [0003] In the prior art, for the problems to be optimized and faults in the database cluster, it is mainly to adjust the unreasonable parameters in the database cluster through manual intervention,...

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): G06F17/30G06F11/30
CPCG06F11/3006G06F11/3051G06F16/217
Inventor 李丹
Owner BEIJING QIHOO TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products