MySQL Forums
Forum List  »  NDB clusters

Re: How to successfully ALTER TABLE in running cluster
Posted by: Jonathan Stephens
Date: April 29, 2005 10:16PM

This would probably work. (BTW, this is how an ALTER TABLE statement is supposed to work in any case -- it creates a new table, copies the old into the new, then deletes the old one.) You'll need to use a FLUSH TABLES command afterwards to get all the nodes to "see" the new table and "forget" the old one (assuming that you drop the old table afterwards).

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to successfully ALTER TABLE in running cluster
2031
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.