On Wed, 2006-05-17 at 08:20 -0500, Patrick Duda wrote:
> When I do a
> /usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/bin/ndb_mgm -e show,
> I see:
> Connected to Management Server at: localhost:1186
> Cluster Configuration
> ---------------------
> [ndbd(NDB)] 2 node(s)
> id=2 @127.0.0.1 (Version: 4.1.18, starting, Nodegroup: 0, Master)
> id=3 (not connected, accepting connect from 141.142.234.28)
>
> [ndb_mgmd(MGM)] 1 node(s)
> id=1 @141.142.234.57 (Version: 4.1.18)
>
> [mysqld(API)] 2 node(s)
> id=4 (not connected, accepting connect from any host)
> id=5 (not connected, accepting connect from any host)
looks like your cluster hasn't started yet.
> Machine A's ndbd log file is:
> 2006-05-17 07:34:42 [ndbd] INFO -- Angel pid: 20008 ndb pid: 20009
> 2006-05-17 07:34:42 [ndbd] INFO -- NDB Cluster -- DB node 2
> 2006-05-17 07:34:42 [ndbd] INFO -- Version 4.1.18 --
> 2006-05-17 07:34:42 [ndbd] INFO -- Configuration fetched at localhost
> port 1186
>
> Machine B's log file is:
> 2006-05-17 07:52:37 [ndbd] INFO -- Angel pid: 20993 ndb pid: 20994
> 2006-05-17 07:52:37 [ndbd] INFO -- NDB Cluster -- DB node 3
> 2006-05-17 07:52:37 [ndbd] INFO -- Version 4.1.18 --
> 2006-05-17 07:52:37 [ndbd] INFO -- Configuration fetched at
> 141.142.234.57 port 1186
>
> From everything I have read these configurations should be right.
>
> Why is machine B's ndbd not connecting to the ndb_mgm?
Probably a firewall in the way. Perhaps you have a firewall on machine
b?
we use more than just port 1186 for communication
> Why are neither of the mysql's connecting?
they won't until the DB nodes decide they're a cluster and finish
starting.
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
