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

Database operation load balancing method, device and equipment and medium

A load balancing and database technology, applied in the database field to achieve the effect of improving load balance, improving storage and reading speed, and reducing impact

Inactive Publication Date: 2019-07-16
XIANGYANG BRANCH CHINA MOBILE GRP HUBEI CO LTD +1
View PDF9 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At the same time, the flexible configuration balance cycle helps to solve the problem of database read and write performance, and improves the overall storage and reading speed of the cluster

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 operation load balancing method, device and equipment and medium
  • Database operation load balancing method, device and equipment and medium
  • Database operation load balancing method, device and equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The characteristics and exemplary embodiments of various aspects of the present invention will be described in detail below. In order to make the purpose, technical solutions and advantages of the present invention more clear, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only configured to explain the present invention, not to limit the present invention. It will be apparent to one skilled in the art that the present invention may be practiced without some of these specific details. The following description of the embodiments is only to provide a better understanding of the present invention by showing examples of the present invention.

[0017] It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and ...

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 operation load balancing method and device, equipment and a medium. The method comprises the following steps: determining hot nodes with larger total operation loadand cold gate nodes with smaller total operation load based on the total operation load of each of the plurality of nodes; and migrating an area of which the operation load number is greater than a reference value in the hot node into the cold gate node. Balanced distribution is carried out on the operation load of the cluster, the unbalanced state of the load of the cluster is reduced, the reading and writing of each node reach the optimal state, and the load balance is improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a database operation load balancing method, device, equipment and media. Background technique [0002] A database cluster system refers to combining a group of database servers in a cluster and using the same interface to provide services to users. The database cluster system utilizes the higher availability of data copies stored on multiple database servers, and utilizes multiple database servers to provide more powerful data management capabilities and higher query response efficiency that cannot be provided by a single database system. [0003] However, as the amount of data continues to increase, hotspot data will be unevenly distributed, and only a small number of database servers are responsible for most of the accesses, resulting in a decrease in the processing capacity of the cluster and a waste of server resources. [0004] Therefore, an efficient load balanci...

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): G06F16/27G06F9/48G06F9/50
CPCG06F9/4862G06F9/5083G06F16/27
Inventor 王卉雷中杰胡莉樊炼李林许佳薛超毛在清盛勇徐庆张欣黄璐陈翔汪睿李瑶
Owner XIANGYANG BRANCH CHINA MOBILE GRP HUBEI 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