March 23, 2015 at 9:05 am
Here it is more explained.
I have a FCI with 3 Nodes, node 1, one database to be Primary, Node 2, two databases to be primary, Node 3, Passive node, and a Stand alone SQL Server Instance to host the 3 Secondary replicas whitin the WSFC.
Question 1.- Can I have 3 databases, 1 in Node 1 and 2 in Node 2 to be Primary replicas? and have the second replica (for all 3 databases)in another Stand alone SQL Server Instance which will be part of a WSFC?
Question 2.- If whitin the FCI, database 1 in Node 1, failovers to the passive node 3, what happens with the AlwaysOn Primary replica? How does it moves to the 3rd node?.
Complicated questions I guess, but trying to combine 2 different Failover practices by Microsoft.
Your help is greagly appreciated.
Oscar Campanini
March 23, 2015 at 11:31 am
Your current setup is not clear and you seem to be making incorrect use of the terminology.
Pablo Campanini-336244 (3/23/2015)
I have a FCI with 3 Nodes, node 1, one database to be Primary, Node 2, two databases to be primary, Node 3, Passive node, and a Stand alone SQL Server Instance to host the 3 Secondary replicas whitin the WSFC.
You have a WSFC with 3 nodes, correct?
To me it seems you have the following
Node1 - 1st FCI with one primary database
Node2 - 2nd FCI with two primary databases
Node3 - standalone instance required to be secondary for FCI 1 and FCI 2
Is this correct, if not please provide more detail?
Pablo Campanini-336244 (3/23/2015)
Question 1.- Can I have 3 databases, 1 in Node 1 and 2 in Node 2 to be Primary replicas? and have the second replica (for all 3 databases)in another Stand alone SQL Server Instance which will be part of a WSFC?
Yes, there would be 2 availability groups which would use the standalone replica as a secondary.
Pablo Campanini-336244 (3/23/2015)
Question 2.- If whitin the FCI, database 1 in Node 1, failovers to the passive node 3, what happens with the AlwaysOn Primary replica? How does it moves to the 3rd node?.
Failover would be a manual process, you have to actually failover the availability group(s) using TSQL or the AlwaysOn group GUI.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2015 at 7:23 am
Thanks for your response, at this point we do not have WSFC, we just have FCI with those 3 nodes.
2 nodes have 3 primary databases(Node 1 = 1 database, Node 2 = 2 databases, Node 3 = Passive).
Question: When I implement HAG with WSFC, can I have those 3 databases "in different SQL Instances" as primary replica to have the secondary replica in ONE SQL INSTANCE? (the 3 databases?).
Appreciate your help.
March 26, 2015 at 6:41 am
Pablo Campanini-336244 (3/25/2015)
Thanks for your response, at this point we do not have WSFC, we just have FCI with those 3 nodes.
If you have a Failover Cluster Instance then you will have a Windows Server Failover Cluster.
Seems you are confused and because of this will be difficult to help you.
Read through my stairway series on this site starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply