《MySQL_Cluster_72_DMR_EvaluationGuide》.pdfVIP

MySQL Cluster Evaluation Guide MySQL Cluster 7.2 Evaluation A MySQL® Technical White Paper December 2011 Copyright © 2011, Oracle and/or its affiliates. All rights reserved Table of Contents 1 INTRODUCTION 4 2 WHAT IS MYSQL CLUSTER? 4 2.1 MySQL Cluster Architecture 5 3 KEY FEATURES OF MYSQL CLUSTER 7.2 7 4 POINTS TO CONSIDER BEFORE STARTING AN EVALUATION 7 4.1 Will MySQL Cluster “out of the box” run an application faster than my existing MySQL database? 7 4.2 How do I install MySQL Cluster? 8 4.3 Does the database need to run on a particular operating system? 8 4.4 Will the entire database have fit in memory? 9 4.5 Does the application make use of complex JOIN operations? 9 4.6 Does the application make use of full table scans? 10 4.7 Does the database require foreign keys? 10 4.8 Does the application require full-text search? 10 4.9 How will MySQL Cluster perform compared to other storage engines? 11 4.10 Does MySQL Cluster’s data distribution add complexity to my application and limit the types of queries I can run? 12 5 EVALUATION BEST PRACTICES 13 5.1 Hardware 13 5.2 Performance metrics 15 5.3 Test tools 16 5.4 SQL and NoSQL interfaces 16 5.5 Data model and query design 18 5.6 Using disk data tables or in-memory tables 20 5.7 User defined partitioning and distribution awareness 20 Copyright © 2011, Oracle and/or its affiliates. All rights reserved Page 2 of 29 5.8 Parallelizing applications and other tips 21 6 CONFIGURATION FILES: BEST PRACTICES 22 7 SANITY CHECK 23 7.1 A few basic tests