Timeline for Temporarily splitting a SQL Server cluster
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 5, 2014 at 17:05 | vote | accept | CommunityBot | ||
| Aug 5, 2014 at 16:38 | answer | added | Sean Gallardy | timeline score: 2 | |
| Aug 4, 2014 at 19:22 | comment | added | user44956 | We don't currently, no; the out-of-state setup is an effective island with no external connections at all. I'm currently setting up three VMs with one as an AD controller so I can set up the windows clustering and try an AG. Would it be possible/advisable to set up both of the physical servers (after I've done this a few times in VMs) as AD controllers? | |
| Aug 4, 2014 at 19:05 | comment | added | Sean Gallardy | Gotcha - ok this makes more sense now. So Mirroring and AGs can continue to work assuming they are setup to do so. AGs require windows clustering as a pre-req and if using windows server 2012R2 can make use of dynamic quorum which is what you are looking for I believe. The question would remain though, do you have AD connectivity, etc, from the out-of-state provider? | |
| Aug 4, 2014 at 16:31 | comment | added | user44956 | Taking a look at some different articles, I suppose it would be more correct to assume we need something along the lines of database mirroring, or "AlwaysOn Availability Groups" if we upgrade to a recent release. | |
| Aug 4, 2014 at 16:16 | comment | added | user44956 | A cluster has to use the same storage for all nodes? Ah, well that complicates things. I suppose I'm asking for a way to keep them in sync then. | |
| Aug 4, 2014 at 16:15 | comment | added | Sean Gallardy | Could you elaborate a bit more. What you're describing isn't clustering as that would use the same database files (there would be no duplication of databases or data). Are you asking about cluster or a way to keep SQL Server databases in sync? | |
| Aug 4, 2014 at 16:01 | review | First posts | |||
| Aug 4, 2014 at 16:11 | |||||
| Aug 4, 2014 at 15:53 | history | asked | user44956 | CC BY-SA 3.0 |