Arestas (5/21/2015)
I am testing a SQL Server 2012 AllwaysOn Wsfc implementation.The architecture i am trying to implement is as follows:
3 Servers. 2 in primary site and 1 in a secondary site.
This is quite usual.
One question, will the 2 nodes on the primary site host separate standalone instances of SQL server or do you plan to implement a failover cluster instance of SQL Server?
Arestas (5/21/2015)
They will all be part of the Windows Cluster.
You don't have a choice, this is a pre requisite 😉
Arestas (5/21/2015)
Will have automatic failover between clusters.
See my question above, will you be using a failover cluster instance of SQL server on nodes 1 and 2?
Arestas (5/21/2015)
Manual failover to secondary site.
If you use an FCI on nodes 1 and 2 on the primary site you don't have a choice, this is a restriction that is applied when incorporating an FCI as a replica into an AlwaysOn availability group.
Arestas (5/21/2015)
I want to setup AllwaysOn replication in a dedicated network.My problem (Just want to clarify how i can make this work) is that in the primary site i will have databases running on both servers. When i implement the failover i want to force the replication to go trough a specific network. Till here its a simple setup.
But when one of the databases that are running on Node1 (and using nic2 of Node1) fails over to Node2 the nic it was using wont exist on Node2. So it will stop replication data to Node3 site...
Can anyone please clarify me on how its the best way to setup this?
Any documentation, etc...
If i wasn't clear enough on my explanation please ask for more details.
Regards,
Arestas
To offload your mirror traffic down a separate network you'll need to do quite a bit of planning and testing, as well as architecting the necessary network layer(s).
What do you mean by "But when one of the databases that are running on Node1 (and using nic2 of Node1) fails over to Node2 the nic it was using wont exist on Node2. ", why do you assume the network will not exist?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉