Hello All,

I am new to this and hence this might sound a very basic question. I have installed the MYSQL cluster and now I am trying to create a test database which stores it data on the ENGINE=NDBCLUSTER. I tried to generate this manually and got the following output.

[root@mysqlserver ~]# /usr/local/mysql/bin/mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 15

Server version: 5.1.15-beta MySQL Community Server (GPL)

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

mysql> create database example ENGINE=NDBCLUSTER;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=NDBCLUSTER' at line 1

mysql> create database example ENGINE=NDB;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=NDB' at line 1

mysql>

This work was performed on the SQL Server/Node. Following is the output from the MGM node which states that the Cluster is up and running.

ndb_mgm> SHOW

Cluster Configuration

---------------------

[ndbd(NDB)] 2 node(s)

id=2 @172.31.22.80 (Version: 5.1.15, Nodegroup: 0, Master)

id=3 @172.31.22.81 (Version: 5.1.15, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @172.31.22.78 (Version: 5.1.15)

[mysqld(API)] 1 node(s)

id=4 @172.31.22.79 (Version: 5.1.15)

Please advice how we can move forward.

Thank you,

Sri