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
CTO, Severalnines
Johan is CTO at Severalnines, a company that enables developers to easily deploy, manage, monitor and scale highly-available MySQL clusters in the data center, in hosted environments and on the cloud. Prior to Severalnines, Johan worked at MySQL/Sun/Oracle and was the Principal Consultant and lead of the MySQL Clustering and High Availability consulting group, where he designed and implemented large-scale MySQL systems at key customers.