SQL Server 2008r2 cluster (i)

Windows SQL Server 2008r2 cluster setup

Nuzhihai

computer name	operating system	assume role	ip address	note
ad05.bjn99.cn	windows server 2008R2	ad, DNS, ISCSI	192.168.3.50
SQL01.bjn99.cn	Windows Server 2008R2	SQL01	192.168.3.51
			10.10.10.1	Heartbeat NIC
SQL02.bjn99.cn	Windows Server 2008R2	SQL02	192.168.3.52
			10.10.10.2	Heartbeat NIC

the role of SQL cluster: cluster systems are highly scalable, highly available, and easier to manage, typically symmetric clusters and asymmetric clusters (quoted in a book), and typical applications for so-called asymmetric clusters are failover clusters (such as SQL Failover clustering). The symmetric cluster can be understood as NLB, any server within the cluster, evenly sharing the client access to it, once one of the servers fails, the other machines will automatically take over. Achieve seamless takeover. Asymmetric clustering, and dual-machine hot standby technology similar to the implementation of the client access, only one of the servers in operation, when the problem occurs, according to the heartbeat mechanism to achieve failover;

Environment Preparation:

Node computer two: SQL01 and SQL02, installed with Windows Server R2, joined to the domain. SQL01 two NIC IP addresses are 192.168.3.51, 10.10.10.1 (Heartbeat network)

SQL02 two NIC IP addresses are 192.168.3.52, 10.10.10.2 (Heartbeat network)

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/83/FF/wKioL1eDNCbTUlEpAABeLN0AXrA076.jpg "/>

1. Add the SQL01 and SQL02 servers to the BJN99 domain separately and install them separately in the Server Management feature installation interface. NET3.5.1 function;

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/84/00/wKiom1eDNCfg9YS_AACsiqizaKw158.png "/>650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/83/FF/wKioL1eDNCeQeO6OAACyDGroYH0493.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/84/00/wKiom1eDNCii3UukAADlqJ2rH9U778.png "/>

2, the experimental environment we use AD05 server to simulate iSCSI shared storage (using the gong to optical shared storage software is iscsitartget_public); double-click Install iscsitartget_public Shared storage installation Step introduction;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/84/00/wKiom1eDNCijLbS2AAB8FlgbiA0518.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/83/FF/wKioL1eDNCmR57_EAABIwQ72j1o367.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/84/00/wKiom1eDNCnzefxuAAB9NDdHmEQ757.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/83/FF/wKioL1eDNCnC9B4oAABDluXN9Y8045.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/84/00/wKiom1eDNCqjsQcYAABT-uxrAkE536.jpg "/>

This article from "Nuzhihai" blog, reproduced please contact the author!

SQL Server 2008r2 cluster (i)