Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

3 Answers

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.

share|improve this answer
add comment

The Getting Started guides talk you through deployment on a single host - select the guide for your OS and go from there: http://mysql.com/products/cluster/start.html#getting_started

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): http://mysql.com/why-mysql/white-papers/mysql_wp_scaling_web_databases.php

share|improve this answer
add comment

Your Answer

 
discard

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.