89565

Unsupported or Missing Features in MySQL Cluster

A number of features supported by other storage engines are not supported for 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:

•    lndex prefixes. Prefixes on indexes are not supported for NDBCLUSTEP. tables. If a prefix is used

as part of an index specification in a statement such as CREATE TABLE, ALTER

TABLE, or CREATE

INDEX, the prefix is ignored.

•    LOAD TABLE . . . FROM MASTER. LOAD TABLE FROM MASTER is not supported.

•    Savepoints and rollbacks. Savepoints and rollbacks to savepoints are ignored as

in My ISAM.

•    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. Statement-based replication is not supported. Use —binlog-format=ROW [429]

(or —binlog-format=MIXED [429]) when setting up cluster replication. See

Section 17.6, “MySQL

Cluster Replication”, for morę information.