In MySQL Cluster (7.3), is there any way to lock down the [mysqld] section in config.ini to a small subnet, rather than setting it to a single IP Address, or open for any IP Address?

I've searched the documentation and the web, and I can't see anything that says Yes or No specifically.

I tried it on my test cluster (all running on my Win 7 PC), and trying 123.123.123.* didn't work, nor did

It just seems to be a security risk leaving it open like that, but defeats the point of adding 'spare' slots if they have to be pre-allocated to a fixed IP address.

  • As a workaround you can limit access (with firewall rules) to management node. Without being able to connect to the management node SQL node will not be able to join cluster. – Mindaugas Riauba Feb 20 '15 at 10:52
  • that's a good point, I hadn't thought of that. It still seems strange to me though that we are having to pass the security access to an outside system. – IGGt Feb 20 '15 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.