Bug #28205 MySQL Cluster not upgrade compatible w.r.t Online Add Column
Submitted: 2 May 2007 16:46 Modified: 5 May 2007 6:30
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Tomas Ulin CPU Architecture:Any

[2 May 2007 16:46] Tomas Ulin 
Description:
MySQL Cluster 5.1 is supposed to be Upgrade Compatible with later versions.

Because of the way Online Add Column is implemented this is not the case.  Online upgrade to later version will not make online add column possible.

The user will have to take down the cluster, restart, and apply backup, to be able to access this feature.

How to repeat:
.

Suggested fix:
Make all ndb tables by default include the needed "varpart reference", such that columns can be added online after upgrade to later version.
[2 May 2007 16:49] Tomas Ulin 
pushed into 5.1.18, telco 6.1.7 and telco 6.2.1

Upgrade compatability with previous version w.r.t this, however only tables created with 5.1.18 (telco 6.1.7, telco 6.2.1) or later may utilize upcoming online add column.
[5 May 2007 6:30] Jon Stephens 
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented change in 5.1.18, 5.1.16-ndb-6.2.1, and 5.1.15-ndb-6.1.17 changelogs.

Documented recommended upgrade procedures in Upgrades/Downgrades section of 5.1 Manual Cluster chapter.