sachin 8dcf7bc66b MDEV-9266 Creating index on temporaray table breaks replication ...

Problem:- Create/drop index was logged into binlog.

Goal:- Operation on temporary table should not be binlog when binlog format
is row.

Solution:-
We should add CF_FORCE_ORIGINAL_BINLOG_FORMAT when there is ddl on temp
table.
For optimize, analyze, repair we wont change anything ,Then will
be logged in binlog , But they also dont throw any error if operation fails
Since slave wont be having any temp table , but these operation on tmp
table will be processed without breaking replication.

For rename we need a different logic MDEV-16728 will solve it.

(cherry-pick from 10.0)

2018-07-31 14:59:09 +04:00

317 KiB

Raw Permalink Blame History

View Raw