A description of the MySQL Cluster startup process and its various phases.

An article describing some key aspects to keep in mind when adding more data nodes in order to gain more performance.

Do you need MySQL High-Availability? How to determine which MySQL High-Availability solution is best?

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture Moshe Shadmon (ScaleDB) Slides can be downloaded at http://assets.en.oreilly.com/1/event/21/The%20ScaleDB%20Storage%20Engine_%20%20Enabling%20High%20Performance%20and%20Scalability%20Using%20Materialized%20Views%20and%20a%20Shared-Disk%20Clustering%20Architecture%20Presentation.ppt The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112

Slides are online (and downloadable) at http://www.slideshare.net/Sheeri/scale-db-preso-for-boston-my-sql-meetup-92009 Mike Hogan, CEO of ScaleDB spoke about ScaleDB at the Boston MySQL User Group in September 2009: ScaleDB is a storage engine for MySQL that delivers shared-disk clustering. It has been described as the Oracle RAC of MySQL. Using ScaleDB, you can scale your cluster by simply adding nodes, without partitioning your data. Each node has full read/write capability, eliminating the need for slaves, while delivering cluster-level load balancing. ScaleDB is looking for additional beta testers, sign up at http://www.scaledb.com

Shows how to start MySQL Cluster 7.0 with 2 management nodes using the new ndb_mgmd behavior caching the configuration and distributing it to the other management nodes.

Shows how to do a rolling restart after a configuration change using MySQL Cluster 7.0 with two management nodes.

Someone asked me what applications were good/bad for MySQL Cluster. As I've now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an application that meets some of the characteristics but not all of them, you can decide whether it's worth it to use Cluster or not).Firstly, I'll state this -- there's actually a very limited application to MySQL cluster. I haven't assessed the disk-based cluster, only the memory-based one, so I don't know what really changes with disk-based. But after you see this list, you certainly will want to re-think your use of disk-based cluster if a lot of the inner workings don't change.The factors are listed below, but the "ruler" I keep in my mind is the fact that MySQL Cluster was developed for telecom applications.  []

If you have a 12-server MySQL Cluster with:1 Management Node3 SQL Nodes2 Data Node Groups, 4 Data Nodes per groupAnd each machine is configured to allocate 1G of memory for its function, how much data (data + indexes) can you store in total in your cluster?You can guess, but you get bonus points if you explain why and the explanation is correct.

MySQL replication is often positioned as a solution to provide extra throughput for your database (especially when dealing with high numbers of read operations). What tends to be overlooked is how it can be used to provide high availability (HA) – no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure – loss of power, earthquake, terrorist attack etc. By using MySQL asynchronous replication to maintain a geographically remote copy of that data, service can be maintained through any single site failure.

Introduction to guaranteed data availability with Continuent Tungsten for MySQL. How to keep data available with automatic seamless failover, automatic slave promotion, avoid data loss, increase database performance and lower cost of data integration. Presented by Robert Hodges, CTO at Continuent.

Introduction to Continuent Tungsten for MySQL: increasing MySQL performance with advanced high performance parallel replication. Presented by Robert Hodges, CTO at Continuent.

Mikael Ronstrom, father of MySQL Cluster, explains the architecture of NDB (MySQL Cluster).

Stewart Smith, MySQL Cluster support at that time, introduces NDB (MySQL Cluster).

Recently faced with the problem of an ordinary table growing too large to back up or maintain, we designed a MySQL-Proxy-based storage cluster which seamlessly integrates with the rest of the database and offers redundancy, cluster-member failure protection, load balancing, and information lifecycle management (data age-out) capabilities.

This proposal is to highlight the integration of Open HA Cluster and MySQL. I will cover the various aspects of high availability and business continuity. In addition to the current features, the roadmap of Open HA Cluster will be discussed. There is a large focus on the integration with MySQL replication and MySQL cluster.

Testing a complex system like MySQL cluster is always difficult. In this session we'll show the ANSTE testing framework and how it can help a project like MySQL do exhaustive testing.

ScaleDB storage engine delivers high performance transaction processing capability with row level locking and multi-node concurrency control. It enhances performance through innovative indexing technology and delivers low cost computing with a Shared Disk architecture. When applications demand more computing power, additional servers are added to the cluster to scale the system capacity.

MySQL Cluster is unique among the selection of MySQL storage engines in that's not exclusively dependent on a MySQL server. The result is that a cluster can be accessed just as any other MySQL database or directly with the native NDB API. This session will cover application development with MySQL Cluster and Java using NDB/J.

In this session we present OpenLDAP/back-ndb which gives an LDAP interface to MySQL Cluster. The LDAP interface on Cluster offers some nice ways of scaling out, as well fantastic performance, and we discuss how this is done. Moreover, it is possible to simultaneously access the LDAP data using e.g SQL! A short demo will be given.