Adding new Node fails
Hi All,
Just been playing with MySQL 5.0 clustering for about 24hours now, so this could be a basic question.
I have Clustering going just fine all one one machine (im doing a proof of concept before spending the money on hardware and time).
Currently the one server runs everything and it works GREAT ! using this config.ini :
[NDBD DEFAULT]
NoOfReplicas=1 # Number of replicas
DataMemory=2M # How much memory to allocate for data storage
IndexMemory=1M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
[NDB_MGMD]
Id=1
HostName=10.6.0.101
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
[NDBD]
Id=2
HostName=10.6.0.101
datadir=/var/lib/mysql-cluster/ # Directory for this data node's datafiles
[MYSQLD]
NOTE : this is jsut for tesgin, so the memory etc doesnt bother me as yet.
this all connects okay :
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @10.6.0.101 (Version: 5.0.18, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.6.0.101 (Version: 5.0.1Cool
[mysqld(API)] 1 node(s)
id=3 @10.6.0.101 (Version: 5.0.1Cool
when i add a new node (welll, try too) i using :
[NDBD DEFAULT]
NoOfReplicas=1 # Number of replicas
DataMemory=2M # How much memory to allocate for data storage
IndexMemory=1M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
[NDB_MGMD]
Id=1
HostName=10.6.0.101
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
[NDBD]
Id=2
HostName=10.6.0.101
datadir=/var/lib/mysql-cluster/ # Directory for this data node's datafiles
[NDBD]
Id=3
HostName=10.5.4.98
datadir=/var/lib/mysql-cluster/ # Directory for this data node's datafiles
[MYSQLD]
and restarting everything mysql and ndbd i find the node just sits there STARTING :
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.6.0.101 (Version: 5.0.18, starting, Nodegroup: 0, Master)
id=3 (not connected, accepting connect from 10.5.4.9Cool
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.6.0.101 (Version: 5.0.1Cool
[mysqld(API)] 1 node(s)
id=4 (not connected, accepting connect from any host)
ndb_mgm> 2 status
Node 2: starting (Phase 1) (Version 5.0.1Cool
evantually the node disappears and logs report :
2006-03-02 15:10:31 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-03-02 15:10:31 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000002.
2006-03-02 15:11:04 [MgmSrvr] INFO -- Node 2: Start phase 1 completed
2006-03-02 15:11:34 [MgmSrvr] INFO -- Node 2: Start phase 2 completed (system restart)
2006-03-02 15:11:35 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2006-03-02 15:11:35 [MgmSrvr] ALERT -- Node 2: Forced node shutdown completed. Occured during startphase 3. Initiated by signal 0. Caused by error 2350: 'Invalid configuration received from Management Server(Configuration error). Permanent error, external action needed'.
Any help would be great, was having soo much fun just trying to get more nodes and mysql servers connected Smile
-espee