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
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
