MySQL Cluster Installation

MySQLmysql-cluster

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?

Best Answer

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

http://www.severalnines.com/resources/mysql-cluster-sandbox-pre-defined-packages

Good luck!

Vinay

http://www.severalnines.com/

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

Check out the Training Slides : http://severalnines.com/mysql-cluster-training

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