Cluster database system resource management and control scheduling method

A system resource and database technology, applied in the field of cluster database system resource management, control and scheduling, can solve problems such as low use efficiency, advanced users cannot get resource use priority, database product user experience impact, etc., to achieve the effect of easy management

Pending Publication Date: 2019-11-26
江苏华库数据技术有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of using large-scale cluster database products, if the management function of system resources is lacking, it will cause a series of problems such as unreasonable allocation of system resources, low utilization efficiency, and advanced users cannot get due resource usage priority.
This will have a great negative impact on the user experience of the database product

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
  • Cluster database system resource management and control scheduling method
  • Cluster database system resource management and control scheduling method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0026] The logical structure diagram of user group, resource pool, and resource scheduling plan in a cluster database system resource management and control scheduling method in this embodiment is as follows figure 1 As shown, the logical relationship between the static resource pool and the dynamic resource pool is as follows figure 2 shown.

[0027] If it is necessary to perform resource scheduling control on a task initiated by a user, follow the steps below:

[0028] Step 1: The database user initiates the task;

[0029] Step 2: Query the user group where the current database user belongs, where the user group includes the information of user group A, user group B and user group C;

[0030] Step 3: Query the currently activated "resource scheduling plan" information;

[0031] Step 4: According to the "resource scheduling plan" information and user group information, query the information of resource pool 1 and resource pool 2 currently applicable to the task;

[0032]...

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 cluster database system resource management and control scheduling method, which comprises the following steps: performing configuration management on related information content of resource management, and activating and stopping different resource management strategies; discriminating a user group to which a task belongs according to different task initiating users of the cluster database; according to the priority of the user group to which the task belongs and the isolation configuration between the resource pools, calculating the quantity of system resources capable of being used by the task and whether the current task can be immediately executed or not; and if the task is overtime due to overlong execution, stopping the task or handing over the task to theuser group with lower priority to continue execution. According to the method, the timing switching function of the cluster resource management strategy is realized, and the resource allocation modesand the management strategies adopted by the cluster database system in different time periods are different according to the requirements of users so as to meet different requirements of different time periods on cluster resource loads.

Description

technical field [0001] The invention belongs to the technical field of database system resource management, control and scheduling, and in particular relates to a method for cluster database system resource management, control and scheduling. Background technique [0002] With the continuous development of information technology and the continuous surge of data volume, databases are being used more and more widely. In particular, large-scale cluster databases are favored by users because of their strong processing capabilities and good scalability. [0003] In the process of using large-scale cluster database products, if the management function of system resources is lacking, it will cause a series of problems such as unreasonable allocation of system resources, low utilization efficiency, and advanced users cannot get due resource usage priority. This will have a great negative impact on the user experience of the database product. This is exactly the application scenari...

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): G06F16/27G06F16/21G06F16/215G06F16/2453G06F16/25H04L29/08
CPCG06F16/215G06F16/217G06F16/24549G06F16/25G06F16/27H04L67/10
Inventor 赵伟吴树桂
Owner 江苏华库数据技术有限公司
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