A number of features supported by other storage engines are not
NDB tables. Trying to
use any of these features in MySQL Cluster does not cause errors
in or of itself; however, errors may occur in applications that
expects the features to be supported or enforced:
Foreign key constraints.
The foreign key construct is ignored, just as it is in
Prefixes on indexes are not supported for
NDBCLUSTER tables. If a prefix is used
as part of an index specification in a statement such as
ALTER TABLE, or
CREATE INDEX, the prefix is
OPTIMIZE operations are not supported.
LOAD TABLE ... FROM MASTER.
LOAD TABLE ... FROM MASTER is not
Savepoints and rollbacks.
Savepoints and rollbacks to savepoints are ignored as in
Durability of commits. There are no durable commits on disk. Commits are replicated, but there is no guarantee that logs are flushed to disk on commit.
Replication. Replication is not supported.
See Section 126.96.36.199, “Limits Relating to Transaction Handling in MySQL Cluster”,
for more information relating to limitations on transaction