Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 AlwaysOn Groups and FCIs Part 4 Expand / Collapse
Author
Message
Posted Tuesday, May 20, 2014 12:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 7,547, Visits: 15,558
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"
Post #1572498
Posted Tuesday, May 20, 2014 2:06 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 27, 2015 8:14 AM
Points: 1,334, Visits: 3,136
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?
Post #1572894
Posted Tuesday, May 20, 2014 3:46 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 7,547, Visits: 15,558
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"
Post #1572933
Posted Wednesday, May 21, 2014 10:00 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 25, 2015 8:45 AM
Points: 868, Visits: 1,217
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.
Post #1573250
Posted Friday, May 23, 2014 11:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 7,547, Visits: 15,558
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"
Post #1574153
Posted Friday, April 10, 2015 2:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 27, 2015 8:20 AM
Points: 123, Visits: 2,420
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!!



Post #1676277
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse