WL#2496: NDB TableSpaces defined per partition
Status: On-Hold
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;
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.