MySQL replication - Query is replicated even if explicitely ignored

Question

I have a MySQL Master 5.0.77 replicating on a slave 5.5.13. So I'm using STATEMENT based replication.

I have a query 'CREATE TEMPORARY TABLE blah' that is replicated even if it's not in the "replicate-do-table" or "Replicate_Wild_Do_Table" list.

The database name is not explicitly specified in the query, default database used.

In addition to that, I also have "Replicate_Wild_Ignore_Table" set to not replicate this table.

How is it going through ?

Thx

edit: the query contain a UNION, maybe the replication work differently with 5.5 ?

quanta · Answer 1 · 2011-10-26 16:08:53Z

up vote 2 down vote

By default, all temporary tables are replicated. Take a look at this for more details.

answered Oct 26 '11 at 16:08

quanta
16k1631

But there's still the replicate_ignore_tables that should have caught the query. – Bastien974 Oct 26 '11 at 16:54

feedback

1 Answer