Always On implementation for Multi-Subnet Failover requirements:
1.Windows servers 2
2.Windows Server Failover Cluster(WSFC) services need to install on both servers
3.Cluster IP's 2
4.Listener IP's 2 ( Note: Listener name should be the same name for both IP's)
SQL Server 2012 AlwaysOn: Multisite/Multi-Subnet Failover Cluster Instance:
https://msdn.microsoft.com/en-us/library/hh750283.aspx?f=255&MSPPError=-2147217396
AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups:
https://msdn.microsoft.com/en-us/library/jj191711.aspx
************************Additional references
http://www.sqlskills.com/blogs/joe/alwayson-architecture-guide-building-a-high-availability-and-disaster-recovery-solution-by-using-failover-cluster-instances-and-availability-groups/
Architecture guide for each design pattern:
- The first paper covering the multi-site FCI pattern was written by Mike Weiner, Sanjay Mishra and Min He –> “SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance”
- The second paper covering the AGs for HA & DR design pattern was published June 23rd, and was co-authored by Sanjay Mishra and me –> “AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups”
- And today the third design pattern paper, covering FCIs for local HA and AGs for DR, also co-authored by Sanjay Mishra and me, can be downloaded here –> “AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups”
