[asyadiqin]

I have 1 management node (192.168.0.1) and 2 storage nodes (node1:192.168.0.2 / node2:192.168.0.3).

On the mgm node, the config.ini is as follows :-

[NDBD DEFAULT]
NoOfReplicas=2

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
HostName=192.168.0.1

[NDBD]
HostName=192.168.0.2
DataDir= /var/lib/mysql-cluster

[NDBD]
HostName=192.168.0.3
DataDir= /var/lib/mysql-cluster

[MYSQLD]
[MYSQLD]

On both node machines, the my.cnf are as follows:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=192.168.0.1

[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=192.168.0.1

On the mgm node, these are what is shown in the mgm console.

-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.2 (Version: 5.0.26, starting, Nodegroup: 0)
id=3 @192.168.0.3 (Version: 5.0.26, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 (Version: 5.0.26)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

Previously, I have created a test database with 1 table (cluster.table_1). Below is the error in both storage nodes.

[root@fc5-g2 ~]# mysql -uroot -pmypassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.26-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cluster |
| db_ispconfig |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)

mysql> USE cluster;

Database changed
mysql> SHOW TABLES;
+-------------------+
| Tables_in_cluster |
+-------------------+
| table_1 |
+-------------------+
1 row in set, 1 warning (0.00 sec)

mysql> SELECT * FROM table_1;
ERROR 1105 (HY000): Failed to open 'table_1', error while unpacking from engine

mysql> DROP TABLE table_1;
ERROR 1051 (42S02): Unknown table 'table_1'

mysql> DROP DATABASE cluster;
ERROR 1051 (42S02): Unknown table 'table_1'

First of all, what is happening? Is there anyway I can either access or delete that database at all.

I am quite new to MySQL clustering and do not understand why this is happening. Any help is appreciated. Thanks.