How to successfully ALTER TABLE in running cluster
Hello,
we have been running a mysql 4.1. cluster over 2 machines successfully for some months now.
We now need to make some table changes (add column ) using the ALTER TABLE statement but since the Cluster Limitations in MySQL 4.1 lists that " It is not possible to make online schema changes such as those accomplished using ALTER TABLE or CREATE INDEX."
Can anybody explain me what steps do i need to take to alter an existing table in a cluster ?
kind regards
Werner Ramaekers
ICT Architect
Subject
Views
Written By
Posted
How to successfully ALTER TABLE in running cluster
2932
April 22, 2005 01:35AM
2000
April 22, 2005 09:43AM
2074
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.