WL#2496: NDB TableSpaces defined per partition

Status: On-Hold   —   Priority: Medium

As part of WL 1354 it is possible to specify Tablespace per partition.
For this to work it is necessary to implement support for this in the
NDB kernel.

To implement this support from SQL level it is necessary to add support
for specifying NODEGROUP as part of creating a TABLESPACE and LOGFILE
GROUP.

Current syntax is:
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
INITIAL_SIZE 1M
UNDO_BUFFER_SIZE 1M
ENGINE = NDB;

CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 1M
ENGINE = NDB;

This would define a LOGFILE GROUP and TABLESPACE that gets defined on
all nodes in all nodegroups. Thus we must use a homegenous cluster.
The new syntax provides support for heterogenous clusters.

New syntax:
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
NODEGROUP 0
INITIAL_SIZE 1M
UNDO_BUFFER_SIZE 1M
ENGINE = NDB;

CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
NODEGROUP 0
USE LOGFILE GROUP lg1
INITIAL_SIZE 1M
ENGINE=NDB;