Bluehost.com Web Hosting $6.95

MySQL 5.0 Cluster Issues

This is a discussion on MySQL 5.0 Cluster Issues within the MySQL Database forums, part of the Database Forums category; So... I'm trying to setup a cluster on Amazon's EC2 using the MySQL 5.0 docs and Alex ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-18-2007
Michael Nguyen
 
Posts: n/a
Default MySQL 5.0 Cluster Issues

So... I'm trying to setup a cluster on Amazon's EC2 using the MySQL 5.0 docs
and Alex Davies' HOWTO (they're pretty much the same). I can't seem to get
the cluster to start up.

ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @216.182.236.43 (Version: 5.0.27, starting, Nodegroup: 0)
id=3 @216.182.236.29 (Version: 5.0.27, starting, Nodegroup: 0)
id=4 @216.182.236.37 (Version: 5.0.27, starting, Nodegroup: 0)

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

[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)

Here's what I have:

MANAGEMENT SERVER

cat /var/lib/mysql-cluster/config.ini
[NDBD DEFAULT]
NoOfReplicas=3

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
HostName=216.182.233.24
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.43
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.29
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.37
DataDir=/var/lib/mysql-cluster

[MYSQLD]
[MYSQLD]
[MYSQLD]

For each node, I have the following in /etc/my.cnf

[MYSQLD]
ndbcluster
ndb-connectstring=216.182.233.24:1186

[MYSQL_CLUSTER]
ndb-connectstring=216.182.233.24:1186

When I check the cluster logs on the nodes, I get the following:

2007-01-18 02:55:55 [ndbd] INFO -- Angel pid: 5598 ndb pid: 5599
2007-01-18 02:55:55 [ndbd] INFO -- NDB Cluster -- DB node 4
2007-01-18 02:55:55 [ndbd] INFO -- Version 5.0.27 --
2007-01-18 02:55:55 [ndbd] INFO -- Configuration fetched at
216.182.233.24 port 1186
2007-01-18 02:55:56 [ndbd] INFO -- Start initiated (version 5.0.27)

The cluster logs on the management server have constantly repeating
messages:

2007-01-18 11:37:23 [MgmSrvr] INFO -- Node 3: Initial start, waiting for
0000000000000014 to connect, nodes [ all: 000000000000001c connected:
0000000000000008 no-wait: 0000000000000000 ]
2007-01-18 11:37:24 [MgmSrvr] INFO -- Node 2: Initial start, waiting for
0000000000000018 to connect, nodes [ all: 000000000000001c connected:
0000000000000004 no-wait: 0000000000000000 ]
2007-01-18 11:37:24 [MgmSrvr] INFO -- Node 4: Initial start, waiting for
000000000000000c to connect, nodes [ all: 000000000000001c connected:
0000000000000010 no-wait: 0000000000000000 ]

I hope that gives enough information. What should I try and where should I
look?


Michael



Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 03:12 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0