# Changing IP of nodes in XtraDB cluster

**URL:** <https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549>\
**Category:** Percona XtraDB Cluster 5.x\
**Tags:** percona\
**Created:** [September 19, 2022, 10:55am UTC](https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549 "2022-09-19T10:55:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![adi](https://avatars.discourse-cdn.com/v4/letter/a/4da419/32.png) [@adi](https://forums.percona.com/u/adi)\
**Post date:** [September 19, 2022, 10:55am UTC](https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549/1 "2022-09-19T10:55:25Z")

</div>

Hi All,  
We need to change the IP/subnet of all nodes (Count - 3) in XtraDB cluster which are accessed through proxySQL, Can someone please suggest what is the best process of changing IPs of complete XtraDB cluster without breaking the cluster and what changes are required to be done on proxySQL.  
Thanks  
Adi

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [September 19, 2022, 5:42pm UTC](https://forums.percona.com/t/changing-ip-of-nodes-in-xtradb-cluster/17549/2 "2022-09-19T17:42:40Z")

</div>

You will need to restart each PXC node to change the IP address due to `wsrep_node_address` setting. Edit your my.cnf and change this parameter to the new IP and change any other listening-related settings. Check the wsrep\_cluster\_address parameter as well. Restart this node. Wait for it to join the cluster. Modify ProxySQL by UPDATEing the mysql\_servers table and LOAD MYSQL SERVERS TO RUNTIME; Test that connections to the new IP node work. Repeat for node2, then node3.
