SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2012 AlwaysOn Groups and FCIs Part 4


SQL Server 2012 AlwaysOn Groups and FCIs Part 4

Author
Message
Perry Whittle
Perry Whittle
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27855 Visits: 17351
Comments posted to this topic are about the item SQL Server 2012 AlwaysOn Groups and FCIs Part 4

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
curious_sqldba
curious_sqldba
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3782 Visits: 3669
thank you for the wonderful post. I do have few questions:

i) I was able to set AG with partial clustering ( no quorum ,shared resources), can i still set up auto failover in AG?

ii) How do u decide which IP to use, does it have to be outside of the range listed in GUI?
Perry Whittle
Perry Whittle
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27855 Visits: 17351
curious_sqldba (5/20/2014)
thank you for the wonderful post.

You're welcome.


curious_sqldba (5/20/2014)
i) I was able to set AG with partial clustering ( no quorum ,shared resources), can i still set up auto failover in AG?

A cluster is a cluster is a cluster. If you have no disk or fileshare witness you are relying on Majority Node Set, for this you need an odd number of nodes. How many nodes are in the cluster?


curious_sqldba (5/20/2014)
ii) How do u decide which IP to use, does it have to be outside of the range listed in GUI?

Not entirely sure what you mean here, could you expand a little

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Carlton Leach
Carlton Leach
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1176 Visits: 1301
Good read mate.

Trying to get my head around this...Potentially a stupid question but does it allow you to:
- create a 2 node cluster, 2 Standalone instance, with no shared disk?

If so, in the above scenario:
- If primary fails, same as DB mirroring: force online with data-loss accepted
- If secondary instance fails, does that still wipe out the AWO group? (on node majority).

Carlton.
Perry Whittle
Perry Whittle
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27855 Visits: 17351
Carlton Leach (5/21/2014)
does it allow you to:
- create a 2 node cluster, 2 Standalone instance, with no shared disk?

Yes that's pretty much a basic configuration with an AlwaysOn group across 2 replicas


Carlton Leach (5/21/2014)

If so, in the above scenario:
- If primary fails, same as DB mirroring: force online with data-loss accepted

If you don't have synchronous with auto failover then yes.


Carlton Leach (5/21/2014)
- If secondary instance fails, does that still wipe out the AWO group? (on node majority).

Carlton.
not if you configure a cluster witness appropriately

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
kgottfredsen
kgottfredsen
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 2770
Thanks for the informative article! I realize that this article is almost a year old, but I have a few questions that I'm hoping you can help me with.

I see that you have different instance names for the FCI and the stand-alone instances within the AG. Would it be possible to use the same instance names for all instances? I'm not sure if that would be allowed since all instances are part of the same WSFC.

Would it be possible to use the same drive letters\paths for the data and log files with all instances? This would prevent having issues with things like ALTERing the DATABASE to ADD FILEs on the primary and having it fail due to the drives being different on secondary replicas.

Would application and user connections connect to the AG listener name?

How reliable has this configuration been? Have you run into any unanticipated issues with this setup?

Thanks!!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search