MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: How to successfully ALTER TABLE in running cluster
Posted by: Michael Douglass
Date: April 22, 2005 09:43AM

One way (and this may not be optimal, others can smack me around later) would be to create a new table with a select from your old table. Then drop the old and rename the new.

This, of couse, means that you'd need to shut down your application while this is taking place if there are inserts going on.

MikeDoug

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to successfully ALTER TABLE in running cluster
2912
Werner Ramaekers
April 22, 2005 01:35AM
Re: How to successfully ALTER TABLE in running cluster
1990
Michael Douglass
April 22, 2005 09:43AM
Re: How to successfully ALTER TABLE in running cluster
2064
Jonathan Stephens
April 29, 2005 10:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.