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.
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.