HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   Mysql cluster issues. (http://www.howtoforge.com/forums/showthread.php?t=7780)

elguapo 29th October 2006 23:40

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]

falko 30th October 2006 14:30

Did you have a look at this tutorial? http://www.howtoforge.com/loadbalanc...cluster_debian

sysconfig 2nd November 2006 12:46

You could also check the guide at: http://forums.linuxwebadmin.info/ind...opic,90.0.html


All times are GMT +2. The time now is 04:13.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.