LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 05-07-2008, 11:39 AM   #1
coal-fire-ice
Member
 
Registered: Nov 2004
Location: SE England
Distribution: Debian, SUSE, Ubuntu, Slackware
Posts: 147

Rep: Reputation: 15
mysqld node of mysql cluster system not connecting to management node


i have set up a mysql cluster as described in the documentation for mysql-server-5.0

i have the management node on 1 machine, and then 2 more machines which both have mysqld and ndbd set up on them

as far as i can tell, the management server is working fine, and the ndbd portion of the cluster is also working fine, output from:
Quote:
ndb_mgm>show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @*.*.*.230 (Version: 5.0.51, starting, Nodegroup: 0)
id=3 @*.*.*.231 (Version: 5.0.51, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 (Version: 5.0.32)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
my problem is whatever i seem to do, the mysqld nodes will not connect to the management node

i have been careful to start the system in the order described in the manual,
both the ndbd/mysqld machines were set up at the same time and are identical.
both the ndbd/mysqld machines run ubuntu server 8.04 and mysql 5.0.51
both the ndbd/mysqld machines are 64 bit xeon machines with the amd64 version of ubuntu
the management server is debian 4.1, and running mysql 5.0.32 it is a celeron with the x86 version of debian
the config file on both the ndbd/mysqld machines is /etc/mysql/my.cnf and it reads:

Quote:
[mysqld]
ndbcluster
ndb-connectstring=management.domain.tld
[mysql_cluster]
ndb-connectstring=management.domain.tld

the config file on the management server is /etc/mysql/ndb_mgmd.cnf and it reads:

Quote:
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[tcp default]

[ndb_mgmd]
hostname=management.domain.tld
datadir=/var/lib/mysql-cluster

[ndbd]
hostname=db1.domain.tld
datadir=/usr/local/mysql/data

[ndbd]
hostname=db2.domain.tld
datadir=/usr/local/mysql/data

[mysqld]
[mysqld]
to check if i could see the management server from the connecting hosts i did a telnet to port 1186, and then get version command, which returned the correct info

so if anyone has any ideas why the mysqld nodes don't connect i would much appreciate some pointers.
Thanks
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't find local node name in cluster.conf Roboam León López Linux - Enterprise 17 09-14-2012 08:50 AM
Need to SSH into cluster node by machine name !? nuro305 Linux - Networking 3 06-23-2006 10:41 PM
Update/upgrade cluster through one node? jford_oldman Debian 8 11-02-2005 07:09 PM
cant ping a node in a cluster.. dogma Linux - Networking 3 05-21-2003 11:06 PM
how do I SSH into a cluster node? dogma Linux - Newbie 4 05-15-2003 04:31 PM


All times are GMT -5. The time now is 02:19 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration