Help WIth Data relying on Node1
Hi, this is the first time I have used a group so please bare with me.
I have just got a three node cluster working, my first attempt, and testing and learning it before it goes live.
If i write info into the table in node1 - node2 - node3 then they successfully update each other and seam to be working well.
In testing I then shutdown node3 and restarted and it caught up, same as node2, but when I shutdown node1 the other two keep talking to each other as in management nodes, but the data is inaccessible, although it seams to be stored in the local directory data folder.
Yes I am new to this and learning fast so please be patient and offer some advice and help.
_______________________________________________________
Yes to test I have put management query and storage on all three nodes.
192.168.99.231 (node1)
my.cnf----------------------
[mysqld]
ndb-nodeid=51
ndbcluster
datadir=/home/mysql/my_cluster/mysqld_data
basedir=/home/mysql/mysqlc
port=3306
server-id=51
log-bin
192.168.99.232 (node2)
my.cnf----------------------
[mysqld]
ndb-nodeid=52
ndbcluster
datadir=/home/mysql/my_cluster/mysqld_data
basedir=/home/mysql/mysqlc
port=3306
server-id=52
log-bin
192.168.99.233 (node3)
my.cnf----------------------
[mysqld]
ndb-nodeid=53
ndbcluster
datadir=/home/mysql/my_cluster/mysqld_data
basedir=/home/mysql/mysqlc
port=3306
server-id=53
log-bin
_______________________________________________________
config.ini---------------------- (Same on all three)
[ndb_mgmd]
hostname=ip231
datadir=/home/mysql/my_cluster/ndb_data
NodeId=101
[ndb_mgmd]
hostname=ip232
datadir=/home/mysql/my_cluster/ndb_data
NodeId=102
[ndb_mgmd]
hostname=ip233
datadir=/home/mysql/my_cluster/ndb_data
NodeId=103
[ndbd default]
noofreplicas=3
datadir=/home/mysql/my_cluster/ndb_data
[ndbd]
hostname=ip231
NodeId=1
[ndbd]
hostname=ip232
NodeId=2
[ndbd]
hostname=ip233
NodeId=3
[mysqld]
hostname=ip231
NodeId=51
[mysqld]
hostname=ip232
NodeId=52
[mysqld]
hostname=ip233
NodeId=53
_______________________________________________________
All three nodes running fine
[ndbd(NDB)] 3 node(s)
id=1 @192.168.99.231 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=2 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=3 @192.168.99.233 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
[ndb_mgmd(MGM)] 3 node(s)
id=101 @192.168.99.231 (mysql-5.5.22 ndb-7.2.6)
id=102 @192.168.99.232 (mysql-5.5.22 ndb-7.2.6)
id=103 @192.168.99.233 (mysql-5.5.22 ndb-7.2.6)
[mysqld(API)] 3 node(s)
id=51 @192.168.99.231 (mysql-5.5.22 ndb-7.2.6)
id=52 @192.168.99.232 (mysql-5.5.22 ndb-7.2.6)
id=53 @192.168.99.233 (mysql-5.5.22 ndb-7.2.6)
_______________________________________________________
node 1 shutdown node 2 & 3 running but no data in the databases ;
[ndbd(NDB)] 3 node(s)
id=1 (not connected, accepting connect from ip231)
id=2 (not connected, accepting connect from ip232)
id=3 (not connected, accepting connect from ip233)
[ndb_mgmd(MGM)] 3 node(s)
id=101 (not connected, accepting connect from ip231)
id=102 @192.168.99.232 (mysql-5.5.22 ndb-7.2.6)
id=103 @192.168.99.233 (mysql-5.5.22 ndb-7.2.6)
[mysqld(API)] 3 node(s)
id=51 (not connected, accepting connect from ip231)
id=52 (not connected, accepting connect from ip232)
id=53 (not connected, accepting connect from ip233)
_______________________________________________________