Bug #43838 Missing step when using ndb_restore to set up circular replication
Submitted: 24 Mar 2009 17:20 Modified: 26 Mar 2009 18:19
Reporter: Andrew Hutchings Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[24 Mar 2009 17:20] Andrew Hutchings
Description:
When setting up circular replication between two clusters, using backup/ndb_restore the binlogs are not generated on the slave cluster until a SHOW TABLES is issued.

How to repeat:
1. Insert data into cluster
2. Backup cluster
3. Restore into new cluster
4. Set up circular replication between the two
5. Insert into the first cluster
6. Look at binlogs on second cluster
7. SHOW TABLES
8. Look at binlogs on second cluster

Suggested fix:
Document the SHOW TABLES workaround.
[26 Mar 2009 18:19] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

(Updated synopsis.)
[1 Apr 2009 13:50] Jonathan Miller
Feature Request -> http://bugs.mysql.com/bug.php?id=44008