Tag Archives: White Paper

Optimizing Performance of the MySQL Cluster Database – White Paper update

A new version of the white paper “Guide to Optimizing Performance of the MySQL Cluster Database” has been released; download it here.

This paper steps you through:

  • Identifying if your application is a good fit for MySQL Cluster
  • Measuring performance and identifying problem performance areas to address
  • Optimizing performance:
    • Access patterns
    • Using Adaptive Query Localization for complex Joins
    • Distribution aware applications
    • Batching operations
    • Schema optimizations
    • Query optimization
    • Parameter tuning
    • Connection pools
    • Multi-Threaded Data Nodes
    • Alternative APIs
    • Hardware enhancements
    • Miscellaneous
  • Scaling MySQL Cluster by Adding Nodes

As well as the kind of regular updates that are needed from time to time, this version includes the extra opportunities for optimizations that are available with MySQL Cluster 7.2 such as faster joins and engineering the threads within a multi-threaded data node.…

New white paper: Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.…