MySQL Forums
Forum List  »  Replication

slave replicates databases it should not
Posted by: Paul Smith
Date: December 30, 2011 12:28PM


I have 2 masters and a bunch of slaves. The salves only replicate one of the databases with 'replicate-do-db' in their configs. For ages I ' use database' to change between databases when scripts are making queries, but decided use database.table format for a few queries. Replication to the slaves stopped. To my surprise, mysql was complaining a table didn't exist and it was trying to replicate a query not even destined for a database it held.

Is this a bug?

mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1

Options: ReplyQuote

Written By
slave replicates databases it should not
December 30, 2011 12:28PM

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.