MySQL Cluster and NoSQL

Attendee prerequisites for this tutorial are listed below.

MySQL Cluster, the marriage of the popular MySQL database to the highly reliable and scalable NDB distributed data store, has evolved significantly over the past several years. This tutorial will be valuable both as an introduction to MySQL Cluster for newcomers and as an update for those who have not looked at MySQL Cluster in 3 years or more. We will cover MySQL Cluster 7.2 from the ground up, configuring and installing clusters using students’ laptops as various nodes. We will configure replication across clusters and discuss clustering and replication options with regard to the CAP theorem. We will look at how the introduction of adaptive query push-down in MySQL Cluster 7.2 radically changes the landscape of SQL query performance. And we will create simple applications using the Cluster/J API for Java and Memcached APIs from a variety of other languages.

• In order to make the most of this tutorial, all students should download and install MySQL Cluster 7.2.6 (PRIOR to attending) from http://dev.mysql.com/downloads/cluster/.

• Students should also have a programmer’s editor such as Emacs, Eclipse, or XCode.

• Participants interested in Java development should also ensure that they have both a Java runtime and a JDK installed, such as the Sun Java 6 JDK or OpenJDK. Note that GNU gcj is not supported.

• Those interested in Memcache development should have Perl 5 and the Cache::Memcached client library, which can be installed from CPAN using the command “cpan install Cache::Memcached”. The Memcache code examples will be simple enough that students who are already familiar with another language and Memcache client library may also be able to translate them on the fly.

QUESTIONS for the speaker?: Use the “Leave a Comment or Question” section at the bottom to address them.