Hello Guys, I am trying to setup a mysql-cluster with two data nodes and one management node.
The sequence of step I followed are: Ran *'ndb_mgmd' *on management node Ran '*ndbd --initial' *on both the data nodes Ran '*mysqld' *on both the data nodes Then the status of the cluster on management node is: [ndbd(NDB)] 2 node(s) id=2 @10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68, Nodegroup: 0, Master) id=3 @10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.253.19. <http://10.253.19.149/>xx (Version: 5.1.68) [mysqld(API)] 2 node(s) id=4 @10.253.4. <http://10.253.4.143/>xx (Version: 5.1.68) id=5 @10.252.151. <http://10.252.151.67/>xx (Version: 5.1.68) Then I tried to create the following 'user_table' on 'user_database': create table user_table( ycsb_key varchar(32) primary key, field1 varchar(100), field2 varchar(100), field3 varchar(100), field4 varchar(100), field5 varchar(100), field6 varchar(100), field7 varchar(100), field8 varchar(100), field9 varchar(100), field10 varchar(100)) max_rows=1000 engine=ndbcluster partition by key(ycsb_key); I get this error: *ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157)* Can you guys please help me in this . And when I ran *mysql> show engines; *I get this * * +------------+---------+-----------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+-----------------------------------------------------------+--------------+------+------------+ | ndbcluster | DEFAULT | Clustered, fault-tolerant tables | YES | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | +------------+---------+-----------------------------------------------------------+--------------+------+------------+ -- Thanks & Regards Venkata Sai Ganji Graduate Student Dept of Computer Science Montana State University - Bzn
