Online Operations with ALTER TABLE in NDB Cluster > c1 INT NOT NULL PRIMARY KEY, > c2 VARCHAR(30) > ) > TABLESPACE ts1 STORAGE DISK > ENGINE NDB; Query OK, 0 rows affected (1.73 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql>  ALTER TABLE t1 > ADD COLUMN c3 INT COLUMN_FORMAT DYNAMIC STORAGE MEMORY, > ALGORITHM=INPLACE; Query OK, 0 rows affected (1.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql>  ALTER TABLE t1 > ADD COLUMN c4 INT COLUMN_FORMAT DYNAMIC, > ALGORITHM=INPLACE; ERROR 1846 (0A000): ALGORITHM=INPLACE is not supported. Reason: Adding column(s) or add/reorganize partition not supported online. Try ALGORITHM=COPY. mysql>  ALTER ONLINE TABLE t1 ADD COLUMN c4 INT STORAGE MEMORY; Query OK, 0 rows affected, 1 warning (1.17 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql>  SHOW WARNINGS\G *************************** 1. row *************************** Level: Warning Code: 1478 Message: DYNAMIC column c4 with STORAGE DISK is not supported, column will become FIXED mysql>  SHOW CREATE TABLE t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE ‘t1‘ ( ‘c1‘ int(11) NOT NULL, ‘c2‘ varchar(30) DEFAULT NULL, ‘c3‘ int(11) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL, ‘c4‘ int(11) /*!50606 STORAGE MEMORY */ DEFAULT NULL, PRIMARY KEY (‘c1‘) ) /*!50606 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.03 sec) Note The  STORAGE  and  COLUMN_FORMAT  keywords are supported only in NDB Cluster; in any other version of MySQL, attempting to use either of these keywords in a CREATE TABLE  or  ALTER TABLE  statement results in an error. It is also possible to use the statement  ALTER TABLE ... REORGANIZE PARTITION, ALGORITHM=INPLACE  with no  partition_names  INTO ( partition_definitions )  option on  NDB tables. This can be used to redistribute NDB Cluster data among new data nodes that have been added to the cluster online. This does  not  perform any defragmentation, which requires an  OPTIMIZE TABLE  or null  ALTER TABLE  statement. For more information, see Section 23.5.7, “Adding NDB Cluster Data Nodes Online” . 4505 If you omit the  COLUMN_FORMAT DYNAMIC  option, the dynamic column format is employed automatically, but a warning is issued, as shown here: This statement fails if the  STORAGE MEMORY  option is omitted: You can add a new in-memory column to this table online as shown here: