Database cluster system load balancing method and database cluster system

A load balancing and cluster system technology, applied in the information field, can solve the problems of not knowing the back-end status, not being able to achieve optimal allocation of back-end tasks, and lack of controllability

Inactive Publication Date: 2010-09-22
INST OF SOFTWARE - CHINESE ACAD OF SCI
View PDF3 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] However, the above load balancing methods do not take into account the differences of different computer nodes
The random selection method always randomly selects the database nodes without any knowledge of the back-end status and no controllability at all. The round-robin and weighted round-robin methods are executed sequentially among the back-end databases, which can make each back-end There are tasks, but the optimal allocation of each back-end task cannot be achieved

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 cluster system load balancing method and database cluster system
  • Database cluster system load balancing method and database cluster system
  • Database cluster system load balancing method and database cluster system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] A specific embodiment is provided below to further illustrate the present invention.

[0042] build as Figure 4 In the heterogeneous database cluster system shown, the controller node and the three back-end database nodes are located on different hosts. Configure the database cluster controller on the controller node host to provide the controller node functionality required by the invention. Users operate through the user interaction platform provided by the cluster controller. The invention expands the cluster controller and adds the following three components: a load decision balancing component, a back-end detection component and a load information table. The backend detection component initiates a load detection request to each backend at a fixed time interval.

[0043] Install SqlServer, Ingres, and PostgreSQL databases on the three backends respectively. Create a loadstate table on the three databases to store the load information of the node, and create a t...

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 cluster system load balancing method and a database cluster system, and belongs to the field of information technology. The method comprises the following steps: (a) utilizing a cluster controller to acquire index values at each database back end to constituent a decision matrix; (b) calculating a weighted normalizing matrix according to the decision matrix; (c)calculating the distance between each database back end and plus-minus ideal solutions; and (d) after sequencing according to the distance difference value, utilizing the cluster controller to call the database back end according to the sequence. The system comprises the cluster controller and one or a plurality of the database back ends, wherein the cluster controller comprises a load balancing decision module, a back end detection module, a user request distribution module and a load information table; and each database back end comprises a communication module, a database server and a loadmeasurement module. The invention can be used for database cluster systems.

Description

technical field [0001] The invention relates to a database cluster system, in particular to a load balancing method in the database cluster system and a corresponding database cluster system, belonging to the field of information technology. Background technique [0002] A database cluster system refers to combining a group of database servers in a cluster and using a unified interface to provide services to users. The database cluster system uses data copies stored on multiple database back-end nodes to achieve higher availability; and uses multiple database back-end nodes to provide more powerful data management capabilities and higher query response that cannot be provided by a single database system efficiency. [0003] The database cluster system uses a variety of data distribution methods, including: full set redundancy mode, subset partition mode and subset overlap mode. Among them: the complete set redundancy mode (also known as the peer-to-peer redundancy mode) me...

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): H04L29/08G06F17/30
Inventor 陈驰殷佳欣王伏根张大朋付艳艳
Owner INST OF SOFTWARE - CHINESE ACAD OF SCI
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap