RE: Cannot start data node

[Jeff Sturm]

The [ndb default] section belongs in your config.ini, not here.  Does it
help if you remove it?

My hunch was that ndbd isn't finding your ndb-connectstring setting, so
defaults to "localhost".


-----Original Message-----
From: Sowash, Paul A. (LARC-B702)[NCI INFORMATION SYSTEMS]
[mailto:Paul.A.Sowash@stripped] 
Sent: Friday, February 29, 2008 3:23 PM
To: Jeff Sturm; cluster@stripped
Subject: RE: Cannot start data node

Here is the my.cnf file for the data node:

[ndb default]
NoOfReplicas=2

[mysqld]
ndbcluster
ndb-connectstring=srvr1.lvl1.lvl2.lvl3

[mysql_cluster]
ndb-connectstring=srvr1.lvl1.lvl2.lvl3

Paul

-----Original Message-----
From: Jeff Sturm [mailto:jeff.sturm@stripped]
Sent: Friday, February 29, 2008 2:13 PM
To: Sowash, Paul A. (LARC-B702)[NCI INFORMATION SYSTEMS];
cluster@stripped
Subject: RE: Cannot start data node

What does your my.cnf say on the data node?  Do you have something like:

[MYSQL_CLUSTER]
# Locations of management servers.
ndb-connectstring=mgm01,mgm02

-----Original Message-----
From: Sowash, Paul A. (LARC-B702)[NCI INFORMATION SYSTEMS]
[mailto:Paul.A.Sowash@stripped]
Sent: Friday, February 29, 2008 1:36 PM
To: cluster@stripped
Subject: Cannot start data node

I am trying to set up a MySQL 5.1 cluster on Solaris 10.  I have created
the config.ini file and successfully started the Management node.  When
I try to start the first data node, it fails with the following error:

 

 Unable to connect with connect string: nodeid=0,localhost:1186 

 

Any help will be appreciated.

 

 

Here is the config.ini (names changed to protect the guilty)

 

# file "config.ini"  MySQL Cluster Configuration file

# This file is only needed on the cluster management node

 

[ndbd default]

NoOfReplicas=1

DataMemory=80M

IndexMemory=18M

DataDir=/usr/local/mysql/data

 

# Management node options

[ndb_mgmd]

id=1

HostName=srvr1.lvl1.lvl2.lvl3

DataDir=/usr/local/mysql/data

 

# Data node 1 options

[ndbd]

id=2

HostName=srvr2.lvl1.lvl2.lvl3

DataDir=/usr/local/mysql/data

 

# Data node 2 options

[ndbd]

id=3

HostName=srvr3.lvl1.lvl2.lvl3

DataDir=/usr/local/mysql/data

 

# SQL node options

[mysqld]

id=4

HostName=srvr4.lvl1.lvl2.lvl3

 

Here is the my.cnf file for the data node:

 

[ndb default]

NoOfReplicas=2

 

[mysqld]

ndbcluster

ndb-connectstring=srvr1.lvl1.lvl2.lvl3

 

[mysql_cluster]

ndb-connectstring=srvr1.lvl1.lvl2.lvl3

 

 

Paul Sowash

LaRC - ConITs Contract

Dabase Administrator 

[phone]