Microsoft Clustering and SQL - what about the storage?
Posted on 2014-10-01
I am working on MS SQL clustering and looking into redundancy. I understand all of the diagrams with regard to failover but the redundancy seems to stop at shared storage. Multible nodes all pointing to the same storage array.
Can anyone point me to a diagram and/or documentation on how to ensure redundancy of the storage array as well? I have worked with Dell Equallogics and we replicated data between sites but what I'm looking for in this situation is to:
1. Have the cluster nodes write to more than one storage location. Is this possible with MSCS?
2. If cluster nodes cannot talk to two storage arrays, can an array replicate every change to data/databases to another array instantly rather than using some scheduled replication? What is the terminology for continuous/immediate replication?
Just starting on this so anything will help. Basially looking at having a cluster with a node at one site and a node at another physical site. MS has now allowed this over the network and removed the same subnet restriction but now I'm stuck on how to ensure the databases are replicated between the two sites.
Dell shop guys...just so you know.