Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am very new to mysql-cluster.I downloaded the binaries and was trying to configure it on my local machine.

Can anybody suggest how to install it on single machine with the 1 management node,2 data nodes,1 sql node.

Also what are the importance of each type of node?

I need the basics steps to install the mysql-cluster.As I have installed it by seeing some website and stuck in between i am getting an error as

mysql> show warnings;
| Level | Code | Message                                                                         |
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock |
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB                                       |
2 rows in set (0.00 sec)

I also have gone through the manual but no results.

Anybody can help me out in this?

share|improve this question
can you provide your config files? – sreimer May 11 '12 at 14:31

For single machine setups, you can also check out the Cluster Sandbox:

Good luck!


Edit By RolandoMySQLDBA 2012-05-15 13:34 EDT

Check out the Training Slides :

IMHO it would be a fine starting point for beginners to install & learn MySQL Cluster.

share|improve this answer

The Getting Started guides talk you through deployment on a single host - select the guide for your OS and go from there:

The Data nodes store all the actual tables of your database. They automatically shard your tables across the nodes, and provide replication, failover, recovery, etc for high availability

The SQL node provides a SQL API to your data

The Management nodes are used at cluster startup and configuration, as well as perform arbitration between nodes

You can learn more about the architecture of MySQL Cluster from this whitepaper (registration required):

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.