How to move nodes from Cluster to Cluster

  • Hi guys,

    Just wondering if anyone can help me with this.

    I am trying to moving a node from one cluster to another, the setup is like

    Cluster A Cluster B

    node 1 node 3

    node 2 node 4

    desired situation

    Cluster A Cluster B

    node 1 node 3

    node 4 node 2

    right now

    Cluster B Cluster A

    node 3 node 1

    node 2

    node 4

    so far I have got node 4 with SQL uninstalled, evicted from the cluster, iSCSI disconnected from Cluster A SAN (Data, MSDTC/Quarum) and connected to the Cluster B Data, MSDTC, Quarum partition (appearing as offline due to policy)

    From node 3, I have added node 4 as a new node for Cluster B

    Seems all ready for "add a cluster node installation", but there are basically two issues.

    1. server validate, I can skip the warning for non-MS support

    2. no shared drive detected -> can not continue with install because no shared storage... <- what does this mean and how do I fix this?

    Do I need to manage the shared disk with cluster.exe?

    What do I need to do to get node 4 to join Cluster B properly?

    Do I need to install a stand alone SQL first then add it as a node?

    Can anyone please help with what should be done to get my work continue from here? I can see the storage has now got all three node (2/3/4) as potential owner.

  • Is it active/active or active/passive cluster?

    ----------
    Ashish

  • Active Passive.

    Centralised storage on SAN.

    Thanks for the help.

    Just a quick one, for adding a node, do you install standalone first, then add as a node, or you start the install from adding the node?

  • Answering my own question shere

    Skipping the Cluster Service, Application Service, Quorum, MSDTC... setups

    The steps to move nodes would be

    Evict node from current cluster (from windows cluster service) -> Uninstall SQL -> Clear Cluster information -> Add node to the new cluster (from windows cluster service) -> install SQL with AddNode from there.

    However, the key problem I have had was that I have used

    Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

    But I should have used

    Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode

    That is how you skip the validation then add the node.

    Cheers!

Viewing 4 posts - 1 through 3 (of 3 total)

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