Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Possible Duplicate:
Can't connect to MySQL Cluster Storage (data) nodes

I've deployed a MySQL Cluster with a few nodes, and I want to access the storage nodes directly from another machine using NDBAPI.

When I tried to connect from the same host it worked, but when I try to connect from a different machine I get a socket timeout.

Any clues? There is no strange network setup.

Thanks!

share|improve this question

migrated from stackoverflow.com May 3 '12 at 13:05

This question came from our site for professional and enthusiast programmers.

marked as duplicate by RolandoMySQLDBA, JNK May 27 '12 at 13:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

Couple of things to check...

  1. In your config.ini file, check that you haven't specified the host that is allowed to connect to this ndbapi slot - check the 'hostname' parameter in your config.ini file or run "ndb_mgm -e show". If you leave out the hostname parameter then you can connect the data node from any host
  2. Firewall. Temporarily turn off your firewall and see if that fixes it. If you need to lock down the ports used by the data nodes then set the ServerPort parameter in the [ndbd] sections or the [ndbd default] section of the config.ini file. The firewall also needs to allow port 1186 (by default) for the management node.
  3. You've filled up all of the API slots - run "ndb_mgm -e show" to check. If needed, add extra [mysqld] or [ndbapi] sections to your config.ini file and restart your nodes.
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.