Introduction to MySQL Clusters

Due to lack of concise information on putting together a MySQL Cluster I’ve decided to assemble a step-by-step guide. On the high level, here are the steps:

  1. Compiling from the sources
  2. Setting up a basic 4-machine cluster
  3. Adding a new Application Server to the cluster
  4. Adding a new Management Server to the cluster
  5. Adding a new cluster group consisting of two ndb nodes
  6. Adding a Proxy Server
  7. Testing the MySQL cluster
  8. Backing up and Restoring from backup
  9. Replacing a broken ndb server with a new one
  10. Moving MySQL 4.1 MyISAM to a MySQL Cluster ndbcluster

A high level diagram
schema1

I’m using Ubuntu 13.04 Server

, August 12, 2013. Category: MySQL Cluster.

About rupic

View all posts by rupic
→