Add support for MySQL Cluster

[datacharmer]

This addition should work, in principle, in the same way that group replication does.

The implementation will require:

• identifying which tarballs support this feature out of the box (i.e. no separate downloads);
• pre-define the my.cnf options needed for the installation
• deploy a multiple sandbox (similar to what we do for multi-source replication
• run a configuration script.

defaults.go has already potential support for MySQL Cluster ports handling (commented out).

[dveeden]

Hi,

I assume this is about NDB cluster and not about InnoDB Cluster?

// NdbBasePort                    int    `json:"ndb-base-port"

Note that MySQL Cluster 8.0 DMR is now on the same version scheme as "regular" MySQL.

For NDB a single sandbox would make sense, just with multiple data nodes. (besides the option for multiple sandboxes)

With MySQL::Sandbox I only added ndbcluster to my.sandbox.cnf. This is with 7.x.
Outside of MySQL::Sandbox I have a config.ini and start ndb_mgmd and multiple ndbmtd processs.

[datacharmer]

Thanks for your remarks.
It would help me to see a complete example, including the .ini file and the mgmt commands to start the cluster. That way, I could automate the full cluster generation.

[dveeden]

My ~/ndb/config.ini

[system]
Name=ndbdvetest

[ndbd]
DataDir=/home/dvaneeden/ndb/n2
HostName=localhost
NodeId=2

[ndbd]
DataDir=/home/dvaneeden/ndb/n3
HostName=localhost
NodeId=3

[ndb_mgmd]
DataDir=/home/dvaneeden/ndb/n1
NodeId=1
HostName=localhost

[api]
NodeId=4
HostName=localhost

[api]
NodeId=5
HostName=localhost

[api]
NodeId=6
HostName=localhost

At setup:

mkdir -p ~/ndb/n{1,2,3}
mkdir -p ~/ndb/n1_conf

To start:

ndb_mgmd -f config.ini --configdir=/home/dvaneeden/ndb/n1_conf
ndbmtd --ndb-nodeid=2
ndbmtd --ndb-nodeid=3

And in my my.sandbox.cnf I added ndbcluster.
This way it connects to the management server on localhost on the default port

To support multiple installations the my.sandbox.cnf should use --ndb-connectstring. The same is true for ndbmtd.
For ndb_mgmd the PortNumber option should be set to support multiple clusters on the same host.

[datacharmer]

Implemented with PR #71