- AO: Always ON
- FCI: Failover Cluster Instance
- WSFC: Windows Server Failover Cluster
I'm scratching the surface of AO. I currently have one SQL 2012 FCI on a WSFC. Which means one Active node at a given time. I cannot set up an AO with this, can I? Logically speaking I need “at least two” active (up & running) SQL Server instances to set up. And in Microsoft's example they used a total of 5 nodes, and the minimum would be 3 for a AO on FCI + WSFC right?
Here is what my FCI looks like.
There is no point in having AO when only 1 instance of SQL is running at a given time. Right ?
If yes what would I need to set up AO?
- A new Node in the Cluster or
- Any other Stand alone SQL Should(same version) do as well?