CN105787006A - Load balancing system for database servers - Google Patents
Load balancing system for database servers Download PDFInfo
- Publication number
- CN105787006A CN105787006A CN201610097075.5A CN201610097075A CN105787006A CN 105787006 A CN105787006 A CN 105787006A CN 201610097075 A CN201610097075 A CN 201610097075A CN 105787006 A CN105787006 A CN 105787006A
- Authority
- CN
- China
- Prior art keywords
- server
- database
- data
- server cluster
- servers
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5083—Techniques for rebalancing the load in a distributed system
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
The present invention relates to a kind of SiteServer LBS, especially a kind of database server SiteServer LBS, belong to the technical field of database server load balancing.
Background technology
The most important application of load balance is to utilize multiple servers to provide single service, under normal circumstances, load balance is mainly used in Web site, large-scale InternetRelayChat(Internet relay chat) network, the file download website of high flow capacity, NNTP(NetworkNewsTransferProtocol) service and DNS service.Present load balancer also begins to support database service, is referred to as database loads static organ.
When all background servers break down, some load balancer can provide some special functions to process this situation.Such as forward the request to a standby load balancer, one message etc. about service disruption of display.Load balancer makes IT team can significantly improve fault-tolerant ability, and it can automatically provide substantial amounts of capacity to process increase or the minimizing of any application rs traffic.
There is the proposition of a lot of load balancing theory in recent years, but the load balancing scheme about database server was still ripe not enough, often occurred the situation of error in data under high traffic condition.
Summary of the invention
It is an object of the invention to overcome the deficiencies in the prior art, it is provided that a kind of database server SiteServer LBS, its compact conformation, can effectively reduce the load of database server, increase the handling capacity of database server, improve operational efficiency, safe and reliable.
According to technical scheme provided by the invention, described database server SiteServer LBS, including the server cluster become by multiple stage database servers group；A database server in selected server cluster is as digital independent server, and the remainder data storehouse server in server cluster writes server as data；
The data base of required process carried out subregion and corresponding partitions of database will be obtained is respectively stored in corresponding data write server, being written in the partitions of database of data write corresponding data write server by digital independent server；Again after the partitions of database of data to be written write corresponding data write into Databasce, in server cluster, all of database server carries out real-time synchronization, so that every database server all stores the data base that data content is identical in server cluster.
Real-time synchronization is carried out by rsyns mode between the database server in described server cluster.
Described server set group energy is connected with client by active router or standby router；Described active router sends packet to standby router timing, after preset time threshold, if standby router does not receive packet, then realizes the connection between server cluster and client by standby router.
Database server in server cluster adopts the innodb engine of MySQL to carry out digital independent and data write operation.
Four database servers are at least included in described server cluster.
Advantages of the present invention: the database server in server cluster is defined as digital independent server and data write server, read and write abruption with fulfillment database, accelerate the speed of data base querying, partitions of database is respectively stored in corresponding data write server, and after each partitions of database write data, real-time synchronization is carried out between the database server in server cluster, so that the data base that each database server storage content is identical, can effectively reduce the load of database server, increase the handling capacity of database server, improve operational efficiency, safe and reliable.
Accompanying drawing explanation
Fig. 1 is the schematic diagram that server cluster is divided into digital independent server and data write server.
Fig. 2 is the schematic diagram that the partitions of database obtained after subregion is respectively stored in corresponding data write server by the present invention.
Fig. 3 is the structured flowchart of the present invention.
Description of reference numerals: 1-digital independent server, 2-data write server group, 3-data write server, 4-client, 5-active router, 6-standby router and 7-server cluster.
Detailed description of the invention
Below in conjunction with concrete drawings and Examples, the invention will be further described.
As shown in Figure 1, Figure 2 and Figure 3: in order to enable effectively to reduce the load of database server, increasing the handling capacity of database server, improve operational efficiency, the present invention includes the server cluster 7 become by multiple stage database servers group；A database server in selected server cluster 7 is as digital independent server 1, and the remainder data storehouse server in server cluster 7 writes server 3 as data；
The data base of required process carried out subregion and corresponding partitions of database will be obtained is respectively stored in corresponding data write server 3, being written in the partitions of database of data write corresponding data write server 3 by digital independent server 1；Again after the partitions of database of data to be written write corresponding data write into Databasce 3, in server cluster 7, all of database server carries out real-time synchronization, so that every database server all stores the data base that data content is identical in server cluster 7.
Specifically, it is connected with each other between the multiple database servers in server cluster 7, usually, in described server cluster 7, at least includes four database servers.Any one database server in selected server cluster 7 is as digital independent server 1, after digital independent server 1 is selected, remainder data storehouse server in server cluster 7 writes server 3 as data automatically, multiple data write data servers 3 become data write server group 2, the read operation of digital independent server 1 primary responsibility data, and the write operation of data write server 3 primary responsibility data such that it is able to ensure the reliability of data, accelerate inquiry velocity.
For a data base, the product quantity of every day, customer quantity, client feedback etc. are likely to all increasing, and after data total amount reaches certain number, the speed of searching database will be substantially reduced.Additionally, increase along with data volume, the size of data base is also ceaselessly increasing, when the insufficient space beyond the restriction of single file size or hard disk is to hold so big file, when needing to separate data base, just create certain demand, at this time just can process by the mode of partitions of database.When being embodied as, the subregion of data base can be determined according to inquiry characteristic, specifically can carry out selection as required and determine, data base be carried out the detailed process of subregion known by those skilled in the art, repeat no more herein.
After pending partitions of database, the partitions of database obtained is respectively stored in corresponding data write server 3.When write data in needs are to corresponding partitions of database, read data to be written by digital independent server 1, and write in the partitions of database of corresponding data write server 3.After the partitions of database write data that any data is write server 3, all need between all of database server in server cluster 7 to perform a real-time synchronization operation, after having performed a real-time synchronization, the data base that content is identical is all stored in each database server in server cluster 7, it is stored concurrently in all of database server after existing aggregation of data in the data of above-mentioned write and partitions of database, so that follow-up inquiry, read-write operation, improve the efficiency of reading and writing data.
Further, real-time synchronization is carried out by rsyns mode between the database server in described server cluster 7.In the embodiment of the present invention, all database servers in server cluster 7 utilize rsyns mode to carry out the process of real-time synchronization known by those skilled in the art, repeat no more herein.Additionally, the database server in server cluster 7 adopts the innodb engine of MySQL to carry out digital independent and data write operation, namely database engine adopts the innodb engine of MySQL.
Further, described server cluster 7 can be connected with client 4 by active router 5 or standby router 6；Described active router 5 sends packet to standby router 6 timing, after preset time threshold, if standby router 6 does not receive packet, then realizes the connection between server cluster 7 and client 4 by standby router 6.
In the embodiment of the present invention, client 4 can be the existing terminal that can access server cluster 7, such as PC(computer), the terminal form such as smart mobile phone, client 4 is connected with server cluster 7 by the Internet, active router 5 or standby router 6.Under normal circumstances, client 4 is connected with server cluster 7 by active router 5, and reading or the write etc. that can realize data operate.Preset time threshold can be determined according to actually used demand, and active router 5 sends the time of packet to standby router 6 timing, the determination process of preset time threshold size is known by those skilled in the art, repeats no more herein.After client 4 is connected by standby router 6 is interior with server cluster 7, it can be ensured that the stability being connected between client 4 with server cluster 7 and reliability.
Database server in server cluster 7 is defined as digital independent server 1 and data write server 3 by the present invention, read and write abruption with fulfillment database, accelerate the speed of data base querying, partitions of database is respectively stored in corresponding data write server 3, and after each partitions of database write data, real-time synchronization is carried out between the database server in server cluster 7, so that the data base that each database server storage content is identical, can effectively reduce the load of database server, increase the handling capacity of database server, improve operational efficiency, safe and reliable.
Claims (5)
1. a database server SiteServer LBS, including the server cluster (7) become by multiple stage database servers group；It is characterized in that: the database server in selected server cluster (7) is as digital independent server (1), and the remainder data storehouse server in server cluster (7) writes server (3) as data；
The data base of required process carried out subregion and corresponding partitions of database will be obtained is respectively stored in corresponding data write server (3), being written in the partitions of database of data write corresponding data write server (3) by digital independent server (1)；Again after the partitions of database of data to be written write corresponding data write into Databasce (3), in server cluster (7), all of database server carries out real-time synchronization, so that every database server all stores the data base that data content is identical in server cluster (7).
2. database server SiteServer LBS according to claim 1, is characterized in that: carry out real-time synchronization by rsyns mode between the database server in described server cluster (7).
3. database server SiteServer LBS according to claim 1, is characterized in that: described server cluster (7) can pass through active router (5) or standby router (6) is connected with client (4)；Described active router (5) sends packet to standby router (6) timing, after preset time threshold, if standby router (6) does not receive packet, then realize the connection between server cluster (7) and client (4) by standby router (6).
4. database server SiteServer LBS according to claim 1, is characterized in that: the database server in server cluster (7) adopts the innodb engine of MySQL to carry out digital independent and data write operation.
5. database server SiteServer LBS according to claim 1, is characterized in that: at least include four database servers in described server cluster (7).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610097075.5A CN105787006A (en) | 2016-02-22 | 2016-02-22 | Load balancing system for database servers |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610097075.5A CN105787006A (en) | 2016-02-22 | 2016-02-22 | Load balancing system for database servers |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105787006A true CN105787006A (en) | 2016-07-20 |
Family
ID=56402730
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610097075.5A Pending CN105787006A (en) | 2016-02-22 | 2016-02-22 | Load balancing system for database servers |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105787006A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108241641A (en) * | 2016-12-23 | 2018-07-03 | 航天星图科技（北京）有限公司 | A kind of operating method of distributed data base |
| CN111221902A (en) * | 2019-11-22 | 2020-06-02 | 成都翔升科技有限责任公司 | Database load balancing method based on application layer separate table access |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101119414A (en) * | 2007-09-19 | 2008-02-06 | 华为技术有限公司 | Method and system to access database |
| CN102299959A (en) * | 2011-08-22 | 2011-12-28 | 北京邮电大学 | Load balance realizing method of database cluster system and device |
| US20130124458A1 (en) * | 2011-11-16 | 2013-05-16 | Tomas Barreto | Resource effective incremental updating of a remote client with events which occurred via a cloud-enabled platform |
| CN103902548A (en) * | 2012-12-25 | 2014-07-02 | 航天信息股份有限公司 | System and method for having access to data base and registering, ticket booking and online shopping system |
| US20150271150A1 (en) * | 2014-03-19 | 2015-09-24 | Bluefin Payment Systems, LLC | Systems and methods for decryption as a service |
-
2016
- 2016-02-22 CN CN201610097075.5A patent/CN105787006A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101119414A (en) * | 2007-09-19 | 2008-02-06 | 华为技术有限公司 | Method and system to access database |
| CN102299959A (en) * | 2011-08-22 | 2011-12-28 | 北京邮电大学 | Load balance realizing method of database cluster system and device |
| US20130124458A1 (en) * | 2011-11-16 | 2013-05-16 | Tomas Barreto | Resource effective incremental updating of a remote client with events which occurred via a cloud-enabled platform |
| CN103902548A (en) * | 2012-12-25 | 2014-07-02 | 航天信息股份有限公司 | System and method for having access to data base and registering, ticket booking and online shopping system |
| US20150271150A1 (en) * | 2014-03-19 | 2015-09-24 | Bluefin Payment Systems, LLC | Systems and methods for decryption as a service |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108241641A (en) * | 2016-12-23 | 2018-07-03 | 航天星图科技（北京）有限公司 | A kind of operating method of distributed data base |
| CN111221902A (en) * | 2019-11-22 | 2020-06-02 | 成都翔升科技有限责任公司 | Database load balancing method based on application layer separate table access |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10545842B2 (en) | Automated local database connection affinity and failover | |
| US10701012B2 (en) | Method, apparatus and system for customer service information forwarding | |
| US9684702B2 (en) | Database redistribution utilizing virtual partitions | |
| US20100312749A1 (en) | Scalable lookup service for distributed database | |
| CN112559637B (en) | Data processing method, device, equipment and medium based on distributed storage | |
| CN102662992A (en) | Method and device for storing and accessing massive small files | |
| CN104111804A (en) | Distributed file system | |
| CN103530388A (en) | Performance improving data processing method in cloud storage system | |
| CN103440290A (en) | Big data loading system and method | |
| CN104820717A (en) | Massive small file storage and management method and system | |
| US11960506B2 (en) | Data processing method and system for cloud platform, and electronic apparatus and storage medium | |
| CN102194009A (en) | Database hosting method and database hosting platform system | |
| CN105677251A (en) | Storage system based on Redis cluster | |
| CN103501319A (en) | Low-delay distributed storage system for small files | |
| CN113806300B (en) | Data storage method, system, device, equipment and storage medium | |
| CN105468297A (en) | Quick synchronization method for master and slave device data in cloud storage system | |
| CN110427364A (en) | A kind of data processing method, device, electronic equipment and storage medium | |
| CN104750757A (en) | Data storage method and equipment based on HBase | |
| CN116166191A (en) | Integrated system of lake and storehouse | |
| CN105787006A (en) | Load balancing system for database servers | |
| CN106302667A (en) | Code management system and method | |
| CN107180034A (en) | The group system of MySQL database | |
| CN103744626A (en) | Data writing method based on memory replacement | |
| WO2023029485A1 (en) | Data processing method and apparatus, computer device, and computer-readable storage medium | |
| EP4136809B1 (en) | Distributed flow processing and flow cache |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160720 |