MySQL Forums :: Replication :: slave replicates databases it should not


Advanced Search

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

Hi,

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


Subject Views Written By Posted
slave replicates databases it should not 1556 Paul Smith 12/30/2011 12:28PM
Re: slave replicates databases it should not 646 Michael Messina 12/30/2011 06:07PM


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.