• unknown's avatar
    MDEV-5914: Parallel replication deadlock due to InnoDB lock conflicts · b3529691
    unknown authored
    Due to how gap locks work, two transactions could group commit together on the
    master, but get lock conflicts and then deadlock due to different thread
    scheduling order on slave.
    
    For now, remove these deadlocks by running the parallel slave in READ
    COMMITTED mode. And let InnoDB/XtraDB allow statement-based binlogging for the
    parallel slave in READ COMMITTED.
    
    We are also investigating a different solution long-term, which is based on
    relaxing the gap locks only between the transactions running in parallel for
    one slave, but not against possibly external transactions.
    b3529691
plugin_auth.h.pp 12.5 KB