CN102693291A - Method for achieving SQL (structured query language) -Server load balance cluster - Google Patents
Method for achieving SQL (structured query language) -Server load balance cluster Download PDFInfo
- Publication number
- CN102693291A CN102693291A CN2012101492288A CN201210149228A CN102693291A CN 102693291 A CN102693291 A CN 102693291A CN 2012101492288 A CN2012101492288 A CN 2012101492288A CN 201210149228 A CN201210149228 A CN 201210149228A CN 102693291 A CN102693291 A CN 102693291A
- Authority
- CN
- China
- Prior art keywords
- cluster
- data
- sql
- database
- node
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for achieving an SQL (structured query language)-Server load balance cluster. The method includes: detecting changed data in databases through a host middleware in each database, then analyzing SQL statements resulting in data changes, adopting different data synchronization strategies according to analyzed SQL statement types, and performing real-time concurrency and synchronization for the changed data to other nodes so as to guarantee consumption minimization of synchronization and data consistency of multi-copies of data of each node at any time. The cluster configuration of the method provides a unified IP (internet protocol) address and a port number to the outside for load response to requests of front-end application so as to achieve load balance of the cluster.
Description
Technical field
The present invention relates to a kind of Computer Database application technology, specifically a kind of method that realizes the SQL-Server load balancing cluster.
Background technology
Along with the development of enterprise, the variation of application system function is accompanied by the growth of data; Make the SQL Server database table that runs on the windows platform reveal the bottleneck that lets the user be difficult to accept; As: the request response is slow, the speed the when processing speed of the system system that is starkly lower than has just reached the standard grade, database server side CPU can't bear the heavy load; Memory source also is faced with the situation that exhausts, and the IO utilization factor of disk is high especially.The developing steps that all our SQL Server databases of aspect explanation are not caught up with enterprise and data at aspect of performance, Database Systems are faced with the danger of collapse and possibility lost customer significant data at any time.
In the face of this predicament; At present SQL Server uses cluster more widely, though for example the two-node cluster hot backup software of the failover clustering of Microsoft, SQL Server mirror image, third company etc. can satisfy to a certain extent that the part client guarantees data security, reliable requirement, they do not possess the function of load balancing; Request response that can't the dynamic load client; Can't reduce the load and the pressure of database service end, and the utilization factor of main frame is not utilized fully 50% yet.Because the deficiency of above-mentioned technology; We are based on the middleware of host in the multinode database; Through detecting the data that change in the database, analyze the SQL statement that causes data variation, the SQL statement type that analyzes is taked the different synchronization strategy; The data that change are concurrent and be synchronized to other each nodes in real time, unified virtual ip address and the port numbers that connects externally is provided.Whole detection is analyzed, and synchronous process is transparent to the user, thus the load balancing of good fulfillment database, the load of sharing and alleviating main frame.
Summary of the invention
The objective of the invention is the purpose of this invention is to provide a kind of method of the SQL of realization Server cluster load balancing.
The objective of the invention is to realize by following mode; Utilize the middleware of host on node to detect the data that change in the database; Analysis causes the SQL statement of data variation; And the SQL statement type that analyzes taked the different synchronization strategy, Real-time and Concurrent is synchronized to other each nodes, has guaranteed the many piece of data of each node consistance of data at any time.The cluster configuration of this method externally provides the unified IP address of visit and the request that port numbers is come the load response front end applications, thereby realizes the load-balancing function of cluster.Concrete steps are following:
SQL Server 2008 R2 at first are installed on each node of cluster; On each node, installing respectively then and disposing needs the host to arrive the middleware in the database; This middleware meeting host is in the engine of SQL Server database; The configuration manager of cluster is integrated in the SQL Server Management Studio management tool, convenient configuration, management and maintenance.Simultaneously the load balancing cluster of the method is based on that each database realizes, the cluster granularity is littler, should use very flexible.
The invention has the beneficial effects as follows: guarantee the safe reliability of data, both can support not have the shared disk framework, also can support the shared disk framework; Data sync between clustered node is duplicated; A database is all arranged on each node; The scheme of sustainable expansion realizes load balancing; Eliminate the Single Point of Faliure of database host; Synchronous efficiency is high, supports the strange land; Realizability can extending transversely; Synchronous with SQL statement, consume minimum, save bandwidth.Simultaneously the load balancing cluster of the method is based on that each database realizes, the cluster granularity is littler, should use very flexible.The load balancing cluster of this method provides database auditing, smart synchronization strategy, and the load balancing strategy, fault detect, virtual IP address, automatic fault shifts, and complete functions such as early warning notice are in order to satisfy needs of different applications.
Description of drawings
Fig. 1 is a cluster SiteServer LBS structural representation.
Embodiment
Explanation at length below with reference to Figure of description method of the present invention being done.
Utilize the middleware of host on node to detect the data that change in the database; Analysis causes the SQL statement of data variation; And the SQL statement type that analyzes taked the different synchronization strategy; Real-time and Concurrent is synchronized to other each nodes, has guaranteed the many piece of data of each node consistance of data at any time.The cluster configuration of this method externally provides the unified IP address of visit and the request that port numbers is come the load response front end applications, thereby realizes the load-balancing function of cluster.
Embodiment
Each node of cluster is all disposed host's middleware; And all set up portion on each node and need the data in synchronization storehouse; After configuring, the unified virtual ip address and the designated ends slogan of this cluster of visit externally is provided, for example 8000; The IP address that the application layer configuration connects database is the cluster virtual IP address, and port is 8000.Submitted the request of modification data to when the front end application after; The data of one of them node can change in the cluster; The middleware of host in database can detect the SQL statement that causes that this node data changes simultaneously; Host's middleware can be analyzed this SQL statement then, gives other node synchronously with this SQL statement Real-time and Concurrent, thereby has guaranteed in the cluster consistance of data between each node.
After the request of data query has been submitted in the front end application to; The middleware of host in database can detect the SQL statement of application request and analyze; Loading condition according to each node of cluster is distributed to other each nodes with the SQL statement of asking then; Basically accomplish average dispense request response, improve the response speed of whole application system, thereby realize the load balancing of cluster.
This is owing to traditional SQL Server cluster or be the mirror image cluster; Be failover clustering, or be the cluster of backup functionality, all do not have the characteristics of load balancing; The problem of high load capacity pressure that can not resolution system only is the reliability that has guaranteed data.The inventive method not only makes SQL Server cluster possess the characteristics of load balancing, and when a node broke down therein, the connection meeting of its front end is transparent automatically transferred to other nodes, thereby realized the continuity of application access.Secondly the cluster of this method deployment is because all there is a data in synchronization in real time, so also guaranteed the high reliability of data simultaneously on each node.This method can have been saved user's expense largely based on there not being the disk framework of sharing.It is bright that correspondence is used for finishing full impregnated, only externally provides a virtual ip address and port numbers as unified connected mode.This method has also solved the high difficult problem of database host load, and the performance of application system has also been brought great lifting.
Except that the described technical characterictic of instructions, be the known technology of those skilled in the art.
Claims (1)
1. method that realizes the SQL-Server load balancing cluster; It is characterized in that detecting the data that change in the database, analyze the SQL statement that causes data variation then, take different data synchronization strategy according to the SQL statement type that analyzes through the middleware of host in each database; With concurrent other each nodes that is synchronized to of data in real time that change; Guarantee that synchronous consumption minimizes, guaranteed the many piece of data of each node consistance of data at any time, the cluster configuration of this method externally provides the unified IP address of visit and the request that port numbers is come the load response front end applications; Thereby realize the load-balancing function of cluster, concrete steps are following:
SQL Server 2008 R2 at first are installed on each node of cluster; On each node, installing respectively then and disposing needs the host to arrive the middleware in the database; This middleware meeting host is in the engine of SQL Server database; The configuration manager of cluster is integrated in the SQL Server Management Studio management tool, and after the request of data query had been submitted in the front end application to, the middleware of host in database can detect the SQL statement of application request and analyze; Loading condition according to each node of cluster is distributed to other each nodes with the SQL statement of asking then; Basically accomplish average dispense request response, improve the response speed of whole application system, thereby realize the load balancing of cluster.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101492288A CN102693291A (en) | 2012-05-15 | 2012-05-15 | Method for achieving SQL (structured query language) -Server load balance cluster |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101492288A CN102693291A (en) | 2012-05-15 | 2012-05-15 | Method for achieving SQL (structured query language) -Server load balance cluster |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102693291A true CN102693291A (en) | 2012-09-26 |
Family
ID=46858725
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012101492288A Pending CN102693291A (en) | 2012-05-15 | 2012-05-15 | Method for achieving SQL (structured query language) -Server load balance cluster |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102693291A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104049690A (en) * | 2014-06-10 | 2014-09-17 | 浪潮电子信息产业股份有限公司 | Model design method by using critical application host to cope with high concurrent business |
| CN104869166A (en) * | 2015-05-28 | 2015-08-26 | 北京呈创科技股份有限公司 | Desktop cloud cluster system and desktop cloud cluster system information interaction method |
| CN106708826A (en) * | 2015-07-30 | 2017-05-24 | 中兴通讯股份有限公司 | Data processing method and apparatus, and data query method and apparatus |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169785A (en) * | 2007-11-21 | 2008-04-30 | 浪潮电子信息产业股份有限公司 | Clustered database system dynamic loading balancing method |
| US20110119251A1 (en) * | 2009-11-16 | 2011-05-19 | Dell Products L.P. | System and Method for SQL Query Load Balancing |
| CN102254031A (en) * | 2011-08-03 | 2011-11-23 | 无锡浙潮科技有限公司 | Batch processing request-based Microsoft SQL server database cluster |
-
2012
- 2012-05-15 CN CN2012101492288A patent/CN102693291A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169785A (en) * | 2007-11-21 | 2008-04-30 | 浪潮电子信息产业股份有限公司 | Clustered database system dynamic loading balancing method |
| US20110119251A1 (en) * | 2009-11-16 | 2011-05-19 | Dell Products L.P. | System and Method for SQL Query Load Balancing |
| CN102254031A (en) * | 2011-08-03 | 2011-11-23 | 无锡浙潮科技有限公司 | Batch processing request-based Microsoft SQL server database cluster |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104049690A (en) * | 2014-06-10 | 2014-09-17 | 浪潮电子信息产业股份有限公司 | Model design method by using critical application host to cope with high concurrent business |
| CN104869166A (en) * | 2015-05-28 | 2015-08-26 | 北京呈创科技股份有限公司 | Desktop cloud cluster system and desktop cloud cluster system information interaction method |
| CN106708826A (en) * | 2015-07-30 | 2017-05-24 | 中兴通讯股份有限公司 | Data processing method and apparatus, and data query method and apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108469988B (en) | Task scheduling method based on heterogeneous Hadoop cluster | |
| CA2910270C (en) | Efficient read replicas | |
| US7730057B2 (en) | Computer data systems implemented using a virtual solution architecture | |
| Zheng et al. | PaxosStore: high-availability storage made practical in WeChat | |
| US9218401B2 (en) | Systems and methods for remote access to DB2 databases | |
| WO2015021215A1 (en) | Data bus architecture for inter-database data distribution | |
| CN102254031A (en) | Batch processing request-based Microsoft SQL server database cluster | |
| CN103227754A (en) | Dynamic load balancing method of high-availability cluster system, and node equipment | |
| US20190005106A1 (en) | Reliable hierarchical storage management with data synchronization | |
| US10826812B2 (en) | Multiple quorum witness | |
| CN102868744A (en) | Automated integrated management method for realizing SaaS (Software as a Service) and IaaS (Infrastructure as a Service) | |
| CN102682117B (en) | A kind of method of data-base cluster data quick copy | |
| CN103150304A (en) | Cloud database system | |
| US20140258507A1 (en) | System and methods for remote access to ims databases | |
| WO2015043391A1 (en) | Data synchronization for remote and local databases | |
| CN112199427A (en) | Data processing method and system | |
| CN101727496A (en) | Method for realizing load balancing cluster of MICROSOFT SQL SERVER database | |
| CN111552540B (en) | Resource synchronization method based on VMware cloud platform and super-fusion cloud platform | |
| Mühlbauer et al. | ScyPer: a hybrid OLTP&OLAP distributed main memory database system for scalable real-time analytics | |
| CN111541599B (en) | Cluster software system and method based on data bus | |
| CN102693291A (en) | Method for achieving SQL (structured query language) -Server load balance cluster | |
| Li et al. | Research and application of server cluster load balancing technology | |
| CN107203639A (en) | Parallel file system based on High Performance Computing | |
| CN106257424A (en) | A kind of method that distributed data base system based on KVM cloud platform realizes automatic telescopic load balancing | |
| KR20120118550A (en) | An architecture of a high performance distributed main memory database management system for massive data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120926 |