I’m setting up my first mysql cluster, and just wanted some
clarification on a few things.
In the manual, it says:
Online schema changes. It is not possible to
make online schema changes such as those accomplished using ALTER
TABLE or CREATE INDEX, as the NDB Cluster engine does not support
autodiscovery of such changes. (However, you can import or create
a table that uses a different storage engine, and then convert it
to NDB using ALTER TABLE tbl_name ENGINE=NDBCLUSTER. In such a
case, you must issue a FLUSH TABLES statement to force the
cluster to pick up the change.)
MySQL Cluster Exclusive Limitations
However, on another cluster limitations page, it says:
DDL operations. DDL operations (such as CREATE TABLE or ALTER
TABLE) are not safe from data node failures. …
[Read more]