mysql cluster problem in ubuntu

Posted by Firman on Server Fault See other posts from Server Fault or by Firman
Published on 2011-02-27T02:28:30Z Indexed on 2011/02/27 7:26 UTC
Read the original article Hit count: 128

Filed under:
|

I have a problem while installing and configuring mysql cluster runnign on ubuntu 10.10

This is configuration for Cluster management

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=10MB
IndexMemory=25MB
MaxNoOfTables=256
MaxNoOfOrderedIndexes=256
MaxNoOfUniqueHashIndexes=128

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[NDB_MGMD]
Id=1                            # the NDB Management Node (this one)
HostName=192.168.10.101

[NDBD]
Id=2                            # the first NDB Data Node
HostName=192.168.10.11
DataDir= /var/lib/mysql-cluster

[NDBD]
Id=3                            # the second NDB Data Node
HostName=192.168.10.12
DataDir=/var/lib/mysql-cluster

[MYSQLD]
[MYSQLD]

and this is configuration for both node :

[mysqld]
ndbcluster
ndb-connectstring=192.168.10.101        # the IP of the MANAGMENT (THIRD) SERVER


[mysql_cluster]
ndb-connectstring=192.168.10.101        # the IP of the MANAGMENT (THIRD) SERVER

After running all node and management, and I use ndb_mgm, the type 'show' command, and something appear like this :

ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2    @192.168.10.11  (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=3    @192.168.10.12  (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)

id=1    @192.168.10.101  (mysql-5.1.39 ndb-7.0.9)



[mysqld(API)]   1 node(s)


id=4 (not connected, accepting connect from 192.168.10.101)

look at two last line.. not as what http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html look like (see at point 4)

anyone have ever had this problem ?

© Server Fault or respective owner

Related posts about mysql

Related posts about cluster