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/