如何使用mscs建立sql server集群（How to use MSCs to build a SQL Server Cluster）.docVIP

如何使用mscs建立sql server集群（How to use MSCs to build a SQL Server Cluster） Tong Genghua collection Cluster is a kind of technical solution, which combining hardware and software, Web, Email and database services provide high availability and high scalable architecture. This paper will analyze the cluster type, and then focus on how to establish a solution scheme based on Microsoft cluster. Cluster type Clusters are divided into two types: load balancing and failover (Failover). Load balancing cluster will load all resources dispersed into the cluster, which involves distributed network transmission across multiple front-end server. The load balancing cluster so that each server is available with the average load is, in order to improve the overall system performance and scalability. This kind of cluster is generally used for Web and COM+ program, the cluster nodes supported more than two. Failover cluster mainly for the availability of the system hardware and software at fault. It monitors the system resources to determine when to initiate failover. When a fault occurs, the cluster will transfer resources from the failed server to other servers in the cluster, in order to restore the accessibility of resources. A failover cluster with fault tolerance requires a lot of hardware and software, it can determine the application state of the fault occurred in the hardware and software of real-time fault recovery, including the recovery to the current state of the application. A high availability cluster must be a fault-tolerant cluster, but it can not provide the same error and failover cluster recovery ability. Microsoft Cluster Service (MSCS) is a specific fault better cluster high availability cluster. Compared with fault tolerant cluster and dedicated it, the hardware required less, but can operate more types of applications. At the same time, it can also be the fault of hardware and software of the recovery, but the failure to restore to the application state. High availa