Juha,
Juha Heinanen wrote:
my understanding is that you cannot in 5.0 do alter table on NDBCLUSTER table:
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.
mysql it is not a production quality system, if user needs to hassle with this kind of basic procedure.
See http://dev.mysql.com/tech-resources/articles/mysql-cluster-50.html
This seems to conflict with the statement from the cluster-limitations docs. However, if you do it in single-user-mode, it works. Otherwise you may get errors regarding invalid schema infos on other sql nodes, which then have to be restarted (with the local ndb tables of the sql nodes being deleted) to work again.
Andreas
This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person: to do so could be a breach of confidence. Thank you for your cooperation. Information pursuant to paragraph 14 Austrian Companies Code: UPC Austria GmbH; Registered Office: Wolfganggasse 58-60, 1120 Vienna Company Register Number: FN 189858d at the Commercial Court of Vienna