Bug #43604 | Backup: No native driver for NDB Backup | ||
---|---|---|---|
Submitted: | 12 Mar 2009 16:22 | Modified: | 8 May 2009 11:49 |
Reporter: | Chuck Bell | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S4 (Feature request) |
Version: | mysql-6.0 | OS: | Any (NDB supported OS only) |
Assigned to: | CPU Architecture: | Any | |
Tags: | mysql-6.0.11 |
[12 Mar 2009 16:22]
Chuck Bell
[14 Mar 2009 15:10]
Chuck Bell
Clarification: There is nothing wrong with how backup and/or NDB communication. On the contrary, both systems are working correctly. The issue this bug report is reporting is simply that a backup of NDB should result in a backup that is similar to the consistent snapshot driver. That is, the backup is non-blocking. Mikael Ronstrum has added some comments about how such a backup can take place: The high level view on how online backup with NDB should happen is something like this. 1) Start a NDB online backup 2) In the locking phase when other storage engines are locked for updates, NDB should be locked for commits. One shouldn't enter the locking phase until NDB has reached the point where all data has been copied and only the logging is active. 3) After locking is completed one gathers the NDB online backup files in some way appropriate for online backup. Note: While this is reported as a deficiency, it could rated as either a S3 or S4.
[16 Mar 2009 13:14]
Chuck Bell
Title changed to reflect true issue of the bug: backup cannot backup NDB with a non-blocking (like the consistent snapshot) driver. We need online backup for NDB.
[23 Mar 2009 10:59]
Lars Thalmann
See also BUG#36471
[25 Mar 2009 10:55]
Jonathan Miller
Workaround, use cluster on-line backup
[7 May 2009 7:43]
Lars Thalmann
For NDB to have a non-blocking backup, we will need to write a native driver for it. NDB will not be able to support the consistent snapshot driver. So, this bug report is a feature request for a native driver for NDB.
[7 May 2009 21:37]
Bugs System
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/73616 2807 Hema Sridharan 2009-05-07 WL#4834(Test ndb and backup) New test case ndb_backup.test is included in ndb suite. Note that this test will not satisfy BUG#43604 and BUG#36471 Once these bugs are fixed backup will use consistent snapshot drivers for NDB / NDBCLUSTER storage engine. added: mysql-test/suite/ndb/r/ndb_backup.result mysql-test/suite/ndb/t/ndb_backup.test
[8 May 2009 11:49]
Jørgen Løland
Resetting to 'verified' since the patch above is a commit to WL#4834, not this bug.