Hi Geert,
Thanks for your reply.
I did everything which you have written in your reply. Below are the
steps(as per your reply) and some resulted reports which I had followed,
on host: 192.168.1.107
======================
1] [root@ns mysql-cluster]# ndb_mgmd -f config.ini
--configdir=/var/lib/mysql-cluster/config.ini --initial
2009-08-31 17:41:33 [MgmSrvr] INFO -- NDB Cluster Management Server.
mysql-5.1.34 ndb-7.0.6
on host: 192.168.1.125
======================
2] [root@test mysql-cluster]# ndb_mgmd -f config.ini
--configdir=/var/lib//mysql-cluster/config.ini
2009-08-31 17:44:01 [MgmSrvr] INFO -- NDB Cluster Management Server.
mysql-5.1.34 ndb-7.0.6
2009-08-31 17:44:02 [MgmSrvr] INFO -- Reading cluster configuration
from 'config.ini'
2009-08-31 17:44:02 [MgmSrvr] WARNING -- at line 45: 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.
But still same error reported by mysql-cluster as,
=================================================
on host: 192.168.1.107
======================
3] [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.
on host: 192.168.1.125
======================
[root@test 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.
Can you please provide me the sample configuration files for multiple
"ndb_mgm" and some steps to do the initial start.
>
> On Aug 31, 2009, at 13:20, Manoj Burande wrote:
> ..
>> 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:1186
>
> Only start the first one with --initial, the second one you start
> normally.
> It's indeed still a pain..
>
> mgm1: ndb_mgmd --initial -f ..
> mgm2: ndb_mgmd -f ..
>
> Try if that works. You'll want to remove all the binary-config-cached
> files removed first.
>
> Also:
> http://bugs.mysql.com/bug.php?id=46488
>
> Cheers,
>
> Geert
>
> --
> Geert Vanderkelen, MySQL Senior Support Engineer
> Sun Microsystems GmbH Sonnenallee 1, D-85551 Kirchheim-Heimstetten
>
> Geschaeftsfuehrer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
> Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028
>
>
--
Manoj M. Burande,
Artificial Machines Pvt Ltd,
System Administrator.
