MySQL Cluster: Changing datamemory requires node restart with –initial?

I ran into something with mysql cluster today which boggles my mind.  On 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=   # 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?

7 thoughts on “MySQL Cluster: Changing datamemory requires node restart with –initial?

  1. Monty Taylor

    As an additional note, you need to restart all of the management servers – and they all need to be down at the same time at some point, because ndb_mgmd will get its config from any running management servers.

  2. Brian Moon

    I understand why this has to be, but this kind of thing is why we decided cluster was not ready for us. If you have a nice static predictable environment that will only need to change once a year, cluster is great. It scales awesomely. But we are moving to fast and decided to just do replication which does not scale up as well but will scale out much better and faster with no down time.

  3. mejores juegos de combate

    * Encourages others to explore widely by creating a culture of discovery.

    Try to keep your stash of wood as low as possible
    to minimize the wood losses during attacks. All lottery players dream of that
    big win and wonder what it would be like to become instantly

  4. kobe 11

    I must show some appreciation to you just for bailing me out of this particular dilemma. After surfing around throughout the world wide web and seeing strategies that were not pleasant, I figured my life was gone. Existing minus the strategies to the difficulties you’ve sorted out by way of your write-up is a critical case, and ones that might have in a wrong way damaged my entire career if I had not encountered your web blog. Your actual skills and kindness in touching every aspect was crucial. I’m not sure what I would’ve done if I had not encountered such a thing like this. I’m able to at this time relish my future. Thanks so much for this professional and sensible guide. I will not think twice to propose your web page to anyone who should receive guide about this issue.

  5. safetoto

    As I am looking at your writing, safetoto I regret being unable to do outdoor activities due to Corona 19, and I miss my old daily life. If you also miss the daily life of those days, would you please visit my site once? My site is a site where I post about photos and daily life when I was free.

Leave a Reply

Your email address will not be published. Required fields are marked *