MySQL Cluster Performance Tuning Best Practices – Webinar replay available

For anyone that missed the recent webinar on getting the best performance out of MySQL Cluster then the replay is now available from mysql.com.

Benefits of connection pooling
Benefits of connection pooling

Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Then this free web presentation is for you! You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance when using MySQL Cluster.

It discusses guidelines and best practices covering the following areas:

  • General Design Concepts and Guidelines
  • Schema Optimization
    • BLOB/Text vs VARBINARY/VARCHAR
    • Partition by Key
  • Index Selection and Tuning
  • Basic Query Tuning
  • MySQL Cluster Parameter Tuning Guidelines
  • Tools to accelerate application development and testing

3 thoughts on “MySQL Cluster Performance Tuning Best Practices – Webinar replay available

  1. I have a question about where the actual mysql data is stored in a cluster.

    The ext3 file system has a limit of 32,000 subdirectories. This means you are limited to 32,000 databases on a single mysql server.

    If you have 2 data node groups in a mysql cluster, is the data within the databases split into the 2 groups or are the databases entirely either on one data node group or another?

    How reliable is running an XFS file system for the mysql cluster data nodes.

    thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please enter. * Time limit is exhausted. Please reload CAPTCHA.