Can MySQL temporary tables be made safe for statement-based replication?

(Baron Schwartz) A while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is open and is then restarted, the temporary table doesn’t exist anymore, and the slave will

Read More - Register for Free Membership