[MariaDB discuss] Re: MariaDb Master/Replica. How to recover replication when reverting Master to an earlier backup?

On Fri, Jan 10, 2025 at 2:22 PM Simon Avery <Simon.Avery@atass-sports.co.uk> 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 ?