I used the tutorial to create a sql cluster, however i can't seem to get to page 5 anymore. More verbose: i use CENTOS 5, installed all from .rpm packages. Finished setting up the rig, did some tests, replication working ok. Later in the day, i tried to do some more testing, but can't seem to get the MySQL API to connect to the management node anymore. I redid the steps in the howto (without the --initial part), however with little success. ndb_mgm -- NDB Cluster -- Management Client -- ndb_mgm> show; Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.100.3 (Version: 5.0.41, starting, Nodegroup: 0) id=3 @192.168.100.4 (Version: 5.0.41, starting, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 (Version: 5.0.41) [mysqld(API)] 2 node(s) id=4 (not connected, accepting connect from any host) id=5 (not connected, accepting connect from any host) Can someone point me to some troubleshooting ideeas?
The problem was that i was stuck in Phase 1 with both my nodes. As i was in a hurry and had played arround with my rig's netwoking, i decided to do a reinstall using the same config.ini and my.cnf on both rigs. ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.100.3 (Version: 5.0.41, Nodegroup: 0, Master) id=3 @192.168.100.4 (Version: 5.0.41, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.100.2 (Version: 5.0.41) [mysqld(API)] 2 node(s) id=4 @192.168.100.4 (Version: 5.0.41) id=5 @192.168.100.3 (Version: 5.0.41) ndb_mgm> all status Node 2: started (Version 5.0.41) Node 3: started (Version 5.0.41) Working like a charm. 10x for the input, anyway.