This tutorial covers: - Overview of MySQL Cluster - Features: 4.1, 5.0 and 5.1 - and what they mean for real world applications - hardware considerations - installation and configuration - administration (online backups and upgrades) - what Cluster is best at and how to tell if your application is suited to it. - preparing your data for mysql cluster - working out hardware and storage requirements (for different versions of cluster) - Optimising your application for Cluster - tricks of the trade for getting the most out of MySQL Cluster - what happens during a full table scan (and how to avoid them) - new features for increased performance - measuring performance Since cluster means executing things in parallel, standard benchmarking methods can be meaningless. We'll cover how to get much more sensible and meaningful benchmarks. - When Cluster is the wrong solution. Sometimes other solutions will serve particular applications better. We go over how to identify them. Prior experience using a RDBMS is assumed, as well as a knowledge of SQL and database concepts. We will be using real world applications, migrating them to a clustered environment and performing analysis on them.
Stewart Smith is a Software Engineer at MySQL AB. He works on MySQL Cluster - a clustered database desgined to deliver performance and high availability on commodity hardware.