Bug #11375 Unbalanced data for number of nodes not on the form 2 ** n
Submitted: 16 Jun 2005 10:57 Modified: 16 Dec 2005 19:10
Reporter: Mikael Ronström Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version: OS:
Assigned to: Assigned Account CPU Architecture:Any

[16 Jun 2005 10:57] Mikael Ronström
When setting up tables in a 12-node case the data will be unbalanced among the nodes.
Nodegroup 1 and 2 will have 1 unit of data
Nodegroup 3 and 4 will have 2 units of data
Nodegroup 5 and 6 will have 1 unit of data

This is by design on a table basis but on a system basis it should be possible to
control the inbalance.

Thus the first node group of a table should be rolled around by default.
There should be a session variable however specifying whether this should be done or
not so that the user can control his own fate.

How to repeat:
Set up cluster with number of nodegroups != 2 ** n and fill it with data

Suggested fix:
Use c_nextNodeGroup variable already available in DIH and provide interface from
session variable to manipulate it.
[25 Jun 2005 15:55] Jorge del Conde
[25 Jun 2005 15:56] Jorge del Conde
Changed category to MySQL Server Docs.  It previously had MySQL++ Docs.
[11 Aug 2005 16:57] Mike Hillyer
What exactly do we want documented WRT to this?