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

Clustered database system dynamic loading balancing method

A dynamic load and database technology, applied in the field of computer communication, can solve the problems of simple update statement processing, waste of database server resource usage, high database server load, etc., to achieve the effect of improving overall resource utilization and overall execution performance

Inactive Publication Date: 2008-04-30
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF0 Cites 80 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] ICX database gateway has played a great role in improving the overall execution performance and availability of the database, but it is still lacking in resource utilization
For example, if the database query statement is sent in a simple polling method, some database servers may have a high load, while some database servers are still idle.
Moreover, the processing of the update statement is too simple, which wastes the resource usage of the database server to some extent.

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
  • Clustered database system dynamic loading balancing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0020] Figure 1 describes the specific working process of the dynamic load balancing mechanism. In this example, three real database servers are used in the background, and the database software of the same type and version is installed. A database client accesses the background database server through the database gateway.

[0021] The agent program running on each database server will dynamically collect the server's processor, memory, IO and other load conditions, and periodically send it to the database gateway (for example, once every 10 seconds). The database gateway will calculate the load status of each database server in real time according to the load balancing algorithm, and express it in the form of weight. The lower the weight, the lower the server load. For example, at a certain moment, the weight of database 1 is 10, the weight of database 2 is 20, and the weight of database 3 is 30.

[0022] When the database gateway receives the database statement from the ...

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 provides a dynamic load balancing method for a cluster database system. The method comprises determining the loading state of a database server according to a dynamic load balancing algorithm, transmitting a database sentence to the database server with the lowest load through a database gateway system, and returning the result back to a client-end. Different data synchronization mechanisms are executed according to different database sentences. For the database searching sentence, the database gateway directly returns the corresponding result back to the client-end; for the database updating sentence, the database gateway returns the corresponding result back to the client-end, records the state of the updating table, and then transmits the updating sentence to other database servers, to keep the data consistency in each database. On the basis of keeping the performance and the usability of the cluster based on database gateway (middleware), the invention effectively improves the overall resource utilization rate of the database cluster through the dynamic load balancing mechanism, and further improves the overall execution performance of the database.

Description

1. Technical field [0001] The invention relates to the technical field of computer communication, in particular to a dynamic load balancing method of a cluster database system. 2. Technical background [0002] For all databases, in addition to recording correct processing results, they all face four challenges: how to improve processing speed, data availability, data security, and data set scalability. With the deepening of IT applications and the rapid growth of wired and wireless networks, the electronic transaction processing business has put forward higher requirements for the above four aspects. [0003] It should be said that it is a very natural idea to connect multiple databases together to form a database cluster to achieve the above goals. Generally, the database cluster technology belongs to two types of architectures: the database engine-based cluster and the database gateway (middleware)-based cluster. [0004] There are many clusters based on database engines...

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/30H04L12/54H04L29/08
Inventor 尹宏伟李志强
Owner LANGCHAO ELECTRONIC INFORMATION IND 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