I am setting up Replication for cross Database as i have set 2 variables in Slave' s my.cnf as replicate-do-db=database_name and Replicate-wild-do-table=database_name.% ,But i am not able to get cross Database updates from master to slave . Please Help me to resolve the issue.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I addressed something like back on June 14, 2012 : Configured MySQL replication but its not working
The basic problem may be the queries you are using
If you have a query that looks like this
You could be potentially blocking queries of this nature
Queries like this:
should work if you have
To be sure, check out the replication filtering rules to make sure your queries are allowing your current settings to work on the Slave.
According to the replication filtering rules
Perhaps you need to get rid of one of those rules on the Slave and restart mysql on the Slave.