I ran into something with mysql cluster today which boggles my mind. On http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-config-params-ndbd.html page, it is documented that if we you change datamemory parameter in the config.ini under mysql-cluster like below, you would have to restart nodes to reread the configuration.
HostName=10.0.0.2 # the IP of the first data node
But when I tried the: 2 restart in the mysql cluster managment console (ndb_mgm), it didn’t re-read the new configuration. DataMemory was initially set to 2G and it continued using that configuration. I even tried: 2 stop, and than logged on the node server and started ndbd manually, but it refused to read the new configuration. It is only when I did ndbd –initial, nodes read in the configuration and were able to use more than 2 gigs of ram.
Did anybody else run into this? Am I reading the documentation on MySQL site incorrectly?