Unable to configuring multiple Management nodes.

Unable to configuring multiple Management nodes.

am 31.08.2009 13:20:16 von Manoj Burande

Hi There,

I am just trying to configure the two mgmt nodes on two different host but
there is some error while starting the ndb_"mgmd".

Required information is as follows:

Hosts:
192.168.1.107
192.168.1.125

Required configuration for 192.168.1.107:
-----------------------------------------
On 192.168.1.107 : 2 mgmt node(having an entry of another host's mgmt node
and itself one).
On 192.168.1.107 : 2 mysql node(having an entry of another host's mysql
node and itself one).
On 192.168.1.107 : 2 data nodes(having an entry of another host's data
node and itself one).

Required configuration for 192.168.1.125:
-----------------------------------------
As same as required by the host 192.168.1.107


The "config.ini" on host:192.168.1.107 configuration file is as,
============================================================ ====
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=3500M # How much memory to allocate for data storage
IndexMemory=1000M # How much memory to allocate for index storage
#MaxNoOfConcurrentOperations=1048576
#MaxNoOfConcurrentTransactions= 1048576
#MaxNoOfLocalOperations=1048576
#MaxNoOfConcurrentIndexOperations=16384
#MaxNoOfConcurrentScans=500
#LockPagesInMainMemory=Y
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any

# Management process options:
[NDB_MGMD]
id=1
hostname=192.168.1.107 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[NDB_MGMD]
id=2
hostname=192.168.1.125 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
id=3
hostname=192.168.1.107 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B":
[NDBD]
id=4
hostname=192.168.1.125 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# SQL node options:
[MYSQLD]
id=5
hostname=192.168.1.107
[MYSQLD]
id=6
hostname=192.168.1.125

The "my.cnf" on host:192.168.1.107 configuration file is as,
============================================================
# The MySQL server
[mysql_cluster]
ndb-connectstring=nodeid=1,192.168.1.107:1186,192.168.1.125: 1186
[ndbd]
connect-string=192.168.1.107:1186,192.168.1.125:1186
[ndb_mgm]
connect-string=nodeid=1,192.168.1.107:1186,192.168.1.125:118 6
[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
[mysqld]
ndbcluster
ndb-connectstring=nodeid=1,192.168.1.107:1186,192.168.1.125: 1186

The "config.ini" on host:192.168.1.125 configuration file is as,
============================================================ ====
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=3500M # How much memory to allocate for data storage
IndexMemory=1000M # How much memory to allocate for index storage
#MaxNoOfConcurrentOperations=1048576
#MaxNoOfConcurrentTransactions= 1048576
#MaxNoOfLocalOperations=1048576
#MaxNoOfConcurrentIndexOperations=16384
#MaxNoOfConcurrentScans=500
#LockPagesInMainMemory=Y
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any

# Management process options:
[NDB_MGMD]
id=1
hostname=192.168.1.107 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[NDB_MGMD]
id=2
hostname=192.168.1.125 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
id=3
hostname=192.168.1.107 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B":
[NDBD]
id=4
hostname=192.168.1.125 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# SQL node options:
[MYSQLD]
id=5
hostname=192.168.1.107
[MYSQLD]
id=6
hostname=192.168.1.125

The "my.cnf" on host:192.168.1.125 configuration file is as,
============================================================
# The MySQL server
[mysql_cluster]
ndb-connectstring=nodeid=2,192.168.1.107:1186,192.168.1.125: 1186
[ndbd]
connect-string=nodeid=192.168.1.107:1186,192.168.1.125:1186
[ndb_mgm]
connect-string=nodeid=2,192.168.1.107:1186,192.168.1.125:118 6
[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
[mysqld]
ndbcluster
ndb-connectstring=nodeid=2,192.168.1.107:1186,192.168.1.125: 1186

After all configuration done (on both server) I am trying to start the
mgmt using the
following command as(on both server),

[root@test mysql-cluster]# ndb_mgmd --initial
--connect-string=nodeid=1,192.168.1.125:1186,192.168.1.107:1 186
2009-08-31 13:02:41 [MgmSrvr] INFO -- NDB Cluster Management Server.
mysql-5.1.34
ndb-7.0.6
2009-08-31 13:02:42 [MgmSrvr] INFO -- Reading cluster configuration from
'/var/lib/mysql-cluster/config.ini'
2009-08-31 13:02:42 [MgmSrvr] WARNING -- at line 44: Cluster
configuration warning:
arbitrator with id 1 and db node with id 3 on same host 192.168.1.107
arbitrator with id 2 and db node with id 4 on same host 192.168.1.125
Running arbitrator on the same host as a database node may
cause complete cluster shutdown in case of host failure.

After that I did on "host:192.168.1.107" the following :
------------------------------------------------------
[root@ns mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: 192.168.1.107:1186
ERROR Message: The cluster configuration is not yet confirmed by all
defined management
servers. This management server is still waiting for node 2 to connect.

Could not get configuration
* 4012: Failed to get configuration
* The cluster configuration is not yet confirmed by all defined
management servers.
This management server is still waiting for node 2 to connect.

and on "host:192.168.1.125":
--------------------------
[root@test mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: 192.168.1.125:1186
ERROR Message: The cluster configuration is not yet confirmed by all
defined management
servers. This management server is still waiting for node 1 to connect.

Could not get configuration
* 4012: Failed to get configuration
* The cluster configuration is not yet confirmed by all defined
management servers.
This management server is still waiting for node 1 to connect.



Please help me. I am working on the same since 2 days but the proper
solution is not
getting from everywhere. I am stucked on this issue.

So please provide me the proper steps to configure multiple management
nodes with respect
to the above mentioned scenario.


--
Manoj M. Burande,
Artificial Machines Pvt Ltd,
System Administrator.



--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe: http://lists.mysql.com/cluster?unsub=gcdmc-cluster@m.gmane.o rg