Forcing Nodegroups
We currently have a configuration of 2 storage nodes, 1 mysql node, 1 mgmt node (each with 2G of memory), and the NoOfReplicas equal to 2 in the config.ini file. The configuration from ndb_mgm shows:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.0.117 (Version: 4.1.10, Nodegroup: 0, Master)
id=2 @192.168.0.118 (Version: 4.1.10, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=4 @192.168.0.120 (Version: 4.1.10)
[mysqld(API)] 1 node(s)
id=3 @192.168.0.119 (Version: 4.1.10)
What appears to be happening when we load test the servers is that 2 copies of the database are being stored across the two storage nodes? During our load tests, it appears that it is storing a majority of the DB (and copies thereof) on just one storage node (id=1 has 1.3G used out of 2G, while id=2 has 0.6G used out of 2G).
Is there anyway to force the two storage nodes into separate nodegroups so that they each store one replica of the DB when NoOfReplicas is set to 2?
Subject
Views
Written By
Posted
Forcing Nodegroups
3381
March 09, 2005 06:34PM
1962
March 11, 2005 08:55AM
2126
March 15, 2005 03:21PM
2072
March 15, 2005 06:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.