Re: A clustering question

From: kk (knightk7_at_comcast.net)
Date: 01/04/05 

Date: Mon, 03 Jan 2005 19:48:03 -0500
To: "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com>

If you wait for Yukon you will also be able to use mirroring and
completely synchronize the SQL application with synchronous replication.
  This will virtually mirror the SQL application on the 2 servers.

If you can't wait I would recommend a clustering solution like VERITAS
Cluster server along with Volume Replicator which can create a
replicated data cluster (RDC) which can perform the exact task that you
need for any clusterable application.

-kk

Rodney R. Fournier [MVP] wrote:
> You have several ways to do this with SQL Server. Log shipping, using a
> publisher/subscriber, standby server, and third party software. To get more
> details on these, check the SQL cluster newsgroup or the Books on Line.
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "Dan" <dmueller@netspheretech.com> wrote in message
> news:2BC8447F-5B09-48FC-822A-9C1C1DB18612@microsoft.com...
>
>>Here is what I would like to do. I want to cluster (mirror?) 2 servers
>>together but have the servers located on different floors of the building
>>so
>>that if one server goes down the other server automatically takes over
>>without any user intervention. I want this to be seamless to the client,
>>in
>>other words, they will have no idea that one of the servers crashed.
>>Can I accomplish this by building 2 identical servers, same processor,
>>memory, RAID configuration, with a fiber link between the 2 for the
>>private
>>network and a copper link for the public network? The servers will be
>>supporting a SQL application.
>>I do not want to use 2 nodes with shared storage because I need to have
>>complete failover for all hardware avoiding any downtime.
>>Is this at all possible using Microsoft's clustering?
>>
>
>
>

Relevant Pages

  • Re: Adding 3 nodes to a cluster
    ... So you need to add the nodes to the cluster using the Cluster tool. ... Then extend the existing instance to the new nodes using the installer. ... Senior SQL Infrastructure Consultant ... servers acting as a failover in case one of the servers fails. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 99.9 service availability
    ... they would need 2 servers in site 1 working in a SCC model replicating the ... data to site A using snapmirror to other 2 nodes stand by cluster ... cluster and snapmirror replication to a DR site using standby clusters. ...
    (microsoft.public.exchange.design)
  • Re: Adding 3 nodes to a cluster
    ... First you use the cluster admin tool to add the machines as nodes to the cluster. ... Then you run the SQL installer to install binaries on the newly added nodes and allow the new nodes to host the existing instances. ... >>>I need to add these new servers as seperate instances in the SQL ...
    (microsoft.public.sqlserver.clustering)
  • WIN2K3 SP1, SQL Server / MSDTC Issue
    ... I can get SQL Installed ok and everything works fine until I set ... Setup Network Connections (for internal cluster comms and public network) ... Reboot Servers ...
    (microsoft.public.sqlserver.clustering)
  • RE: New SQL 2005 Cluster Questions
    ... You have only one SQL instance in the cluster. ... So, from what I am seeing is I have no choice but to DC the servers, cluster ... Win2003 Ent and then install SQL 2005 Ent onto this cluster. ...
    (microsoft.public.sqlserver.clustering)