Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 ?

share|improve this question
add comment

1 Answer

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

share|improve this answer
    
But there's still the replicate_ignore_tables that should have caught the query. –  Bastien974 Oct 26 '11 at 16:54
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.