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
• Status: No Feedback
• Category: MySQL Server: Documentation
• Severity: S2 (Serious)
• Assigned to: Assigned Account
• CPU Architecture: Any

[16 Jun 2005 10:57] Mikael Ronström

Description:
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

Changed

[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?