The invention relates to a
batch processing request-based Microsoft
SQL server database cluster. The cluster consists of two parts, wherein a gateway and backups thereof are arranged at the front end of the cluster, and two or more of
database server nodes are arranged at the rear end of the cluster; each node is provided with a structured
query language (
SQL)
Server example and a cluster proxy and is not provided with a shared disk structure; and each node has an independent and consistent
data set, and the cluster is only provided with a host. The gateway is used for managing the integral cluster; and for each
client link, the gateway opens a
database link corresponding to each node simultaneously to receive, analyze and optimize all
client requests, wherein the
client requests are divided into two classes, namely the read-only query requests and the data updating requests; for the read-only query requests, the gateway sends the requests to any one node to execute the requests according to a set load balancing
algorithm so as to realize the real
database access load balancing and improve the performance of a
system; and the updating requests are sent to the host of the cluster to be executed, and are subjected to synchronous data by the host to other nodes to keep the
data set of each node real-time and consistent, eliminate a single-point fault source and realize
system fault tolerance. The integral cluster can improve the performance, availability and reliability of the
system obviously and solve various problematic issues of the performance, single-point faults, zero
data loss and the like in the field of databases, and is a comprehensive database cluster scheme.