I am exploring FCI and AG.
In FCI we can have 2 nodes that share the same SAN storage. And failover results in the other node starting up.
Where as AG is for a set of dbs.
This question is about the following quote from msdn: "An FCI can participate in an availability group as one of the instances hosting either a primary or secondary replica.".
This sentence is confusing because An FCI can participate in an availability group as one of the instances
means that only one side of the AG can be a FCI, which means the other side must be a stand-alone instance.
Reading the sentence fully An FCI can participate in an availability group as one of the instances hosting either a primary or secondary replica.
- I think they are saying that - One or more AG participants can be a FCI, and that it can either host the primary or secondary. This makes more sense. Have I understood correctly?
During configuration of AG, assuming I have FCI on one or both sides, then should I add FCI to AG or should I add a single instance from the FCI into AG? I think the answer is FCI because when we can an instance is a FCI it means it is not a single instance. Correct?