Re: Type of Cluster?

Usually, when someone wants to cut costs by going iSCSI, they don't go with
the "right" vendor. Nor do they bother with a certified cluster solution,
nor do they have somebody who knows clustering build the darn thing. Dunno
why they have so many problems. :)

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

"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uR6jVPA0FHA.612@xxxxxxxxxxxxxxxxxxxxxxx
> It works well with the right vendor :) Again, if you want the best
> performance.....SAN is the only way to go.
>
> 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:eetQ9MA0FHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
>>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: SQL transaction logs on iSCSI
    ... MVP - Windows Server - Clustering ... ClusterHelp.com is a Microsoft Certified Gold Partner ... Plenty of people have set up SQL SANs with the HP 1500 with fibre ... with iSCSI over Ethernet. ...
    (microsoft.public.sqlserver.clustering)
  • Re: iSCSI shared storage failure in Phase 1
    ... There isn't anything specific you need to configure when using iSCSI with clustering, at least nothing other that normal iSCSI connectivity configuration. ... bus reset is sent, yet it fails on the bus reset. ... config needed with iSCSI when running a cluster test? ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering with NAS
    ... Whilst I appreciate that clustering with NAS is ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: 64-bit, shared disk quorum cluster, iSCSI
    ... I think I'm getting hung up on help files too much. ... As I said in private email, you can use iSCSI as well. ... However, with the issue of support in mind, to be 100% supported by Microsoft, you should only use hardware from www.windowsservercatalog.com in the hardware section in the cluster solutions link. ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)
  • Re: MAC Spoof? Flexlm
    ... It is always best to try and follow vendor recommendations/best practices. ... MVP - Windows Server - Clustering ... Either I get two license files from the vendor, ...
    (microsoft.public.windows.server.clustering)
Loading