Changing IP Addresses of AlwaysOn Group

  • We have 2 nodes in an AlwaysOn group. SQL2014 Enterprise.
    We need to change the IP addresses of the nodes, the cluster, and the listener.
    They will still remain in the same domain.
    The subnet mask shall remain the same.
    All will the be the same except the IP Addresses and the default gateway.
    What are the steps to accomplish this?

    Thanks.

  • To change the IP address of the cluster nodes themselves, it would be best to evict in each node in turn, change the IP, then add it back

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Thanks.  Before evicting a node, should SQL be shutdown?  Or the AlwaysOn Group be shutdown?  Thanks.

  • Are you using FCIs or just standalone instances in the AGs?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Standalone instance.

    The availability group is setup as a role under the cluster.

    Windows is setup as clustered, not SQL.

    Thanks.

  • in that case as i said above

    Remove the secondary database(s)
    Remove the replica from the Availability Group(s)
    evict the node from the cluster
    Change the nodes IP address
    re introduce to the cluster
    re apply the Availability Group config onto the sql instance

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • We got same type of scenario came in our environment. Could any one update the right process.

    Thanks in advance

    • This reply was modified 2 years, 11 months ago by  surru54.
  • What is it you are attempting to do exactly

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Our VM servers are in azure cloud and migratingΒ  to AWS cloud.

    we have 3 nodes in always on availability (1- primary, 1 - secondary, 1 - DR replicas ) for voting purpose using fileshare witness in cluster. SQL Server Version 2012.

    After VM's migrating to AWS cloud, IP address will change so how to sort out the issues from Windows cluster and Alwayson Listener.

    Thanks

    • This reply was modified 2 years, 11 months ago by  surru54.
  • I would say it's likely easier to deploy a new system in AWS and then migrate the database(s) to the new system, is this not an option for you?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

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

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