• Brandon Nesterenko's avatar
    MDEV-27247: Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for START SLAVE UNTIL · 0c1bf5e2
    Brandon Nesterenko authored
    New Feature:
    ============
    This patch extends the START SLAVE UNTIL command with options
    SQL_BEFORE_GTIDS and SQL_AFTER_GTIDS to allow user control of
    whether the replica stops before or after a provided GTID state. Its
    syntax is:
    
    START SLAVE UNTIL (SQL_BEFORE_GTIDS|SQL_AFTER_GTIDS)=”<gtid_list>”
    
    When providing SQL_BEFORE_GTIDS=”<gtid_list>”, for each domain
    specified in the gtid_list, the replica will execute transactions up
    to the GTID found, and immediately stop processing events in that
    domain (without executing the transaction of the specified GTID).
    Once all domains have stopped, the replica will stop. Events
    originating from domains that are not specified in the list are not
    replicated.
    
    START SLAVE UNTIL SQL_AFTER_GTIDS=”<gtid_list>” is an alias to the
    default behavior of START SLAVE UNTIL master_gtid_pos=”<gtid_list>”.
    That is, the replica will only execute transactions originating from
    domain ids provided in the list, and will stop once all transactions
    provided in the UNTIL list have all been executed.
    
    Example:
    =========
    If a primary server has a binary log consisting of the following GTIDs:
    
    0-1-1
    1-1-1
    0-1-2
    1-1-2
    0-1-3
    1-1-3
    
    If a fresh replica (i.e. one with an empty GTID position,
    @@gtid_slave_pos='') is started with SQL_BEFORE_GTIDS, i.e.
    
    START SLAVE UNTIL SQL_BEFORE_GTIDS=”1-1-2”
    
    The resulting gtid_slave_pos of the replica will be “1-1-1”.
    This is because the replica will execute only events from domain 1
    until it sees the transaction with sequence number 2, and
    immediately stop without executing it.
    
    If the replica is started with SQL_AFTER_GTIDS, i.e.
    
    START SLAVE UNTIL SQL_AFTER_GTIDS=”1-1-2”
    
    then the resulting gtid_slave_pos of the replica will be “1-1-2”.
    This is because it will only execute events from domain 1 until it
    has executed the provided GTID.
    
    Reviewed By:
    ============
    Kristian Nielson <knielsen@knielsen-hq.org>
    0c1bf5e2
rpl_rli.cc 83.9 KB