From: Andrew Morgan Date: April 24 2012 11:39am Subject: RE: MySQL Cluster error List-Archive: http://lists.mysql.com/cluster/8310 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hi Anil, What do you mean when you say that you're adding the data to a specific da= ta node? When you add data through your one MySQL Server, it will automatic= ally be populated in both of the data nodes (for redundancy). Note that for a fully fault tolerant solution you would want a second MySQ= L server and the management node shouldn't be on the same host as either of= your data nodes. Regards, Andrew. -----Original Message----- From: ANIL YADAV [mailto:uranil@stripped]=20 Sent: 24 April 2012 12:05 To: cluster@stripped; Nilnadan Joshi MySQL DBA Subject: MySQL Cluster error Hi Team I am a newbie for cluster. I have configured it with 2 data node, 1 managem= ent node and 1 MySQL node. 1 Data node, Management server and MySQL node ar= e running on same server. My management node is showing everything ok. It's= like below. *-- NDB Cluster -- Management Client -- ndb_mgm> ndb_mgm> show Connected to Management Server at: 192.168.80.131:1186 Cluster Configuratio= n --------------------- [ndbd(NDB)] 2 node(s) id=3D2 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master) id=3D3 @192.168.80.132 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=3D1 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5) [mysqld(API)] 2 node(s) id=3D4 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5) id=3D5 (not connected, accepting connect from any host) ndb_mgm> * When i create database on Node with node id2(Which is running on same serve= r with Management node), it creates without any error. But it's not created= on second data node. If i create database on Node2(Which is running on another server it fails w= ith below error) *mysql> create schema test3; 120424 22:00:20 [Warning] NDB: Could not acquire global schema lock (4009)C= luster Failure Query OK, 1 row affected, 1 warning (0.00 sec) mysql> show warnings; +---------+------+---------------------------------------------------------= ------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------= ------------------------+ | Warning | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock | +---------+------+---------------------------------------------------------= ------------------------+ 1 row in set (0.00 sec) *Database got created on node 2 with error and it's not present on Node1. Please help me out what may be the issue/error. Thanks in advance. When i create database om -- ------------------- Thanks & Regards ------------------- ANIL YADAV *+91-9871047883* LinkedIn:-http://www.linkedin.com/in/anilyadav ---------------------------------------------------- "We judge ourselves by what we feel capable of doing, while others judge us= by what we have already done." ----------------------------------------------------