9 messages in com.mysql.lists.clusterRe: Another "Cluster Limitation" Ques...| From | Sent On | Attachments |
|---|---|---|
| Ephraim Dan | 09 Feb 2005 02:49 | |
| Alex Davies | 09 Feb 2005 03:11 | |
| Olivier Kaloudoff | 09 Feb 2005 04:31 | |
| Alex Davies | 09 Feb 2005 04:34 | |
| Mikael Ronström | 09 Feb 2005 08:49 | |
| Clint Byrum | 09 Feb 2005 11:05 | |
| Alex Davies | 09 Feb 2005 11:25 | |
| Mikael Ronström | 09 Feb 2005 11:52 | |
| Mikael Ronström | 11 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
-- Lewis Bergman Texas Communications 4309 Maple St. Abilene, TX 79602-8044 325-691-3301 800-299-6962
Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com
Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html




