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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jerry SeinfieldAuthor Commented:
Can I get an update please?
0
Jerry SeinfieldAuthor Commented:
Can I please get an acknowledment?
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.