MySQL Forums
Forum List  »  Quality Assurance

mysql cluster - two mgmt node not work.
Posted by: hyeong seon son
Date: October 09, 2007 10:08PM

two mgmt node communicate with each other.

it worked well, but now it does not work.

what is the problem?


[root@BOSSDB mysql-cluster-tar]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 2xx.39.23.223:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 2xx.39.23.223)
id=3 (not connected, accepting connect from 2xx.39.23.212)

[ndb_mgmd(MGM)] 2 node(s)
id=6 (not connected, accepting connect from 2xx.39.23.212)
id=7 @2xx.39.23.223 (Version: 5.1.22)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 2xx.39.23.223)
id=5 (not connected, accepting connect from 2xx.39.23.212)

ndb_mgm> quit
[root@BOSSDB mysql-cluster-tar]# cat ndb_7_out.log
Unable to connect to our own ndb_mgmd (Error -1)
This is probably a bug.
NDB Cluster Management Server. Version 5.1.22 (rc)
Id: 7, Command port: 1186
setEventReportingLevelImpl: failed 2!
setEventReportingLevelImpl: failed 2!
setEventReportingLevelImpl: failed 2!
setEventReportingLevelImpl: failed 2!
setEventReportingLevelImpl: failed 2!
[root@BOSSDB mysql-cluster-tar]# cat ndb_7_cluster.log
2007-10-10 12:50:57 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 5.1.22 (rc)
2007-10-10 12:50:57 [MgmSrvr] INFO -- Id: 7, Command port: 1186


[root@BOSSDB mysql-cluster-tar]# cat /usr/local/mysql/ndb-config.ini
# Example Ndbcluster storage engine config file.
#
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster-tar
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster-tar

[ndb_mgmd]
Id=7
HostName= 2xx.39.23.223
ArbitrationRank=2
#PortNumber=2200

[ndb_mgmd]
Id=6
HostName= 2xx.39.23.212
ArbitrationRank=1
#PortNumber=2200

[ndbd]
Id=2
HostName= 2xx.39.23.223

[ndbd]
Id=3
HostName= 2xx.39.23.212

[mysqld]
Id=4
hostname= 2xx.39.23.223

[mysqld]
Id=5
hostname= 2xx.39.23.212

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63133



Edited 2 time(s). Last edit at 10/10/2007 01:52AM by hyeong seon son.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql cluster - two mgmt node not work.
4262
October 09, 2007 10:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.