Re: Type of Cluster?

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: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (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)
  • Re: What is the best backup solution for failover cluster SQL Server
    ... Backing up your SQL database in a clustered environment is not different from a normal server. ... Create a cluster disk share so in the event of a fail over, all nodes will have access to the backup share. ...
    (microsoft.public.sqlserver.clustering)
Loading