MySQL Forums
Forum List  »  NDB clusters

Data node won't start
Posted by: Cristian Riaño Martinez
Date: April 14, 2015 10:45AM

Hello!

I'm trying to configure a MySQL Cluster on 4 machines, all runing Debian.

MySQL Cluster Environment:

MGM - 192.168.1.10
NDB1 - 192.168.1.30
NDB2 - 192.168.1.40
MYSQLD - 192.168.1.20

I installed all from the Binary Relases for Generic-Linux

1. I started the MGM node: ndb-mgmd -f /var/lib/mysql-cluster/config.ini
The config.ini file:

[ndbd default]

NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[tcp default]

portnumber=2202

[ndb_mgmd]

id = 1
hostname = 192.168.1.10
datadir=/var/lib/mysql-cluster

[ndbd]

id = 3
hostname = 192.168.1.30
datadir = /usr/local/mysql/data

[ndbd]

id = 4
hostname = 192.168.1.40
datadir = /usr/local/mysql/data

[mysqld]

id = 2
hostname=192.168.1.20

2. Now I start the data nodes with: ndbd
And wait until the node start

3. Check on MGM node with: ndb_mgm

ndb_mbm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 nodes
id=3 @192.168.1.30 (mysql-5.6.23 ndb-7.4.5, Nodegroup: 0, *)
id=4 (not connected, accepting connect from 192.168.1.40)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.10 (mysql-5.6.23 ndb-7.4.5)

[mysqld(API)] 1 node(s)
id=5 (not connected, accepting connect from 192.168.1.20)

4. And I try to start MySQL server on the Data Node already started (id=3)

shell> /etc/init.d/mysql start
Starting MySQL ....(...) The server quit without updating PID file (/usr/local/mysql/data/NDB1.pid)
[FAIL...failed!

The my.cnf file has:

[mysqld]

ndbcluster
ndb-connectstring = 192.168.1.10

[mysql_cluster]

ndb-connectstring = 192.168.1.10



The MySQL server is installed correctly because if do a default my.cnf file (without the cluster lines) the server starts.
It happens the same with the other data node.

What should I do? Is there something wrong? I have searched a lot in the Inernet and in your forums but I couldn't find the solution

Thanks you very much,

Cristian

Options: ReplyQuote


Subject
Views
Written By
Posted
Data node won't start
2414
April 14, 2015 10:45AM
708
May 11, 2015 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.