Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.2.6.2 NDB and InnoDB Workloads

NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also has specific constraints that may keep some workloads from performing well. A number of major differences in behavior between theNDB andInnoDB storage engines with regard to some common types of database-driven application workloads are shown in the following table::

Table 21.2 Differences between InnoDB and NDB storage engines, commontypes of data-driven application workloads.

WorkloadInnoDBNDB Cluster (NDB)
High-Volume OLTP ApplicationsYesYes
DSS Applications (data marts, analytics)YesLimited (Join operations across OLTP datasets not exceeding 3TB in size)
Custom ApplicationsYesYes
Packaged ApplicationsYesLimited (should be mostly primary key access); NDB Cluster 7.5 supports foreign keys
In-Network Telecoms Applications (HLR, HSS, SDP)NoYes
Session Management and CachingYesYes
E-Commerce ApplicationsYesYes
User Profile Management, AAA ProtocolYesYes