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: 149
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