Problems with MySQL Cluster (Help)

Discussion in 'Server Operation' started by longvnit, Dec 8, 2009.

  1. longvnit

    longvnit New Member

    Hi ,
    I am tring to install one MySQL Cluster ,
    But i have some problems, :(

    Network topologies includes :
    a . 01 Server cluster management IP : 192.168.1.5
    b . 03 Server Cluster Node : IP 192.168.1.2 -> 192.168.1.4

    Code:
    File /usr/local/mysql/var/mysql-cluster/config.ini
    Code:
    [NDBD DEFAULT]
    NoOfReplicas=3
    DataMemory=80M    # How much memory to allocate for data storage
    IndexMemory=18M   # How much memory to allocate for index storage
    # For DataMemory and IndexMemory, we have used the
    # default values. Since the .world. database takes up
    # only about 500KB, this should be more than enough for
    # this example Cluster setup.
    [MYSQLD DEFAULT]
    [NDB_MGMD DEFAULT]
    [TCP DEFAULT]
    # Section for the cluster management node
    [NDB_MGMD]
    NodeId = 1
    # IP address of the management node (this system)
    HostName=192.168.1.5
    # Section for the storage nodes
    [NDBD]
    NodeId = 2
    # IP address of the first storage node
    HostName=192.168.1.3
    DataDir=/usr/local/mysql/var/mysql-cluster
    BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
    DataMemory=100M
    [NDBD]
    NodeId = 3
    # IP address of the second storage node
    HostName=192.168.1.4
    DataDir=/usr/local/mysql/var/mysql-cluster
    BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
    DataMemory=100M
     
    [NDBD]
    NodeId = 4
    # IP address of the second storage node
    HostName=192.168.1.2
    DataDir=/usr/local/mysql/var/mysql-cluster
    BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
    DataMemory=100M
     
     
     
    # one [MYSQLD] per storage node
    [MYSQLD]
    NodeId = 5
    [MYSQLD]
    NodeId = 6
    [MYSQLD]
    NodeId = 7
    
    Code:
    File /etc/my.cnf
    Code:
    [client]
    socket=/tmp/mysql.sock
    [mysqld]
    ndbcluster
    ndb-connectstring=192.168.1.5
    default-storage-engine=NDBCLUSTER
    [mysql_cluster]
    ndb-connectstring=192.168.1.5
    
    I have some problems bellow :

    1. not connected, accepting connect from any hosts
    I don't know why that ? :(

    2. I run ndbd on three servers then only server 192.168.1.3 have connect into server Cluster Management , although three server is same.
    Code:
    [ndbd(NDB)]     3 node(s)
    id=2    @192.168.1.3  (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
    id=3 (not connected, accepting connect from 192.168.1.4)
    id=4 (not connected, accepting connect from 192.168.1.2)
     
    [ndb_mgmd(MGM)] 1 node(s)
    id=1    @192.168.1.5  (mysql-5.1.39 ndb-7.0.9)
     
    [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)
    Server 192.168.5.2 & .5.4 can't connect to server cluster management 192.168.1.5

    When i run command : ndbd on server 192.168.1.2 or .4 then server cluster management show :

    Node 4: Forced node shutdown completed. Occured during startphase 0. Caused by error 2805: 'Illegal file system path(Configuration error). Permanent error, external action needed'.

    Please help me slove these problems.
    Thanks so much.
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Is that a typo? Do you mean 192.168.1.2 and 192.168.1.4?
     
  3. longvnit

    longvnit New Member


    oh yes, i fixed my problems ,
    Because i removed /usr/local/mysql/var/mysql-cluster/backup folder,so when Node Server load config from Cluster management server which check does not exist this folder, therefore show error Illegal file system path(Configuration error).

    System show good
    Code:

    Cluster Configuration
    ---------------------
    [ndbd(NDB)] 3 node(s)
    id=2 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
    id=3 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)
    id=4 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

    [ndb_mgmd(MGM)] 1 node(s)
    id=1 @192.168.1.5 (mysql-5.1.39 ndb-7.0.9)

    [mysqld(API)] 5 node(s)
    id=5 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9)
    id=6 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9)
    id=7 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9)

    Thanks for helping me .
     

Share This Page