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