Comment 6 for bug 933232

Revision history for this message
gu lei (gulei-om) wrote : Re: pt-online-schema-change and triggers break replication

Create and alter __tmp table before set sql_log_bin=0.

set sql_log_bin=0

create triggers

insert into __tmp select from ....

rename __tmp table:

create __tmp table before set sql_log_bin=1

set sql_log_bin=1;

drop __tmp table

So slave would not be broken and __tmp table on slave would be dropped.