MYSQL CLUSTER PERFORMANCE TUNING
12 November 2:50pm - 3:40pm @ Cromwell 3-4
50 minutes conference
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 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.