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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: plugin Severity:S4 (Feature request)
Version:7.6.3 OS:Any
Assigned to: 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