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

I'm considering using --replicate-do-table on a MySQL slave to only replicate certain tables. When the master is configured to use MIXED mode binary logging, deterministic queries will be written to the binary log using a statement, not the ROW binary data. If this INSERT/UPDATE contains a JOIN on a non-replicated table, however, it could potentially break on the slave. Is there any way around this or am I totally misunderstanding?

share|improve this question

1 Answer 1

I think you understand correctly, a query that references tables that aren't replicated will fail on the slave causing replication to halt. You could create dummy tables on the slave so that the join would succeed but if the results of the query would be affected then the update on the slave would not match the master and the two would diverge.

share|improve this answer

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.