MySql cluster issue

Discussion in 'HOWTO-Related Questions' started by Cristi, Jul 5, 2007.

  1. Cristi

    Cristi New Member

    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?
     
  2. falko

    falko Super Moderator ISPConfig Developer

  3. Cristi

    Cristi New Member

    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.
     

Share This Page