List:Cluster« Previous MessageNext Message »
From:Andrew Hutchings Date:November 5 2009 7:54pm
Subject:Re: NDBD addition failed
View as plain text  
Hello Richard,

On Wed, 2009-11-04 at 11:43 -0500, Richard McCluskey wrote:
> id=4	@10.32.4.20  (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
> id=5	@10.32.4.30  (mysql-5.1.35 ndb-7.0.7, no nodegroup)

OK, so here is what I believe happened:

Node 4 was initial partial started and the node groups were setup at
that point.  Since node 5 wasn't part of the node group when the cluster
was started it doesn't know which node group to belong to straight away
(part of the online add node feature in 7.0).  So you need to create a
new one by doing:

ndb_mgm> CREATE NODEGROUP 5

http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-mgm-client-commands.html#id2777104

You will then need to reorganise the tables by doing the following for
all the cluster tables:

mysql> ALTER TABLE ... REORGANIZE PARTITION

For more information on online add node please see:

http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-online-add-node.html

Hope this helps.

Kind Regards
-- 
Andrew Hutchings, MySQL Support Engineer, Americas
Sun Microsystems, United Kingdom
http://www.sun.com/mysql/

Thread
NDBD addition failedRichard McCluskey4 Nov
  • Re: NDBD addition failedAndrew Hutchings4 Nov
    • Re: NDBD addition failedRichard McCluskey4 Nov
      • Re: NDBD addition failedAndrew Hutchings5 Nov
        • Re: NDBD addition failedAndrew Hutchings5 Nov