Re: Active/Active Clustering - Help!

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: C.Dimitrov (CDimitrov_at_discussions.microsoft.com)
Date: 10/19/04

  • Next message: Geoff N. Hiten: "Re: Active/Active Clustering - Help!" 
    Date: Tue, 19 Oct 2004 11:49:07 -0700

    Hi, Geoff

    This is only useful if you have different DB devices.
    How it works if you want to have the same up to date DB device on both
    instances?

    Regards,
    Constantin

    "Geoff N. Hiten" wrote:

    > Actually it is pretty simple. You install a complete second instance of SQL
    > with all new disk devices, IP addresses, and SQL Instance Name. Each
    > database instance is completely independent. The only issue you have is
    > making sure there is enough resources available, especially physical memory,
    > when you 'stack' the instances on the same host.
    >
    > --
    > Geoff N. Hiten
    > Microsoft SQL Server MVP
    > Senior Database Administrator
    > Careerbuilder.com
    >
    > I support the Professional Association for SQL Server
    > www.sqlpass.org
    >
    > "Jody Stoll" <jo@mastercare.co.uk> wrote in message
    > news:e%23x7pauqEHA.3848@TK2MSFTNGP14.phx.gbl...
    > > Hi,
    > > Could someone please explain to me in an idiots guide kind of way!!! How
    > > Active Active clustering works when the underlying Windows 2003 cluster
    > > is Active\Passive using mscs with a central SAN.
    > > I dont understand how you can run SQL on both nodes when only one node
    > > can see the actual SAN resources at anyone time.
    > >
    > > The scenario I have is I currently have a Windows 2003 Active/Passive
    > > cluster with SQL 2000 running on 2 nodes with a SAN. We want to utilise
    > > the other node to be able to run a another high end database that we are
    > > developing to run along side the first one. However if one of the nodes
    > > fail the both Databases should be able to run on one node until the
    > > other is running again. For scalability purposes we may at some point
    > > wish to add a third node if this is possible.
    > >
    > > If someone can explain this to me and how to implement it from both
    > > Windows point of view and SQL I would be grateful.
    > >
    > > many thanks
    >
    >
    >

  • Next message: Geoff N. Hiten: "Re: Active/Active Clustering - Help!"

    Relevant Pages