List:Cluster« Previous MessageNext Message »
From:periyannan natarajan Date:March 29 2012 6:36am
Subject:REG:SQL Node and Data Nodes.
View as plain text  
I am New to MySQL Cluster.plz some one help for the below:
I am using 5 servers,
192.168.168.43 -management server

192.168.168.100- Data Node server
192.168.168.101 -Data Node server

192.168.168.46 - API Node server
192.168.168.71 - API Node server

my /var/lib/mysql-cluster/config.ini is:
--------------------------------------------
[NDBD DEFAULT]
NoOfReplicas=3

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

#Section for the cluster management node
[NDB_MGMD]
#IP address of the management node (this system)
#Id = 1
HostName=192.168.168.43

#Section for the storage nodes
[NDBD]
#IP address of the first storage node
#Id = 2
HostName=192.168.168.100
DataDir= /var/lib/mysql-cluster

[NDBD]
#IP address of the second storage node
#Id = 3
HostName=192.168.168.101
DataDir= /var/lib/mysql-cluster

[NDBD]
#IP Address of the second storage node
#Id = 4
#HostName=192.168.168.46
#DataDir= /var/lib/mysql-cluster

# one [MYSQLD] per storage node
[MYSQLD]
#Id = 4
HostName=192.168.168.46
[MYSQLD]
#Id = 5
HostName=192.168.168.71
#[MYSQLD]
#Id = 7
#HostName=192.168.168.46

My Management Server Information:
------------------------------------------
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.168.100  (mysql-5.1.51 ndb-7.1.9, Nodegroup: 0)
id=3 @192.168.168.101  (mysql-5.1.51 ndb-7.1.9, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.168.43  (mysql-5.1.51 ndb-7.1.9)

[mysqld(API)] 2 node(s)
id=4 @192.168.168.71  (mysql-5.1.51 ndb-7.1.9)
id=5 @192.168.168.101  (mysql-5.1.51 ndb-7.1.9)

Here API is 192.168.168.101,this is how possibile.because i didnt mentioned
that API in my /var/lib/mysql-cluster/config.ini (in [MYSQLD] section)

Thanks for Advance,

Regards,
Periyannan Natarajan 

--
View this message in context:
http://mysql-cluster.1050023.n4.nabble.com/REG-SQL-Node-and-Data-Nodes-tp4514582p4514582.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.
Thread
REG:SQL Node and Data Nodes.periyannan natarajan29 Mar