Re: data loss after restart the cluster

[sangram katkar]

hi Jon,

I use below step to stop the cluster:: ( when database have data into it)

1) login to mgm node1

#ndb_mgm
ndb_mgm>show (all the node are running ( 2 mgm, 2 sql, 2 data) )
ndb_mgm>shutdown

2) login to sql-1 node

#/etc/init.d/mysql.server stop

3) login to sql-2 node

#/etc/init.d/mysql.server stop

Step to start the cluster::

1) login to the mgm node1

#ndb_mgmd --initial --skip-config-cache -f /var/lib/mysql-cluster/config.ini

(i am using --skip-config-cache because i had added some parameters in config.ini)

#ndb_mgm
ndb_mgm>show ( out put show the mgm node 1 is connected )

2) login to the mgm node2

#ndb_mgmd --initial --skip-config-cache -f /var/lib/mysql-cluster/config.ini

#ndb_mgm
ndb_mgm>show ( out put show the mgm node-1 & mgm node-2 is connected )

3) login to data node-1

#ndbd

4) login to data node-2

#ndnd

5) login to sql node-1

#/etc/init.d/mysql.server start

6) login to sql node-2

#/etc/init.d/mysql.server start

7) login to mgm node-1

#ndb_mgm
ndb_mgm>show (all the node are running ( 2 mgm, 2 sql, 2 data) )

but when I check my database it is empty .