I want to deploy Multi Site SQL Server HA/DR Solution. I am not sure if I use FCI/AG. In my case whenever the wan link is down at Site1 my ISP is redirecting my wan traffic to Site2.
I was thinking of deploying Node1 at Site1 and Node2 at Site2 and File Share Witness at Site3/Cloud, also making sure SAN - SAN Async Replication in place. So whenever my Site1 wan is failing I want the SQL at DR site to be active.
So Kindly Suggest what kind of deployment will be best for this case.
I have SQL Server 2012 Enterprise and Windows Server 2012 R2 Standard. I have to chose whether AOFCI or AOAG.
I have experience with 2 Node SQL Cluster but in single site. But this is new application and I want to have multi-site (multi-subnet) deployment. I have very less knowledge about AOAG but willing to learn of course.
Suppose if I chose to implement FCI i will have Node1 at Site1 with one shared disk1 from SAN1 and Node2 at Site2 with same disk1 from SAN2 but off-line. There will be SAN-SAN asynchronous replication in place and I will use Site3/Cloud for File Share Witness. Will this be the good solution ? Or you suggest AOAG assuming Node1(primary) and Node2(secondary replica - synchronous) at Site1 and Node3(secondary replica - asynchronous) at Site2.