MySQL Cluster Performance Tuning Best Practices – Webinar replay availablePosted on February 5th, 2010 3 comments
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.
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
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.
The link from mysql site refers to unavailable server, Do you have any other archive, would be really helpful
Leave a reply