Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.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 25.3 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 8.0 supports foreign keys
In-Network Telecoms Applications (HLR, HSS, SDP)NoYes
Session Management and CachingYesYes
E-Commerce ApplicationsYesYes
User Profile Management, AAA ProtocolYesYes