MySQL Cluster Performance Tuning

Database Administration
24 April 3:30pm - 4:20pm @ Ballroom E

Correct tuning of MySQL NDB Cluster can have dramatic impact on performance.
As a distributed shared-nothing system, it is quite sensitive to tuning of communication buffers, or correct partitioning of the schema.

In this session we will look at different tuning aspects of MySQL Cluster.

- Application design guidelines
- Schema Optimization
- Index Selection and Tuning
- Query Tuning
- Performance comparison SQL vs NOSQL (memcached etc)
- Impact of Foreign Keys (new feature in 7.3)
- Parameter Tuning Guidelines

We will look closely at the new parameters and status variables of MySQL Cluster 7.3 to determine issues.


Johan Andersson
co-founder, Severalnines
Johan works for Severalnines, a company focused on building fast, scalable, and highly available solutions. Prior to Severalnines, Johan was working at Ericsson/MySQL/Sun/Oracle and was the Principal Consultant and lead of the Cluster consulting group.