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

Load balancing system for database servers

A load balancing and server technology, applied in database distribution/replication, special data processing applications, structured data retrieval, etc., can solve problems such as immaturity and data errors, increase throughput, reduce load, and improve operating efficiency Effect

Inactive Publication Date: 2016-07-20
无锡中科富创科技孵化有限公司 +2
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In recent years, many load balancing concepts have been proposed, but the load balancing solution for database servers is still not mature enough, and data errors often occur under high traffic conditions

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
  • Load balancing system for database servers
  • Load balancing system for database servers
  • Load balancing system for database servers

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will be further described below in conjunction with specific drawings and embodiments.

[0018] Such as figure 1 , figure 2 and image 3 Shown: in order to effectively reduce the load of the database server, increase the throughput of the database server, and improve operating efficiency, the present invention includes a server cluster 7 composed of multiple database servers; a database server in the selected server cluster 7 is used as the data Read from server 1, and the rest of the database servers in the server cluster 7 write data to server 3;

[0019] The database to be processed is partitioned and the corresponding database partitions are stored in the corresponding data writing server 3 respectively, and the data to be written is written into the corresponding data writing server 3 in the database partition of the data reading server 1 After waiting to write data to write corresponding data to write the database partition of database 3 ...

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 relates to a load balancing system for database servers.The load balancing system comprises a server cluster composed of the database servers; one database server in the server cluster is selected as a data reading server, and the other database servers in the server cluster serve as data writing servers; databases needing to be processed are partitioned, obtained corresponding database partitions are stored in the corresponding data writing servers, and data to be written is written into the database partitions of the corresponding data writing servers through the data reading server; after the data to be written is written into the database partitions of the corresponding data writing servers, all the database servers in the server cluster are synchronized in real time, so that all the database servers in the server cluster store the databases with the same data content.The load balancing system for the database servers is compact in structure, capable of effectively reducing the load of the database servers, increasing the handling capacity of the database servers and improving the operating efficiency, safe and reliable.

Description

technical field [0001] The invention relates to a load balancing system, in particular to a load balancing system for a database server, belonging to the technical field of database server load balancing. Background technique [0002] One of the most important applications of load balancing is to use multiple servers to provide a single service. Usually, load balancing is mainly used in Web sites, large Internet RelayChat (Internet relay chat) networks, high-traffic file download sites, NNTP (NetworkNewsTransferProtocol) service and DNS service. Now the load balancer also starts to support the database service, called the database load balancer. [0003] Some load balancers provide special features to handle when all backend servers fail. Examples include forwarding requests to an alternate load balancer, displaying a message about a service outage, etc. Load balancers allow IT teams to dramatically increase fault tolerance by automatically provisioning massive amounts of...

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): G06F17/30G06F9/50
CPCG06F9/5027G06F9/5083G06F16/27
Inventor 于海宁崔超远王伟汪六三李文波孙丙宇
Owner 无锡中科富创科技孵化有限公司
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