No
No
Yes
No
No
Datacaches
No
N/A
Yes
No
Yes
Indexcaches
Yes
N/A
Yes
No
Yes
Compresseddata
Yes[d]
No
Yes[e]
Yes
No
Encrypteddata[f]
Yes
Yes
Yes
Yes
Yes
Clusterdatabase support
No
No
No
No
Yes
Replicationsupport[g]
Yes
Yes
Yes
Yes
Yes
Foreignkey support
No
No
Yes
No
No
Backup/ point-in-time recovery[h]
Yes
Yes
Yes
Yes
Yes
Querycache support
Yes
Yes
Yes
Yes
Yes
Updatestatistics for data dictionary
Yes
Yes
Yes
Yes
Yes
[a]InnoDB support for geospatial indexing is available in MySQL5.7.5 and higher.
[b]InnoDB utilizes hash indexes internally for its AdaptiveHash Index feature.
[c]InnoDB support for FULLTEXT indexes is available in MySQL5.6.4 and higher.
[d]Compressed MyISAM tables are supported only when using thecompressed row format. Tables using the compressed row formatwith MyISAM are read only.
[e]Compressed InnoDB tables require the InnoDB Barracuda fileformat.
[f]Implemented in the server (via encryption functions), ratherthan in the storage engine.
[g]Implemented in the server, rather than in the storageengine.
[h]Implemented in the server, rather than in the storageengine.
要选mysql cluster要根据ndb存储引擎的特征和应用场景做详细测试