On Fri, Jan 10, 2025 at 2:22 PM Simon Avery <[email protected]> wrote:
> Hello Again, > > Just wanted to say thank you again for this. > > I restored a copy of the replica from the day before, but after some > expected HA_ERR_FOUND_DUPP_KEY errors, it started throwing a bunch of > HA_ERR_KEY_NOT_FOUND and that didn’t work. > > Then I restored another copy from the same minute as the split, and after > a few hundred HA_ERR_FOUND_DUPP_KEY skips, it started catching up. An hour > later, it was 0 seconds behind and has stayed in sync. > Those errors shouldn't have happened. Are you sure you are running the master with synv_binlog=1 and the slave with sync_master_info=1, and both with innodb_flush_log_at_trx_commit=1 ?
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
