Re: SQL and Majority Node Set

Tech-Archive recommends: Fix windows errors by optimizing your registry

I should have posted this in the last reply.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx


--
Hope it helps

dw

_______________________________
Don Wilwol
donwilwol(DELETE)@yahoo.com
http://spaces.msn.com/members/wilwol/


"Don Wilwol" <donWilwol@(EMAIL)yahoo.com> wrote in message
news:%23NQLqhWsFHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
> There are some other products like Double-Take, (NSISoftware.com) that
> will work if your SAN doesn't support SRDF.
>
> Mirror view will replicate the data, but it doesn't provide fail over at
> the application level. Double Take's product rides on MS clustering
> (either MNS or shared) and provides a failover capability you wouldn't
> normally get.
>
> --
> Hope it helps
>
> dw
>
> _______________________________
> Don Wilwol
> donwilwol(DELETE)@yahoo.com
> http://spaces.msn.com/members/wilwol/
>
>
> "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
> news:eTR%23UMVsFHA.2540@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi
>>
>> If you need cluster nodes to be dispersed, you need to use Veritas
>> Clustering ("Stretched Clusters"),together with some SAN based real-time
>> replication like EMC's SRDF.
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:eh7b6ASsFHA.3080@xxxxxxxxxxxxxxxxxxxxxxx
>>> SQL clustering requires a shared disk, so MNS clustering does not buy
>>> you much.
>>>
>>> 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
>>> http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC
>>> Clustering class
>>>
>>>
>>> "Ian Coates" <IanCoates@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:A300210D-34AC-46B7-8337-1C0F08CC77F6@xxxxxxxxxxxxxxxx
>>>> Hello
>>>> Following on from a previous thread posted on 8/9/2005, titled "Need
>>>> advise
>>>> on SQL Server installating in MS cluster 2k3 Majority", I am currently
>>>> evaluating some solutions to install SQL 2000 on Windows 2K3. One of
>>>> the
>>>> requirements is to use current clustering technologies, with provision
>>>> for
>>>> data centre site failures. Does anyone know if using W2K3 MSCS with MNS
>>>> would
>>>> be supported in the following configuration.
>>>> 3 sites, two nodes at two of the sites that will configured to host the
>>>> instance of SQL. 1 node at the remainig site to ensure a majority of
>>>> nodes
>>>> available in the event of a site failure. The Virtual server that hosts
>>>> SQL
>>>> will be configured to not failover to the single host at the third
>>>> site.
>>>> The SQL databases and other disk dependancies will be installed on a
>>>> shared
>>>> disk array. This would be presented as LUN's form a SAN at each site,
>>>> most
>>>> liekly one master and one slave. Synchronous data replication of the
>>>> shared
>>>> data would be performed via a third party utility on the SAN, such as
>>>> EMC's
>>>> mirrorview.
>>>> Each of the nodes that can host the SQL Virtual server would have
>>>> multiple
>>>> HBA's installed with multi path I/O software installed.
>>>> Any comments would be appreciated
>>>>
>>>> tia
>>>>
>>>> Ian
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Clustering with NAS
    ... Whilst I appreciate that clustering with NAS is ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster and WriteBack Caching
    ... Write-back caching cannot be used on host controllers in a cluster without ... failover clustering and can sync the cache correctly, ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Do I need Enterprise to do clustering?
    ... MVP - Windows Server - Clustering ... But we could upgrade SQL2000 Enterprise to SQL2005 Enterprise in place ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: configure sql cluster with one NIC (two nic but teamed)
    ... Microsoft SQL Server MVP ... > MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: How do I fix this cluster???
    ... could not be found to complete setup. ... >Introduction to Microsoft SQL Server 2000 Clustering ... >Microsoft SQL Server 2000 Failover Clustering Disaster ...
    (microsoft.public.sqlserver.clustering)