• Raghavendra D Prabhu's avatar
    PXC-391: Avoid Total Order Isolation (TOI) for LOCAL sql admin commands. · 1077eef9
    Raghavendra D Prabhu authored
    The admin commands in question are:
        > OPTIMIZE
        > REPAIR
        > ANALYZE
    
    For LOCAL or NO_WRITE_TO_BINLOG invocations of these commands, ie
    
        OPTIMIZE LOCAL TABLE <t1>
    
    they are not binlogged as expected.
    
    Also, in addition, they are not executed under TOI.
    
    Hence, they are not propagated to other nodes.
    
    The effect is same as that of wsrep_on=0.
    
    Also added tests for this.
    
    A WSREP_DEBUG for wsrep_register_hton has also been added.
    
    The galera_flush_local test has also been updated for verifying that effects
    of  NO_WRITE_TO_BINLOG / LOCAL are equivalent to wsrep_on=0 from wsrep
    perspective.
    
    (cherry picked from commit 5065122f94a8002d4da231528a46f8d9ddbffdc2)
    
    Conflicts:
    	sql/sql_admin.cc
    	sql/sql_reload.cc
    	sql/wsrep_hton.cc
    1077eef9
galera_flush_local.result 4.22 KB