| MySQLServer Version |
5.6 |
5.6 |
| InnoDBVersion
|
InnoDB5.6.23
|
InnoDB5.6.23
|
| MySQLCluster Version |
N/A |
NDB7.3.9
|
| StorageLimits |
64TB |
3TB (Practicalupper limit based on 48 data nodes with 64GB RAM each; can beincreased with disk-based data and BLOBs) |
| ForeignKeys |
Yes |
Priorto MySQL Cluster NDB 7.3: No. (Ignored, as withMyISAM) Availablein MySQL Cluster NDB 7.3.
|
| Transactions |
Allstandard types |
READCOMMITTED
|
| MVCC |
Yes |
No |
| DataCompression |
Yes |
No (MySQLCluster checkpoint and backup files can be compressed) |
| LargeRow Support (> 14K) |
SupportedforVARBINARY,VARCHAR,BLOB,andTEXTcolumns |
SupportedforBLOBandTEXTcolumns only (Usingthese types to store very large amounts of data can lower MySQLCluster performance)
|
| ReplicationSupport |
Asynchronousand semisynchronous replication using MySQL Replication |
Automaticsynchronous replication within a MySQL Cluster. Asynchronousreplication between MySQL Clusters, using MySQL Replication |
| Scaleoutfor Read Operations |
Yes(MySQL Replication) |
Yes(Automatic partitioning in MySQL Cluster; MySQL Replication) |
| Scaleoutfor Write Operations |
Requiresapplication-level partitioning (sharding) |
Yes(Automatic partitioning in MySQL Cluster is transparent toapplications) |
| HighAvailability (HA) |
Requiresadditional software |
Yes(Designed for 99.999% uptime) |
| NodeFailure Recovery and Failover |
Requiresadditional software |
Automatic (Keyelement in MySQL Cluster architecture) |
| Timefor Node Failure Recovery |
30seconds or longer |
Typically< 1 second |
| Real-TimePerformance |
No |
Yes |
| In-MemoryTables |
No |
Yes (Somedata can optionally be stored on disk; both in-memory and diskdata storage are durable) |
| NoSQLAccess to Storage Engine |
Nativememcached interface in development (see the MySQL Dev ZonearticleMySQLCluster 7.2 (DMR2): NoSQL, Key/Value, Memcached) |
Yes MultipleAPIs, including Memcached, Node.js/JavaScript, Java, JPA, C++,and HTTP/REST |
| Concurrentand Parallel Writes |
Notsupported |
Upto 48 writers, optimized for concurrent writes |
| ConflictDetection and Resolution (Multiple Replication Masters) |
No |
Yes |
| HashIndexes |
No |
Yes |
| OnlineAddition of Nodes |
Read-onlyreplicas using MySQL Replication |
Yes(all node types) |
| OnlineUpgrades |
No |
Yes |
| OnlineSchema Modifications |
Yes,as part of MySQL 5.6. |
Yes. |