• Ritheesh Vedire's avatar
    Bug#16814264: FILTER OUT THE PERFORMANCE_SCHEMA RELAY LOG EVENTS FROM RELAY LOG · bebb3427
    Ritheesh Vedire authored
      Performance schema tables are local to a server and they should not
      be allowed to be executed by the slave from the relay log.
      From 5.6.10, P_S events are not written into the binary log.
      But prior to that, from mysql 5.5 onwards, P_S events are written 
      to the binary log by master.
      The following are problematic scenarios:
          
      1. Master 5.5 -> Slave 5.5
         ========================
        A) RBR: Slave crashes
        B) SBR: P_S statements are replicated.
          
      2.Master 5.5 -> Slave 5.6
        ========================
        A) RBR: SQL thd generates error
        B) SBR : P_S statements are replicated
          
      3. 5.5 binlog executed on a server 5.5 using mysqlbinlog|mysql
         =================================================================
         A) RBR: Server crash  (because of BINLOG'... statement)
         B) SBR: P_S statements are executed
          
      4. 5.5 binlog executed on server 5.6 using mysqlbinlog|mysql
         ================================================================
         A) RBR: SQL error (because of BINLOG'... statement)
         B) SBR: P_S statements are executed.
          
          
        The generalized behaviour should be:
        a) Slave SQL thread should certainly ignore P_S events read from
           the relay log.
        b) mysqlbinlog|mysql should replay the binlog succesfully.
          
    bebb3427
ha_perfschema.cc 11.8 KB