• unknown's avatar
    Robustness feature. · 9a6e7a83
    unknown 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.
    
    
    client/mysqltest.c:
      New command require_os (only "unix" accepted for now).
    innobase/include/trx0sys.h:
      when InnoDB does crash recovery, we now save the binlog coords it prints, into variables for later use.
    innobase/trx/trx0sys.c:
      when InnoDB does crash recovery, we now save the binlog coords it prints, into variables for later use.
    mysql-test/mysql-test-run.sh:
      The tests which check that the binlog is cut at restart, need to not delete those binlogs, of course.
      And not delete replication info, so that we can test that the slave does not receive anything
      wrong from the cut binlog.
    sql/ha_innodb.cc:
      methods to read from InnoDB the binlog coords stored into it
    sql/ha_innodb.h:
      ethods to read from InnoDB the binlog coords stored into it
    sql/log.cc:
      Added my_sync() when we create a binlog (my_sync of the binlog and of the index file);
      this is always done, whether --sync-binlog or not (binlog creation is rare, so no speed
      problem, and I like to have the existence of the binlog always reliably recorded, even if
      later content is not).
      If --crash-binlog-innodb, crash between the binlog write and the InnoDB commit.
      New methods:
      - report_pos_in_innodb() to store the binlog name and position into InnoDB (used only when
      we create a new binlog: at startup and at FLUSH LOGS)
      - cut_spurious_tail() to possibly cut the tail of a binlog based on the info we read
      from InnoDB (does something only if InnoDB has just done a crash recovery).
    sql/mysql_priv.h:
      new option, to crash (use for testing only)
    sql/mysqld.cc:
      New option --innodb-safe-binlog and --crash-binlog-innodb (the latter is for testing, it makes mysqld crash).
      Just after opening the logs and opening the storage engines, cut any wrong statement from the binlog, based
      on info read from InnoDB.
    sql/sql_class.h:
      new methods for MYSQL_LOG.
    9a6e7a83
rpl_crash_binlog_ib_1b.test 1.24 KB