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 Moderator HowtoForge Supporter ISPConfig Developer

    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