tag:blogger.com,1999:blog-19281624.post2397942810055689393..comments2023-11-29T09:00:11.662+00:00Comments on Johan Andersson's Cluster and HA Blog: A great config.iniJohan Anderssonhttp://www.blogger.com/profile/09202425156709885026noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-19281624.post-85409620841674721292017-05-30T10:06:15.846+01:002017-05-30T10:06:15.846+01:00Hi,
You need to restart the management server also...Hi,<br />You need to restart the management server also:<br /><br />1) stop the management server<br />2) start the management server, but add the --reload option<br />Then restart each data node one by one.<br /><br />BR<br />johanJohan Anderssonhttps://www.blogger.com/profile/09202425156709885026noreply@blogger.comtag:blogger.com,1999:blog-19281624.post-61895162314399208902017-05-30T05:26:43.243+01:002017-05-30T05:26:43.243+01:00Hi,
I have managed to setup a Cluster with 1 Mana...Hi,<br /><br />I have managed to setup a Cluster with 1 Management. 2 Data Nodes and 2 mySQL Nodes. It worked. However I ran into problem with table full and I have edited config.ini file as below to increase parameters and restarted all, but non of the table-related things affacted. For example MaxNoOfOrderedIndexes=10000 but at Data Node after restarted even with --initial, command ndb_config -q MaxNoOfOrderedIndexes still show "128 128"<br /><br />Mine: Nodes 128G RAM/each. mySQL 64G RAM/each same for Management node. <br /><br />Can you hepl please. Thanks.<br />---------------------------<br /><br />[ndbd default]<br />NoOfReplicas=2<br />MaxNoOfTables=10000<br />MaxNoOfAttributes=24756<br />MaxNoOfConcurrentOperations=10000<br /># MaxNoOfLocalOperations=2400000000<br /># MaxNoOfConcurrentTransactions=2000000000<br />MaxNoOfOrderedIndexes=10000<br />MaxNoOfUniqueHashIndexes=10000<br /><br />DataMemory=96000M<br /># Memory to allocate for index storage<br />IndexMemory=10240M<br /># Lock table in memory to increase speed<br />LockPagesInMainMemory=1<br /># Use O_DIRECT write<br />ODirect=1<br />FragmentLogFileSize=256M<br /># 6*DataMemory/4/FragmentLogFileSize<br />NoOfFragmentLogFiles=560<br />RedoBuffer=32M<br /><br />#Checkpointing...<br />Diskcheckpointspeed=10M<br />Diskcheckpointspeedinrestart=100M<br />TimeBetweenGlobalCheckpoints=1000<br />#the default value for TimeBetweenLocalCheckpoints is very good<br />TimeBetweenLocalCheckpoints=20Nguyenhttps://www.blogger.com/profile/07171645934574890931noreply@blogger.com