MySQL Cluster Performance Tuning

Database Administration
2 April 3:50PM - 4:40PM @ Ballroom C

Experience level: 
Beginner
Duration: 
50 minutes conference
The MySQL Cluster 7.x series introduced a number of features to allow for fine-grained control over the real-time behaviour of the NDB storage engine. New threads have been introduced, and users are able to control placement of these threads, as well as locking the memory such that no swapping occurs. In an ideal runtime environment, CPUs handling data node threads will not execute other threads apart from OS kernel threads or interrupt handling. Correct tuning of certain parameters can be specially important for certain types of workloads. In this session we will look at different tuning aspects of MySQL Cluster. - Application design guidelines - Schema Optimization - Index Selection and Tuning - Query Tuning - OS Tuning - Data Node internals - Optimizations for real-time behaviour We will look closely at how to get the most out of your MySQL Cluster 7.x runtime environment.


Speakers

co-founder, Severalnines
Biography: 
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.