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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.