Temporary Tables and Replication

I recently wrote about non-deterministic queries in the replication stream. That’s resolved by using either MIXED or ROW based replication rather than STATEMENT based. Another thing that’s not fully handled by STATEMENT based replication is temporary tables. Imagine the following: Master: CREATE TEMPORARY TABLE rpltmpbreak (i INT); Wait for slave to replicate this statement, then […]