Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Frant10110
Starting Member
2 Posts |
 Posted - 2014-10-14 : 10:58:42
|
| Hi,I know that you can have an FCI installed and that can be part of an availability group (with manual failover). I was wondering if it's possible to have for example :3 node windows clusterN1 and N2 has a FCI installedCould you then install a stand-alone instance onto N1, N2, N3 (with local storage ) which then becomes part of a seperate always on availability group that doesnt interact with the FCI installed on N1/N2N1 - Failover Cluster Instance - Stand Alone Instance for AGN2 - 2nd Node for Failover Cluster Instance - Stand Alone Instance for AGN3 - Stand Alone Instance for AGMany thanksFT |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-14 : 12:07:06
|
| Yes I believe that is possible. I have not seen it done though and wonder why this is wanted. Personally I would just install another FCI, OR I would spin up an AG cluster.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Frant10110
Starting Member
2 Posts |
Posted - 2014-10-14 : 12:59:54
|
| Many thanks for the response , I'll try and explain my thought processThe FCI would be to host Database1 and Database2 which can be hosted on shared storage and needs all the high availability that goes with an FCI.However database3 needs to remain available even if our shared storage is lost. I was thinking that this could be achieved by having an AG instance on the same windows cluster using local storage for the instance on each node. Database3 needs to failover automatically and I think if I include an FCI into my AG configuration then failover isn't automatic.Hope that makes sense !!Cost constraints really as to why I'm trying to put this all into one windows cluster rather than have separate ones. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-14 : 13:48:32
|
| Honestly I don't know if it'll work or not. Typically we plan for shared storage being lost by having a DR-type system where we mirror the FCI databases to (or log shipping or even replication). But these days, many are moving away from FCI+mirroring by having an AG cluster that spans 2 or more sites.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
AlwaysOn Configuration Question