From: Date: November 13 2007 9:07pm
Subject: Alter table in 5.0.45
List-Archive: http://lists.mysql.com/cluster/5457
Message-Id: <12d754400711131207j38dd1cd6s231bd191f1abfcfc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_7696_17449235.1194984426200"

------=_Part_7696_17449235.1194984426200
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.
-- 
Jon Haddad
jon@stripped
Letsgetnuts.com

------=_Part_7696_17449235.1194984426200--