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
You're using 127.0.0.1 everywhere. That's the problem. Compare this to the setup on http://www.howtoforge.com/loadbalanced_mysql_cluster_debian where different IP addresses are used.