locked
Active / Active cluster installation RRS feed

  • Question

  •  

    Hi,

    I have installed 2 -3 times a 2 node active/passive cluster  in both version of sql server 2005 & 2008.

    Per the new requirements i have to install Active/Active clusters on both 2005 and 2008.

    I have a few challenges in this regard.

    1. Do i need to create independent sql groups, cluster groups and msdtc group based on the no of nodes.

    2. Can i use default instance names on both the nodes.

    3. Can i have multiple instances per node .(If possible means  can i map all the data drives on one node to a single sql group)

    3. Any considerations need to be taken care from the memory perspective ? (failover considerations)

    4. In an (N+1) multi instance cluster environment is there any possibility to choose the failover between the specified nodes.

     

    It would be great if any one can point me in the right direction by providing any docs or any links or video links for the Active/active cluster installation.

     

    Regards,

    Sandhya

     

     

    Thursday, September 30, 2010 11:01 PM

Answers

  • 1. Do i need to create independent sql groups, cluster groups and msdtc group based on the no of nodes.
    Its based on number of instances.

    2. Can i use default instance names on both the nodes.
    No. Only one default instance per cluster.

    3. Can i have multiple instances per node .(If possible means  can i map all the data drives on one node to a single sql group)
    Each SQL Instance would have seperate drives. No overlap.

    3. Any considerations need to be taken care from the memory perspective ? (failover considerations)
    If all instances fall to one node, it should be sufficient to meet your performance benchmark.

    4. In an (N+1) multi instance cluster environment is there any possibility to choose the failover between the specified nodes.
    Yes. Install on whichever nodes you want to failover

    http://msdn.microsoft.com/en-us/library/dd299415(SQL.100).aspx (video link)


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, October 1, 2010 12:07 AM

All replies

  • 1. Do i need to create independent sql groups, cluster groups and msdtc group based on the no of nodes.
    Its based on number of instances.

    2. Can i use default instance names on both the nodes.
    No. Only one default instance per cluster.

    3. Can i have multiple instances per node .(If possible means  can i map all the data drives on one node to a single sql group)
    Each SQL Instance would have seperate drives. No overlap.

    3. Any considerations need to be taken care from the memory perspective ? (failover considerations)
    If all instances fall to one node, it should be sufficient to meet your performance benchmark.

    4. In an (N+1) multi instance cluster environment is there any possibility to choose the failover between the specified nodes.
    Yes. Install on whichever nodes you want to failover

    http://msdn.microsoft.com/en-us/library/dd299415(SQL.100).aspx (video link)


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, October 1, 2010 12:07 AM
  • More videos
    http://msdn.microsoft.com/en-us/library/dd299416(SQL.100).aspx

    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, October 1, 2010 12:15 AM
  • In addition check out the sql cluster whitepaper on Bing .. we have one for 2005 and one for 2008.
    Friday, October 1, 2010 2:48 AM
    Answerer
  • Also, remember that you may only have multiple clustered MSDTC services\applications if your Windows cluster is based upon Windows 2008!
    Friday, October 1, 2010 8:50 PM