How To Set Up A Load-Balanced MySQL Cluster => can't connect API node

Discussion in 'HOWTO-Related Questions' started by sanocli, Jun 18, 2008.

  1. sanocli

    sanocli New Member

    Hello guys,

    I have followed this HOWTO : http://www.howtoforge.com/loadbalanced_mysql_cluster_debian. Everything is okay for the management node and Data Node but no SQL/API node is connected. I don't know why I have tried several things but nothing has worked. If someone could tell me what is wrong with my configuration.

    This is my configuration file present in /var/lib/mysql-cluster
    Code:
    [NDBD DEFAULT]
    NoOfReplicas=2
    DataMemory=10MB
    IndexMemory=10MB
    Diskless=1
    
    [MYSQLD DEFAULT]
    
    [NDB_MGMD DEFAULT]
    
    [TCP DEFAULT]
    
    # Managment Server
    
    [NDB_MGMD]
    HostName=127.0.0.1
    
    # Storage Engines
    
    [NDBD]
    HostName=127.0.0.1
    DataDir=/var/lib/mysql-cluster
    
    [NDBD]
    HostName=127.0.0.1
    DataDir=/var/lib/mysql-cluster
    
    [NDBD]
    HostName=127.0.0.1
    DataDir=/var/lib/mysql-cluster
    
    [NDBD]
    HostName=127.0.0.1
    DataDir=/var/lib/mysql-cluster
    
    # MySQL Clients
    # I personally leave this blank to allow rapid changes of the mysql clients;
    # you can enter the hostnames of the above two servers here. I suggest you dont.
    
    [MYSQLD]
    HostName=127.0.0.1
    
    [MYSQLD]
    

    And this my my.cnf present in /etc/
    Code:
    [mysqld]
    ndbcluster
    # IP address of the cluster management node
    ndb-connectstring=127.0.0.1
    
    [mysql_cluster]
    # IP address of the cluster management node
    ndb-connectstring=127.0.0.1
    Thank you for helping in anyway.


    Have a good day ;)
     
  2. falko

    falko Super Moderator ISPConfig Developer

Share This Page