Re: Change IP on NDB Data Node

[Randy Freeman]

Additional information:

I have a functioning cluster with 3 machines (development only).

box1 - ndbd (group 0)
box2 - ndbd (group 1)
box3 - ndbd (group 0)
box3 - ndbd (group 1)
box3 - ndbmgmd and API
box4 - nothing

I'm testing moving the data nodes on box1 and box2 to a new machine box4. I have done a rolling restart of the ndb_mgmd and all the data nodes. Then I modified the config.ini to only move box1 to box4. The only change was the HostName whic i replace the IP to from box1 to box4 using IPs not actual hostnames. Then I did another rolling restart. 10.1.1.224 is the IP to box4.

After the restart the config change appears to be in use:
id=1 (not connected, accepting connect from 10.1.1.224)
id=2 @10.1.1.200 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=3 @10.1.1.217 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 1)
id=4 @10.1.1.200 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 1)

Running ndbd on box4
[ndbd] INFO -- Angel connected to '10.1.1.200:1186'
[ndbd] INFO -- Angel allocated nodeid: 1

10.1.1.200 is the IP to the ndb_mgmd.

But the log on the ndnb_mgmd shows:
[MgmtSrvr] INFO -- Nodeid 1 allocated for NDB at 10.1.1.224
[MgmtSrvr] INFO -- Node 50: Node 1 Connected
[MgmtSrvr] INFO -- Node 3: Node 1 Connected
[MgmtSrvr] INFO -- Node 4: Node 1 Connected
[MgmtSrvr] WARNING -- Node 2: Releasing node id allocation for node 1

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=1 @10.1.1.224 (mysql-5.6.17 ndb-7.3.5, starting, Nodegroup: 0)
id=2 @10.1.1.200 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)
id=3 @10.1.1.217 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 1)
id=4 @10.1.1.200 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=50 @10.1.1.200 (mysql-5.6.17 ndb-7.3.5)

Any idea what I might be missing? I have not been able to do a data node replacement without taking down the cluster. I have been able to follow the examples to start a new data node group but not replace an existing data node.

Thanks



Randy Freeman Wrote:
-------------------------------------------------------
> What is the correct method of changing the IP of a
> NDBD in an existing Mysql Cluster.
>