9 messages in com.mysql.lists.clusterRe: Another "Cluster Limitation" Ques...
FromSent OnAttachments
Ephraim Dan09 Feb 2005 02:49 
Alex Davies09 Feb 2005 03:11 
Olivier Kaloudoff09 Feb 2005 04:31 
Alex Davies09 Feb 2005 04:34 
Mikael Ronström09 Feb 2005 08:49 
Clint Byrum09 Feb 2005 11:05 
Alex Davies09 Feb 2005 11:25 
Mikael Ronström09 Feb 2005 11:52 
Mikael Ronström11 Feb 2005 09:41 
Subject:Re: Another "Cluster Limitation" Question - add/drop node
From:Mikael Ronström (mik@mysql.com)
Date:02/11/2005 09:41:38 AM
List:com.mysql.lists.cluster

Hi,

2005-02-11 kl. 18.19 skrev Lewis Bergman:

Mikael Ronström wrote:

There are no architecturial limitations towards changing IP addresses of storage nodes in a live cluster. However to change this a rolling upgrade must be performed. (This procedure should work also when needing to move a certain data node from one computer to another, in this case it is likely that the new node doesn't have the file system of the old node and thus ndbd --initial should be used on that node, not on the others). This is the procedure in this specific case. 1) Stop the management server 2) Start the management server with the new config file 3) Stop one data node at the time and restart it (the node to change IP address is restarted last) 4) Continue with step 4) until all nodes have been changed 5) Stop MySQL Servers one at a time and restart it 6) Continue with step 5) until all MySQL Servers have been restarted I haven't tried it myself so please report if it is successful or otherwise where it goes wrong.

I tried it and it does work.

Great, thx

Rgrds Mikael

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html