Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
MySQL 9.2 Reference Manual / ... / MySQL NDB Cluster 9.2 / NDB Cluster Overview / MySQL Server Using InnoDB Compared with NDB Cluster / 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.2 Differences between InnoDB and NDB storage engines, commontypes of data-driven application workloads.
| Workload | InnoDB | NDB Cluster (NDB) |
|---|---|---|
| High-Volume OLTP Applications | Yes | Yes |
| DSS Applications (data marts, analytics) | Yes | Limited (Join operations across OLTP datasets not exceeding 3TB in size) |
| Custom Applications | Yes | Yes |
| Packaged Applications | Yes | Limited (should be mostly primary key access); NDB Cluster 9.2 supports foreign keys |
| In-Network Telecoms Applications (HLR, HSS, SDP) | No | Yes |
| Session Management and Caching | Yes | Yes |
| E-Commerce Applications | Yes | Yes |
| User Profile Management, AAA Protocol | Yes | Yes |
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb