Mysql cluster issues.

Discussion in 'Server Operation' started by elguapo, Oct 29, 2006.

  1. elguapo

    elguapo New Member

    I have setup a mysql cluster on my network. The problem I am having is this, when I use ndb_mgm to show my nodes, I get this error.

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

    When I try to start mysql.server it always says.
    Starting MySQL................................... [FAILED]

    I have searched everywhere I could think of to find a log as to why it has failed, and I havent found anything.

    ndbd connects fine to the manager, but for some reason I just cant get mysql to start.

    Can someone give me a hand with it, it is getting frustrating.

    Here is my my.cnf and my config.ini files.

    my.cnf --
    # enable ndbcluster storage engine, and provide connectstring for
    # management server host (default port is 1186)
    [mysqld]
    ndbcluster
    ndb-connectstring=192.168.10.2


    # provide connectstring for management server host (default port: 1186)
    [ndbd]
    connect-string=192.168.10.2


    # provide connectstring for management server host (default port: 1186)
    [ndb_mgm]
    connect-string=192.168.10.2
    # provide location of cluster configuration file
    [ndb_mgmd]
    config-file=/var/lib/mysql-cluster


    config.ini
    [NDBD DEFAULT]
    NoOfReplicas=3

    [MYSQLD DEFAULT]

    [NDB_MGMD DEFAULT]

    [TCP DEFAULT]

    # Section for the cluster management node
    [NDB_MGMD]
    # IP address of the management node (this system)
    HostName=192.168.10.2

    # Section for the storage nodes
    [NDBD]
    # IP address of the first storage node
    HostName=192.168.10.3
    DataDir= /var/lib/mysql-cluster

    # Section for the storage nodes
    [NDBD]
    # IP address of the second storage node
    HostName=192.168.10.4
    DataDir= /var/lib/mysql-cluster

    # Section for the storage nodes
    [NDBD]
    # IP address of the third storage node
    HostName=192.168.10.5
    DataDir= /var/lib/mysql-cluster

    # one [MYSQLD] per storage node
    [MYSQLD]
    [MYSQLD]
    [MYSQLD]
     
  2. falko

    falko Super Moderator ISPConfig Developer

  3. sysconfig

    sysconfig New Member

Share This Page