MySQL Forums
Forum List  »  NDB clusters

error 1286 (42000): Unknown table engine 'ndb'
Posted by: Anna Foutsi
Date: May 13, 2014 08:57AM

I get this error when I execute the below command
mysql> create table simples (id int not null primary key) engine=ndb;

my.cnf:
[mysqld]
ndbcluster
datadir=c:\\Users\\user1\\my_cluster\\mysqld_data
basedir=c:\\Users\\user1\\mysqlc
port=5000

config.ini:
[ndb_mgmd]
hostname=localhost
datadir=c:\Users\user1\my_cluster\ndb_data
NodeId=1

[ndbd default]
noofreplicas=2
datadir=c:\Users\user1\my_cluster\ndb_data

[ndbd]
hostname=localhost
NodeId=3

[ndbd]
hostname=localhost
NodeId=4

[mysqld]
NodeId=50

mysql> show engines\G;
*************************** 1. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 2. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MyISAM
Support: YES
Comment: MyISAM storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 6. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 9. row ***************************
Engine: PERFORMANCE_SCHEMA
Support: YES
Comment: Performance Schema
Transactions: NO
XA: NO
Savepoints: NO
9 rows in set (0.00 sec)

ERROR:
No query specified

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
error 1286 (42000): Unknown table engine 'ndb'
3509
May 13, 2014 08:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.