Re: Type of Cluster?

I have heard of many horror stories with iSCSI implementations and none with
successful, happy users. Pardon me if I find it difficult to recommend such
a "solution". Just because it is supported and possible doesn't mean it is
a good idea.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:%23ZxG95$zFHA.3152@xxxxxxxxxxxxxxxxxxxxxxx
> Since SP1 for Windows Server 2003, iSCSI also supports more a multi-node
> cluster, granted not as fast as a SAN, but cheaper :)
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
>
> "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> wrote in message
> news:e%23orvh$zFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
>>A multi-instance cluster would be the correct solution. You can run each
>>instance on its own host node during normal operating conditions. During
>>a failover event, you would host multiple SQL instances on a single node.
>>I would purchase a fourth node and have a 3-instance, 4-node cluster.
>>That way, any single node failure will cause the failed instance to move
>>to the empty node. This requires a bit of configuration work, but is well
>>within the capabilities of SQL Server. I have built and operated just
>>such a cluster in the past with a high degree of success.
>>
>> A SAN is a required element for a cluster with more than two nodes.
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "rui" <rui@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:3F786FD2-AFE4-4F6C-A1A4-71C005C68977@xxxxxxxxxxxxxxxx
>>> Hi,
>>>
>>> I have 3 databases on 3 seperate SQL 2000 servers, all are used heavily.
>>> There is no high availablity solution.
>>>
>>> I was thinking of placing the databases in Windows 2003 Cluster. If I do
>>> that, in terms of performance shouldn't I use an active\active
>>> configuration
>>> (i think it's called multi-instance nowadays). What I am trying to say
>>> is
>>> that each server in the cluster will maintain its own database.
>>>
>>> Wouldn't I need a beefed up server to put all databases on a single node
>>> in
>>> an active\passive cluster.
>>>
>>> I also have use of a SAN
>>>
>>> Thanks
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: ss2005 on a cluster with ss2000
    ... I would not use the IIS front end on a clustered server environment. ... Senior Database Administrator ... would it be ill conceived to also run reporting services 2005 on this ... I am debating on installing ss2005 on this same cluster. ...
    (microsoft.public.sqlserver.setup)
  • Re: Active/Active cluster
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... You don't want to be married to you SQL Cluster:) You do want it around whenever you call it though. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine ... member of the NLB cluster, setup NLB on it, plug the NICs ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Once again, ARP is an RFC standard, if you are having to make static entries in unicast mode, then your network device is not in compliance. ... Windows Server 2008 Readiness Team ... I was feeling nervous about our teaming-capable adapter as I read it might be sending out heartbeats, so I disabled it AND configured the cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine when no NLB is installed, but when it is, things start going screwy. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... One server with no cluster configured - all works ok. ... When static ARP mappings are added all works ok. ... I thought that the litmus test was that the router functions fine when ...
    (microsoft.public.windows.server.clustering)