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.
[NDBD]
id=2
HostName=10.0.0.2 Â # the IP of the first data node
DataMemory=6G
IndexMemory=512M
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?
ndb_mgmd reads config on startup. So you need to restart the management server first. Then a restart of data nodes (not initial)
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.
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.
Thank you very much. Very informative.
* 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
rich.
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.
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.