#1  
Old 29th October 2006, 23: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
  #2  
Old 30th October 2006, 14:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Did you have a look at this tutorial? http://www.howtoforge.com/loadbalanc...cluster_debian
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 2nd November 2006, 12:46
sysconfig sysconfig is offline
Junior Member
 
Join Date: Nov 2006
Location: (.)
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sysconfig
Default

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

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
problem with load-balanced mysql cluster MvdB HOWTO-Related Questions 4 16th October 2006 11:15
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55
MySQL Cluster linux_traveler Server Operation 4 30th July 2006 00:14
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 10:35.


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