Bug #88948 Maximum number of NDB nodes is not sufficient

• Submitted: 16 Dec 2017 10:58
• Modified: 20 Dec 2017 6:55
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Cluster: plugin
• Severity: S4 (Feature request)
• Version: 7.6.3
• OS: Any
• CPU Architecture: Any

[16 Dec 2017 10:58] Daniël van Eeden

Description:
As far as I understand NDB has these limits:
There can be up to 255 nodes in total.
There can bu up to 48 data nodes.

For the data nodes: using bigger machines instead of going over that limit is what is recommended.

For the total number of nodes of a cluster of 18 data nodes and 2 management nodes:

255 - ( 2 mgmt nodes and 18 data nodes) = 235 nodes left for API/SQL

That looks ok, but with "ndb-cluster-connection-pool=10" 10 'slots' per SQL machine are needed.
Which only leaves us with 23 SQL machines.

Reducing the pool size works, but that might reduce per-SQL node performance.

How to repeat:
See description

Suggested fix:
Raise the maximum number of SQL nodes to at least 1024.

[20 Dec 2017 6:55] MySQL Verification Team

Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh