Hi Anil,
What do you mean when you say that you're adding the data to a specific data node? When
you add data through your one MySQL Server, it will automatically be populated in both of
the data nodes (for redundancy).
Note that for a fully fault tolerant solution you would want a second MySQL 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]
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 management node and 1
MySQL node. 1 Data node, Management server and MySQL node are 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 Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0, Master)
id=3 @192.168.80.132 (mysql-5.5.20 ndb-7.2.5, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5)
[mysqld(API)] 2 node(s)
id=4 @192.168.80.131 (mysql-5.5.20 ndb-7.2.5)
id=5 (not connected, accepting connect from any host)
ndb_mgm>
*
When i create database on Node with node id2(Which is running on same server 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 with below
error)
*mysql> create schema test3;
120424 22:00:20 [Warning] NDB: Could not acquire global schema lock (4009)Cluster 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."
----------------------------------------------------
