MySQL Cluster can not find the NDB engine
Posted by: Garey Guan
Date: February 23, 2012 08:47PM

hi, all, i configure the cluster on 3 servers,
from the management node show successful:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.10.245 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0, Master)
id=3 @192.168.10.250 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.249 (mysql-5.1.37 ndb-7.0.8)

[mysqld(API)] 2 node(s)
id=4 @192.168.10.245 (mysql-5.1.37 ndb-7.0.8)
id=5 @192.168.10.250 (mysql-5.1.37 ndb-7.0.8)

ndb_mgm>

but when i create a table like:
create table t(idx int) engine=NDB;

encounter:Unknow table engine 'ndbcluster', is it the mySQL Version issue? i'm using the version:
mysql> select version();
+-------------------------------+
| version() |
+-------------------------------+
| 5.1.37-ndb-7.0.8a-cluster-gpl |
+-------------------------------+
1 row in set (0.00 sec)



mysql> create table t(idx int primary key) engine=NDB;
ERROR 1286 (42000): Unknown table engine 'NDB'
mysql> show engine ndb\G;
ERROR 1286 (42000): Unknown table engine 'ndb'
ERROR:
No query specified

mysql> show engines\G;
*************************** 1. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 2. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MyISAM
Support: YES
Comment: Default engine as of MySQL 3.23 with great performance
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: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
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
8 rows in set (0.00 sec)


kindly help me pls.Thanks.

Regards
Garey

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Cluster can not find the NDB engine
4484
February 23, 2012 08:47PM


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.