One of the most highly available configurations for SQL Server in AlwaysOn: Environment readiness

The AlwaysOn Availability Group feature is a high availability and disaster recovery solution that provides an enterprise-class solution that replaces database mirroring. The AlwaysOn Availability Groups feature is introduced in SQL Server 2012, which maximizes the availability of a set of user databases to the enterprise.  An availability group supports a failover environment for a discrete set of user databases, known as availability databases, which collectively implement failover. An availability group supports a set of read-write primary databases and a corresponding secondary database of one to four groups. Optionally, the secondary database can have read-only access and/or some backup operations. supports up to five availability replicas. An availability replica is an instantiation of an availability group that is hosted by a specific instance of SQL Server that maintains a local copy of each availability database that belongs to this availability group. Each availability group supports one primary replica and a maximum of four secondary replicas. For more information on AlwaysOn Availability Group concepts, please refer to the TechNet website at the following link:

https://technet.microsoft.com/zh-cn/library/hh510230 (v=sql.110). aspX

This series will give you a detailed introduction to SQL Server AlwaysOn High-availability configuration (two nodes, using shared folders for quorum), with a total of 9 small chapters, as follows:

• Environment preparation

• Installing database Features

• To install the Failover Clustering feature

• Create a cluster

• Configure Quorum

• Enable AlwaysOn Features

• New Database

• New Availability Group

• Adding listeners

The following will be the first small section of the sharing-environment preparation

--------------------------------------------------------------------------------------------------------------

1.1 This demo uses the following server list:

No.	Host Name	Server role	Operating system	IP Address	Heartbeat IP
1	Sqldc	Ad/dns	Windows Server R2	192.168.1.40/24	/
2	SQL01	Database server	Windows Server R2 SQL Server Enterprise SP1	192.168.1.41/24	10.0.0.10/24
3	SQL02	Database server	Windows Server R2 SQL Server Enterprise SP1	192.168.1.42/24	10.0.0.20/24
4	Cluster IP			192.168.1.88/24	/
5	Listener IP			192.168.1.99/24	/

1.2 This demo was completed on the Hyper-V virtualization platform with a total of 3 virtual machines, as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/28/wKioL1X20LLSdajvAABYnr6feFU621.jpg "title=" 1.png " alt= "Wkiol1x20llsdajvaabynr6fefu621.jpg"/>

This demo has been pre-configured network and computer name, and ready for the domain environment, about the construction of the domain environment, please refer to the following link: http://stephen1991.blog.51cto.com/8959108/1659598

1.3 In the server SQL01 and SQL02 need to configure two network cards, a LAN network, a heartbeat network, as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/2B/wKiom1X2zoyj4Ok3AAGf2bb59rE825.jpg "title=" 2.png " alt= "Wkiom1x2zoyj4ok3aagf2bb59re825.jpg"/>

1.4 Heartbeat network only configure IP and subnet mask, remember to uncheck the "Register this connection's address in DNS"

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/2B/wKiom1X2zpziDqkJAATMMDClBdc657.jpg "title=" 3.png " alt= "Wkiom1x2zpzidqkjaatmmdclbdc657.jpg"/>

1.5 In order to facilitate the experiment, this demo directly manually shut down the server sql01,sql02 firewall

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/2B/wKiom1X2zqmxug-AAALhR2H1WEo568.jpg "title=" 4.png " alt= "Wkiom1x2zqmxug-aaalhr2h1weo568.jpg"/>

SQL Server Preparation please refer to:

xenapp_xendesktop_7.6 The nine:SQL Server database server planning and Deployment

http://stephen1991.blog.51cto.com/8959108/1661577

This article is from the "Huang Jinhui column" blog, be sure to keep this source http://stephen1991.blog.51cto.com/8959108/1694733

One of the most highly available configurations for SQL Server in AlwaysOn: Environment readiness