Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL Cluster

Author  Topic 

jensmg
Starting Member

7 Posts

Posted - 2007-11-12 : 16:47:40
Hello,

I am new in clustering and now i have a project establishing a web high available web application. I have to establish a complete new site on a data center and I have this in mind:

One Server for Active Directory and the domain.
2 Servers for the SQL 2005 Failover Cluster with a SAN as shared medium.
2 Servers as an IÌS NLB where I will install the Web Application.

What do you think about that solution. So the NLB Web Servers will access the clustered SQL Server DB.

Do you have any suggestions or plans for me please post i am completely new in clustering and SQL Server. And what switches do I need accessing the san und staff like that.

Is there a solution with not so much servers?

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-12 : 16:58:46
If you are new to clustering, then I'd highly recommend hiring a cosultant with clustering experience. It is not something that you can just learn and implement correctly without help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2007-11-12 : 17:35:26
You'll want to cluster the Active Directory server as well. If you lose domain authentication, everything else will be affected. It's no fun to have nothing work because the one AD server has failed...
Go to Top of Page

jensmg
Starting Member

7 Posts

Posted - 2007-11-12 : 17:49:41
Thank you for the answers, but will this setup work ?
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2007-11-12 : 17:53:48
Yes, that setup will work. Clustering, when done properly is a big enviroment with about half the equipment _waiting_ for a failure to occur.

The extra details like the SAN settings and whatnot are exclusive to your enviroment, you'll have to work the majority of those logistics out on your own.
Go to Top of Page

jensmg
Starting Member

7 Posts

Posted - 2007-11-12 : 18:19:49
Just to point this out I am very familiar with Windows 2003 ADS and all the stuff and I installed now for testing a Windows 2k3 Cluster on Virtual Server.

For the first step. Is the setup I want to use oversized our okay? Will this solution work from the design site or can I make someething better?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-12 : 22:49:58
The plan sounds ok, and I'll not use less servers for this project.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-11-13 : 01:37:16
you should have at least 2 servers for AD/DNS etc. A single AD box is a single point of failure.


-ec
Go to Top of Page

jensmg
Starting Member

7 Posts

Posted - 2007-11-14 : 02:58:39
Thanks for all the great answers. One mor question:

I will choosen 2 Servers and a SAN for the SQL Database in the failover cluster. But what about the NLB with our Web Application on th IIS Servers, I will also unse 2 Servers, but do I need also a shared media ?
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2007-11-14 : 09:47:33
For NLB you don't need shared storage. Only MSCS requires shared storage.
Go to Top of Page
   

- Advertisement -