Re: SQL 2005 2-server cluster configuration with NAS?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



--

"Ryan Sokolowski [MVP]" <ryan@xxxxxxxxxxxxxxxxx> wrote in message
news:eL%23dbETBIHA.4568@xxxxxxxxxxxxxxxxxxxxxxx
If I understand you correctly, sharing the NAS with the NLB Web servers
will introduce more disk contention possibilities. Why are you doing this
anyway?

I'm not using NLB...the servers have a hardware load-balancer in front of
them. Because the servers are all mirrors of the same website, I had wanted
to keep the root website directory on the NAS so I didn't have to deal with
replicating changes across six servers every time the website content is
updated.


As for the traffic isolation, if you are using iSCSI, each clustered
server must have one or more network adapters or host bus adapters that
are dedicated to the cluster storage. The network you use for iSCSI cannot
be used for network communication.

I was originally going to use the NAS as a windows shared directory for the
webservers, but it appears that if I want to run MSCS and cluster the two
SQL servers, then I would be better off using the NAS for that. If I
understand you correctly, doing the latter would then preclude me from using
it from anything else? I think I understand that using iSCSI with the NAS
would require it to be isolated on its own network with just the SQL Servers
accessing it...assuming that's the only way to set up the cluster?


--
Ryan Sokolowski
MVP - Windows Server - Clustering
MCSE, CCNA, CCDA, BCFP


This posting is provided "AS IS" with no warranties, and confers no
rights.
"geek-y-guy" <noone@xxxxxxxxxxx> wrote in message
news:OPSt0mSBIHA.3848@xxxxxxxxxxxxxxxxxxxxxxx

"Ryan Sokolowski [MVP]" <ryan@xxxxxxxxxxxxxxxxx> wrote in message
news:O55yWxRBIHA.5196@xxxxxxxxxxxxxxxxxxxxxxx
Performance questions really depend on the intended use, user load and
expectations for performance.

--
Ryan Sokolowski
MVP - Windows Server - Clustering
MCSE, CCNA, CCDA, BCFP

gotcha...here's my scenario. I have a 6 load-balanced webservers
(externally loadbalanced), with SQL2005 dB behind them. The dB servers
prolly will not be tasked very heavily (most of the time they are pretty
much idling), and I'm looking for high-availability primarily. This is
the only hardware on the subnet. The LB'd webservers are there to handle
infrequent traffic spikes (very infrequent).

I've been reading, reading, reading about clustering + iSCSI, and see
that it's recommended to isolate the NAS and clustered servers on their
own switch to isolate them from all other traffic. I can do that, but I
was hoping to allow the LB webservers to have access to the NAS as well.
Is that problematic?

If so, I can go the three-NIC configuration for the clustered SQL servers
(in other words, private NAS network, heartbeat, and public network with
webservers), but I was hoping to be able to share the NAS with the
webservers as well.

Any observations/recommendations would be greatly appreciated.






.

Relevant Pages

  • Re: Windows 2003 Network Load Balancing Problem
    ... Sadly my servers websites were configured with specific IPs and host ... I find it very strange why the NLB driver can receive on a virtual IP ... he set his IIS website to use ALL UNASSIGNED addresses rather than ... specifically pointing it at the single virtual cluster address. ...
    (microsoft.public.windows.server.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... that databases get locked off in the current cluster and then properly ... I maintain many SQL servers as ... Who is going to track down all of the applications that need to have ...
    (microsoft.public.sqlserver.clustering)
  • Re: Load Balanced TS Servers and Unicast Flooding
    ... Remove each on of your tse servers from the cluster, ... Start adding them back to the NLB Cluster. ... > NICs. ...
    (microsoft.public.windows.terminal_services)
  • Re: question regarding NTP configuration for clusters, and "cluster time" stability
    ... cluster ranging in size from 4 to over 100 nodes. ... external NTP servers nor any hardware based time sources. ... NTP server or servers, those nodes with external connections were ... to have each node peer with a small number of other nodes (four each ...
    (comp.protocols.time.ntp)
  • Re: High Availability FreeBSD www cluster
    ... So I am a bit lost and i am wanting to learn how to cluster freebsd ... A means to detect failed / out of service machines and redirect traffic to alternative servers ... or you have to store the session state in a way ...
    (freebsd-questions)