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 ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 |