Mysql ignoring query to other database
-replicate-ignore-db applies only to the default database (determined by the USE statement). Because the database was specified explicitly in the statement, the statement has not been replicated.
My advice is to change the context with a USE instead of explicitly specify the database in the statement.
Max
EDIT (for questions)
1.
Ok, got it but then what should be the my.cnf values if I want to log all databases on the master but selectively replicate on slave (like ignoring test and replicating ads)?
Note that your syntax is correct, all statements will be written on binary log (master) and the slave will ignore the mysql and test databases BUT YOU SHOULD EXIT THE CONTEXT mysql and test before run queries on other databases.
The context is : REPLICATED
USE ads; INSERT INTO ads.users ( id, username ) VALUES ( 19, 'tyy' );
The context is test: IGNORED
USE test; INSERT INTO ads.users ( id, username ) VALUES ( 19, 'tyy' );
The context is toto: REPLICATED because of your replicate-wild-do-table and toto is not ignored by a replicate-ignore-db
USE toto; INSERT INTO ads.users ( id, username ) VALUES ( 19, 'tyy' );
2.
Looks like "replicate-wild-do-table" means "replicate only this db and ignore everything else".
replicate-do-table=ads will replicate statements on ads database (your context should be ads, ) and ignore the statements on other databases:
The context is test : IGNORED
replicate-wild-do-table=ads will replicate statements on ads database even if your are in an other context (test for instance), and ignore the statements on other databases.