SQL Server 2008r2 cluster (i)

Source: Internet
Author: User
Tags failover

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.