View Single Post
  #1  
Old 30th October 2006, 00:40
elguapo elguapo is offline
Junior Member
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql cluster issues.

I have setup a mysql cluster on my network. The problem I am having is this, when I use ndb_mgm to show my nodes, I get this error.

[mysqld(API)] 3 node(s)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

When I try to start mysql.server it always says.
Starting MySQL................................... [FAILED]

I have searched everywhere I could think of to find a log as to why it has failed, and I havent found anything.

ndbd connects fine to the manager, but for some reason I just cant get mysql to start.

Can someone give me a hand with it, it is getting frustrating.

Here is my my.cnf and my config.ini files.

my.cnf --
# enable ndbcluster storage engine, and provide connectstring for
# management server host (default port is 1186)
[mysqld]
ndbcluster
ndb-connectstring=192.168.10.2


# provide connectstring for management server host (default port: 1186)
[ndbd]
connect-string=192.168.10.2


# provide connectstring for management server host (default port: 1186)
[ndb_mgm]
connect-string=192.168.10.2
# provide location of cluster configuration file
[ndb_mgmd]
config-file=/var/lib/mysql-cluster


config.ini
[NDBD DEFAULT]
NoOfReplicas=3

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
HostName=192.168.10.2

# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=192.168.10.3
DataDir= /var/lib/mysql-cluster

# Section for the storage nodes
[NDBD]
# IP address of the second storage node
HostName=192.168.10.4
DataDir= /var/lib/mysql-cluster

# Section for the storage nodes
[NDBD]
# IP address of the third storage node
HostName=192.168.10.5
DataDir= /var/lib/mysql-cluster

# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]
[MYSQLD]
Reply With Quote
Sponsored Links