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:1186
[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:1186
[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),
[r...@test mysql-cluster]# ndb_mgmd --initial
--connect-string=nodeid=1,192.168.1.125:1186,192.168.1.107:1186
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 :
------------------------------------------------------
[r...@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":
--------------------------
[r...@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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
