• guilhem@mysql.com's avatar
    Robustness feature. · f5d64244
    guilhem@mysql.com authored
    Won't be pushed as is - separate email sent for internal review.
    WL#1717 "binlog-innodb consistency".
    Now when mysqld starts, if InnoDB does a crash recovery, we use the binlog name
    and position retrieved from InnoDB (corresponding to the last transaction
    successfully committed by InnoDB) to cut any rolled back transaction from
    the binary log. This is triggered by the --innodb-safe-binlog option.
    Provided you configure mysqld to fsync() InnoDB at every commit (using
    flush_log_at_trx_commit) and to fsync() the binlog at every write
    (using --sync-binlog=1), this behaviour guarantees that a master always has
    consistency between binlog and InnoDB, whenever the crash happens.
    6 tests to verify that it works.
    f5d64244
rpl_crash_binlog_ib_1b.result 308 Bytes