Network/storage/sys requirements to deploy a a multi site SQL 2008 cluster with automatic failover

Hi Experts,

One of my clients would like to setup a multi site SQL 2008 cluster with automatic failover.They want to do geographically dispersed clusters with SQL Server 2008

My design as per below:

Deploy a 4-node (2x2) cluster, and use the traditional node and file share majority. I'm guessing we need to use VLANs just like versions prior to it.

Please clarify, how many vlans should I setup to allow HA and full DR? Please keep in mind that we do have 2 physical sites

Should I use a single VLAN for the intracluster communication, another VLAN for local network communication, and another one for the intrasite communication?

What storage/server requirements can achieve this?

What best practices do you recommend for database logs, DBs, replicaton across sites, etc?

Best practices for networking/storage/AD/SQL?

What physical network components, such as switches, etc do you recommend?

Any special hotfix required for the physical clusters?

Since this is a consulting question, please I would like to read feedback from multiple people,
Jerry SeinfieldAsked:
Who is Participating?
 
65tdRetiredCommented:
Windows 2008 R2 can be across different subnets.
One should utilize one NIC for the public network connection that is also configured as (mixed mode, both public traffic and cluster traffic).  
As well a separate NIC for cluster traffic (heartbeat).
See Multi-site clusters in the following MS doc:
http://www.google.ca/url?sa=t&rct=j&q=windows%202008%20r2%20cluster%20&source=web&cd=3&ved=0CE8QFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F5%2FB%2FD%2F5BD5C253-4259-428B-A3E4-1F9C3D803074%2FWS08%2520R2%2520Failover%2520Clustering%2520White%2520PaperTDM.docx&ei=Ht7nTueTOoKtiALBtPyPBw&usg=AFQjCNH5FEfH6VG-JT6Io1dnYkfdNCdc-w&cad=rja

Or search for :  
Failover Clustering in Windows Server 2008 R2

The type and brand of SAN and type of access (fiber channel or iSCSI) could determine how the data is going to replicated.

As far AD goes a host at each site as a minimum.
0
 
Jerry SeinfieldAuthor Commented:
Can I get an update please?
0
 
Jerry SeinfieldAuthor Commented:
Can I please get an acknowledment?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.