Post reply

Clustering

  • August 31, 2010 at 6:39 am

    #239703

    Hi Experts.

    What is active/active model clustering?

    Subha

  • August 31, 2010 at 6:47 am

    #1214218

    http://www.lmgtfy.com/?q=active+active+model+clustering

  • August 31, 2010 at 7:22 am

    #1214259

    Microsoft refer to these as multi-instance failover clusters now.

    for the simplest case of a two node cluster, it is where you have more than one instance of SQL installed on the windows OS cluster, and each node supports an instance, therefore both nodes are referred to as 'active'.

    this is not a load balanced cluster, it is still failover capability only.

    ---------------------------------------------------------------------

  • August 31, 2010 at 7:57 am

    #1214310

    thanks for your solution..

    &

    what is diff between active/active VS active/possive clustering.

    Subha

  • August 31, 2010 at 8:51 am

    #1214370

    subha.msc2007 (8/31/2010)

    thanks for your solution..

    &

    what is diff between active/active VS active/possive clustering.

    Subha

    Active/Active - there is at least one SQL instance running on each of two nodes.

    Active/Passive - there is a least one SQL instance running on one node (active); the other node has zero SQL instances running on it (passive), but is available to have the instance(s) running on the active node to be failed over to it.

    So, based on this, can you now explain what an Active/Active/Passive cluster is?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • August 31, 2010 at 9:08 am

    #1214386

    WayneS (8/31/2010)

    So, based on this, can you now explain what an Active/Active/Passive cluster is?

    now referred to as an 'n+1' configuration by microsoft.

    ---------------------------------------------------------------------

  • August 31, 2010 at 9:11 am

    #1214390

    Good to know that George.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • August 31, 2010 at 11:05 am

    #1214489

    WayneS (8/31/2010)

    So, based on this, can you now explain what an Active/Active/Passive cluster is?

    I've got an Active/Active/Active/Passive cluster. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 31, 2010 at 12:06 pm

    #1214521

    Brandie Tarvin (8/31/2010)

    WayneS (8/31/2010)

    So, based on this, can you now explain what an Active/Active/Passive cluster is?

    I've got an Active/Active/Active/Passive cluster. @=)

    not anymore, you've got an n+1 cluster, same as everyone else 🙂

    ---------------------------------------------------------------------

  • August 31, 2010 at 12:09 pm

    #1214522

    george sibbald (8/31/2010)

    Brandie Tarvin (8/31/2010)

    WayneS (8/31/2010)

    So, based on this, can you now explain what an Active/Active/Passive cluster is?

    I've got an Active/Active/Active/Passive cluster. @=)

    not anymore, you've got an n+1 cluster, same as everyone else 🙂

    BAH Humbug! I'm a non-conformist. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply