5 messages in com.mysql.lists.clusterAlter table in 5.0.45
FromSent OnAttachments
Jonathan Haddad13 Nov 2007 12:06 
Matthew Montgomery13 Nov 2007 17:36 
Jonathan Haddad13 Nov 2007 17:50 
Stewart Smith13 Nov 2007 18:42 
Stewart Smith13 Nov 2007 18:44 
Subject:Alter table in 5.0.45
From:Jonathan Haddad (jo@letsgetnuts.com)
Date:11/13/2007 12:06:43 PM
List:com.mysql.lists.cluster

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 TABLESstatement to force the cluster to pick up the change.)

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-limitations-exclusive-to-cluster.html

However, on the cluster limitations page, it says:

*DDL operations. * DDL operations (such as CREATE TABLE or ALTER TABLE) are not safe from data node failures. If a data node fails while trying to peform one of these, the data dictionary is locked and no further DDL statements can be executed without restarting the cluster.

It's not clear to me whether or not I can alter tables. Can I add columns and indexes once the cluster is being used? Thanks.