Binary logs has been overwritten in storage after switchover

[catalogoanatom]

MySQL

Binary logs has been overwritten in storage after switchover

After switchover (swap master and replica) binary logs overwritting binlogs in storage

Please provide steps to reproduce

We have master and replica. wal-g binlog-push binlog script works on the master.
So we have base backups and some binary logs set, for ex:

binlog-00001
binlog-00002
binlog-00003
binlog-00004
binlog-00005
binlog-00006

At this time we are doing switchover. New master (old replica) has only one binary log file:

binlog-00001

After first wal-g push it will overwrite binlog-00001 and all old binary logs in storage

How we can resolve this issue, to have continuous chain of binary logs for PITR from base backup?

[ostinru]

Hi @catalogoanatom ! I don't have configured MySQL nearby. But I used to use '%hostname%-bin-00001' file names. This will prevent binlog overrides. It seems that it is enough to set log_bin_basename to empty string.

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_log_bin_basename