Mysql cluster strange behaviour

Posted by Champion on Server Fault See other posts from Server Fault or by Champion
Published on 2010-12-13T12:19:42Z Indexed on 2011/02/27 23:26 UTC
Read the original article Hit count: 417

Hi Guys,

I have 2 mysql clusters on two different servers with management node on each of them.

It went down someway.

I ran following commands to start the cluster:

Start the management node on srv1:
srv1: mysqlc/bin/ndb_mgmd --initial -f my_cluster/conf/config.ini --configdir=/home/mysql_cluster/my_cluster/conf

Start the management node on srv2:
srv2: mysqlc/bin/ndb_mgmd --initial -f my_cluster/conf/config.ini --configdir=/home/mysql_cluster/my_cluster/conf

Start the ndbd nodes on srv1:
srv1: mysqlc/bin/ndbd --initial -c localhost:1186

Start the ndbd nodes on srv2:
srv2: mysqlc/bin/ndbd --initial -c localhost:1186

Start mysqld server on srv1:
srv1: mysqlc/bin/mysqld --defaults-file=my_cluster/conf/my.cnf --user=root &

and here is the problem. mysql server not loading the data. Only database names are present. All the tables which are ENGINE=ndbcluster are not being loaded. Tables with ENGINE=myisam are being loaded. Backup scripts helped me load the data.

But this way I can't use cluster setup.

Similar issue appeared when i started srv2.

How can I resolve this issue ?

© Server Fault or respective owner

Related posts about mysql

Related posts about replication