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: Yesterday @ 11:17 PM
Points: 6,490, Visits: 13,968
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: Sunday, October 19, 2014 8:33 PM
Points: 1,285, Visits: 2,963
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: Yesterday @ 11:17 PM
Points: 6,490, Visits: 13,968
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, October 21, 2014 5:54 AM
Points: 868, Visits: 1,141
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: Yesterday @ 11:17 PM
Points: 6,490, Visits: 13,968
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse