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

Resource coordination method, device and system for database cluster

A coordination method and database technology, applied in the computer field, can solve problems such as low efficiency, inability to quickly warm up computing nodes, and obtain resources

Active Publication Date: 2015-04-08
HUAWEI TECH CO LTD
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the problem in the prior art that the resources cannot be quickly obtained from the high-speed coordinating node in scenarios such as restarting of the computing node or adding a new node, so that the computing node cannot be warmed up quickly and the efficiency is lowered, the embodiment of the present invention provides a The resource coordination method of the database cluster makes full use of the idle resources on the coordinating nodes, so that more data generated by the computing nodes can be stored on the coordinating nodes, and makes full use of the idle resources on the coordinating nodes and Infiniband (communication between the coordinating nodes and computing nodes Interface) high-speed communication characteristics, making the startup of computing nodes faster and more efficient

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
  • Resource coordination method, device and system for database cluster
  • Resource coordination method, device and system for database cluster
  • Resource coordination method, device and system for database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0070] Embodiment one, such as figure 2 Shown is a flow chart of a method for coordinating database cluster resources provided by an embodiment of the present invention. It can be understood that the flow chart of the method can be run as figure 1 The hardware base of the database cluster 100 is provided.

[0071] In step 201, the active coordinating node obtains status information corresponding to each of the multiple computing nodes, where the status information is used to indicate the operating load status of the computing node corresponding to the status information.

[0072]It should be noted that when there is a standby coordinator node in the database cluster, in order to keep the data consistent with the active coordinator node, the standby coordinator node, like the active coordinator node, can directly obtain the coordinator The same information obtained by the nodes can also be obtained from the active coordinating node that has already obtained the information. ...

Embodiment 2

[0102] Embodiment two, such as Figure 6 As shown, the embodiment of the present invention provides an active coordinating node 600 applied to a database cluster. The active coordinating node 600 can run in such as figure 1 Based on the provided hardware of the database cluster 100 , for example, the active coordinating node 600 may be 102 in the database cluster 100 .

[0103] The active coordinating node 600 includes:

[0104] An acquisition module 602, configured to acquire status information corresponding to each of the plurality of computing nodes in the database cluster, where the status information is used to represent the operating load status of the computing nodes;

[0105] The first judging module 604 is configured to judge whether the active coordinating node has idle resources with a preset threshold value X according to state information corresponding to each computing node among the plurality of computing nodes;

[0106] The execution module 606 is configured...

Embodiment 3

[0120] Embodiment three, such as figure 1 shown in figure 1 Based on the hardware devices of the database cluster 100,

[0121] An embodiment of the present invention provides a database cluster, including multiple computing nodes such as 122, 124, 126, 128, etc. and a primary coordinating node 102:

[0122] The active coordinating node 102 acquires state information corresponding to each of the multiple computing nodes such as 122, 124, 126, 128, etc., and according to the state information corresponding to each of the multiple computing nodes , to determine whether the active coordinating node 102 has idle resources with a preset threshold X; if so, notify each computing node to upload subsequent clean page data to the active coordinating node 102; wherein, the state The information is used to represent the running load status of the computing nodes;

[0123] Each of the computing nodes receives the notification sent by the active coordinating node 102, and when any one o...

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

An embodiment of the invention provides a resource coordination method, device and system for a database cluster. The method comprises that a primary coordination node obtains corresponding state messages of all computer nodes in a plurality of computer nodes, wherein the state messages are used for representing operation load states of the computer nodes; whether the primary coordination node has free resources of a preset threshold X is determined according to the state messages of all the computer nodes in the plurality of the computer nodes; all the computer nodes are notified to upload subsequently produced clean page data to the primary coordination node if the primary coordination node has the free resources. By means of the method, the device and the system, more data produced by the computer nodes can be stored on coordination nodes, the free resources on the coordination nodes and Infiniband (coordination node and computer node communication interfaces) high-speed communication characteristics are fully used, and accordingly, the computer node starting is rapid and efficient.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method, device and system for coordinating database clusters. Background technique [0002] In the cluster Share-Disk (shared disk) architecture, all servers in the cluster share a storage. Servers in the cluster can generally be divided into computing nodes (PN) and coordinating nodes (CN) according to their functions. Generally, there are multiple computing nodes, which are used to perform specific functions and execute specific SQL (Structured Query Language) and transactions. When the performance of the database needs to be improved, it can be expanded horizontally by adding computing nodes to achieve the purpose of improving the overall computing capacity of the cluster. At the same time, each computing node is redundant with each other, and the failure of a single computing node does not affect other computing nodes. Generally, there is only one coordinator node, whi...

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
CPCG06F3/067G06F3/06G06F11/2043G06F16/27G06F16/2365G06F16/2358G06F2201/81G06F11/3433G06F11/3006G06F2201/885
Inventor 肖宇雷叶涛
Owner HUAWEI 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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com