MySQL Bugs: #53567: Using ndb_restore of 6.3 to restore backups from MySQL Cluster 7.0

Bug #53567	Using ndb_restore of 6.3 to restore backups from MySQL Cluster 7.0
Submitted:	11 May 2010 13:26	Modified:	24 May 2010 21:49
Reporter:	Geert Vanderkelen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S4 (Feature request)
Version:	mysql-5.1-telco-6.3	OS:	Any
Assigned to:	Jonas Oreland	CPU Architecture:	Any
Tags:	Backup, compatibility, restore

Description:
It might be good to have an option for ndb_restore which would allow a backup take from a MySQL Cluster 7.0, to be restorable into 6.3. This is good for, for example, rolling back after a failed upgrade.

ndb_restore would need to skip some schema objects which it doesn't understand. Also, it would only work for data, not meta information. (Meta information is best restored using a dump produced by mysqldump anyway)

How to repeat:
hashmap objects can't be restored using ndb_restore of 6.3.

Suggested fix:
A new option for MySQL Cluster 6.3 ndb_restore, e.g. --skip-unknown-objects

Or maybe a more generic option which accepts a version? We might need it again for backups from 8.0 to 7.0 for example?

Bernd: Please assign poriority

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109017

3204 Jonas Oreland	2010-05-24
      ndb - bug#53567 - have ndb_restore skip unknown dict-object if --skip-table-check, this allows one to restore a 7.0 backup to a 6.3 cluster

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109019

3204 Jonas Oreland	2010-05-24
      ndb - bug#53567 - have ndb_restore skip unknown objects if --skip-unknown-objects is specified, this allows one to restore a 7.0 backup to a 6.3 cluster

DOCS: Added a new switch to ndb_restore, --skip-unknown-objects
which makes ndb_restore skip unknown objects. Typical use for this
when restoring a 7.0 backup onto of a 6.3 cluster.
(in 7.0 we introduced the hashmap's, which are not present/known by 6.3)

pushed to 6.3.34, 7.0.15 and 7.1.4

Documented in the NDB-6.3.34, 7.0.14, and 7.1.5 changelogs, as follows:

      Added the --skip-unknown-objects option for ndb_restore. This 
      option causes ndb_restore to ignore any schema objects which it 
      does not recognize. Currently, this is useful chiefly for restoring 
      native backups made from a cluster running MySQL Cluster NDB 7.0 to 
      a cluster running MySQL Cluster NDB 6.3.

Also updated ndb_restore description and options listings.

Closed.