MySQL Forums
Forum List  »  NDB clusters

Re: Multiple MGM nodeid problem
Posted by: Jonathan Miller
Date: September 02, 2005 07:55AM

Hi,

Lets look first at the config.ini. Here are a few changes you could make.

[NDBD DEFAULT]
NoOfReplicas=3
DataMemory=80M
IndexMemory=50M
datadir=/var/lib/mysql-cluster/logs <----- Since all the NDBD use same datadir

[TCP DEFAULT]
portnumber=80

[NDB_MGMD]
id=1
hostname=192.168.50.51
PortNumber=5050
datadir=/var/lib/mysql-cluster/logs
ArbitrationRank=1

[NDB_MGMD]
id=2
hostname=192.168.50.52
PortNumber=5050 <------- Not sure if you want to use the default or same as id=1
datadir=/var/lib/mysql-cluster/logs
ArbitrationRank=2


[NDBD]
id=5
hostname=192.168.50.50
<-------- datadir is not needed here because of default above
[NDBD]
id=6
hostname=192.168.50.51

[NDBD]
id=7
hostname=192.168.50.52

etc ...

for the my.cnf it you need:

ndbcluster # run NDB engine
ndb-connectstring=192.168.50.51:5050 # location of MGM node


I hope this helps.
JBM

Options: ReplyQuote


Subject
Views
Written By
Posted
2810
September 02, 2005 07:40AM
Re: Multiple MGM nodeid problem
1901
September 02, 2005 07:55AM
1464
September 02, 2005 08:04AM
1583
September 02, 2005 08:25AM
1636
September 05, 2005 02:54AM
1680
September 08, 2005 12:56AM


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.