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

Method and device for distributed database load leveling

A database and distributed technology, applied in the Internet field, can solve the problems of heavy server load and affect the overall efficiency of the distributed database system, and achieve the effect of reducing the load

Active Publication Date: 2019-09-13
TENCENT TECH (SHENZHEN) CO LTD +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the existing balanced distribution method only considers the capacity of data slices. If the load of the moved data slice is too high, when it is moved to other servers, the load on other servers will be too large, which will still affect to the overall efficiency of the entire distributed database system

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 and device for distributed database load leveling
  • Method and device for distributed database load leveling
  • Method and device for distributed database load leveling

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0026] refer to figure 1 , figure 1 It is a bus diagram of the system where the distributed database load leveling device in the embodiment of the present invention is located. The system may include: at least one processor 101 , such as a CPU, at least one network interface 104 , a user interface 103 , a memory 105 , and at least one communication bus 102 . Wherein, the communication bus 102 is used to realize connection and communication between these components. Wherein, the user interface 103 may include a display screen (Display), a keyboard (Keyboard), and may also include a standard wired interface and a wireless interface. The network interface 104 may include a standard wired interface and a wireless interface (such as a WIFI interface). The memory 105 may be a high-speed RAM memory, or a non-volatile mem...

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 distributed database load leveling method, comprising: counting the load of all servers in the distributed database system and the load ratio of each data slice in each server; n servers are used as high-load servers, and the n servers with lower loads are used as low-load servers; the data slices with the highest load proportion among high-load servers are used as source data slices, and the load proportion of low-load servers is used as source data slices. The data slice that is sorted later is used as the target data slice, and the target data slice is swapped with the source data slice. The invention also discloses a distributed database load leveling device. The invention reduces the load in the high-load server, avoids the situation that the low-load server is overloaded due to the high-load server transferring data slices to the low-load server, and effectively reduces the load of the entire distributed database system.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for load balancing of distributed databases. Background technique [0002] In recent years, with the rapid growth of data volume, distributed database technology has also been developed rapidly. The distributed database divides the data in the original centralized database into a large number of data pieces, disperse and store them on multiple independent data storage nodes, and use the network to connect multiple physically dispersed data storage units to form a logically unified database. It adopts a scalable system structure and utilizes multiple servers to share the storage load, which not only improves the reliability, availability and access efficiency of the system, but is also easy to expand. In order to maintain a balanced distribution of data slices, when the distribution of the number of data slices on a server in the entire distributed datab...

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 Patents(China)
IPC IPC(8): H04L29/08
CPCG06F3/061G06F3/067G06F3/0647H04L67/1008H04L67/1097H04L67/1029G06F3/0611G06F3/0689
Inventor 邹润谋
Owner TENCENT TECH (SHENZHEN) 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