[Users] how to refresh REGISTER state when restarting redundant proxy

Andreas Granig andreas.granig at inode.info
Mon Apr 23 14:31:51 CEST 2007


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




More information about the Users mailing list