-
Sujatha Sivakumar authored
SMALLER ON SLAVE FOR 3 NODE TOPOLOGY Bug#21053163: MIXED BASED REPLICATION LOOSES EVENTS WHEN RELAY_LOG_INFO_REPOSITORY=TABLE Problem: ======= 2 level replication M1 -> S1 ->S2 ( S1 is slave of M1; S2 is slave of S1) replicating a non-transactional storage engine table (e.g.MyISAM) when set relay_log_info_repository=TABLE; and binlog rotation occurs in the middle of statement that was translated to multiple rows, then you loose part of that events. When binlog rotation occurs, on S1 not all rows are written to it's binlog, therefore S2 seamlessly looses part of rows that were translated from one statement to several rows. Fix: === The above mentioned bugs got fixed as part of BUG#16418100 fix. Adding additional test cases to improve test coverage.
Sujatha Sivakumar authoredSMALLER ON SLAVE FOR 3 NODE TOPOLOGY Bug#21053163: MIXED BASED REPLICATION LOOSES EVENTS WHEN RELAY_LOG_INFO_REPOSITORY=TABLE Problem: ======= 2 level replication M1 -> S1 ->S2 ( S1 is slave of M1; S2 is slave of S1) replicating a non-transactional storage engine table (e.g.MyISAM) when set relay_log_info_repository=TABLE; and binlog rotation occurs in the middle of statement that was translated to multiple rows, then you loose part of that events. When binlog rotation occurs, on S1 not all rows are written to it's binlog, therefore S2 seamlessly looses part of rows that were translated from one statement to several rows. Fix: === The above mentioned bugs got fixed as part of BUG#16418100 fix. Adding additional test cases to improve test coverage.
Loading