I'm looking to setup a Windows Server 2019 failover cluster with iScsi shared storage (for a SQL Server Always-On instance). The additional requirement is to not have a single point of failure.
Let's say I have two iScsi Initiator nodes A and B and an iScsi Target C. If I implement MPIO, it will provide redundancy and multiple paths to the Storage, good. However, if C goes down, then nodes A and B lose connection the storage.
Questions:
- Should I create 2 iScsi Target Servers, C and D? If so, what's the best configuration so that if C goes down, D will takeover as the Target?
- When spinning up the Target Servers, what should the minimum requirements be? e.g. RAM, cores, etc.?
- Is it best practice to keep the primary iScsi Target separate from the Domain Controller?
- With MPIO, would it be best to use Round-Robin or Failover Only?