we upgrade to mysql 8 and since then every time we backup the slave server we are having a lag wit the replication.
its was not occurred when we were on version 5.7.
all tables are innodb.
the server are not busy at all with small amount of IO.
Hi @yehudaf1 , welcome to Percona Forum!
Could you please share the command you’re using?
2022-12-17T04:00:02.238295-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --user=root --password=* --no-server-version-check=1 --backup=1 --target-dir=/db_backup/backup_percona/latest/full --kill-long-queries-timeout=60 --kill-long-query-type=select
2022-12-17T21:10:06.946681-00:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --user=root --password=* --no-server-version-check=1 --backup=1 --target-dir=/db_backup/backup_percona/latest/inc_2022-Dec-17-21-10-06 --incremental-basedir=/db_backup/backup_percona/latest/full --kill-long-queries-timeout=60 --kill-long-query-type=select
any idea why it may happing ?
during the backup the replication have delay and there for our reporting application doesn’t have valid data.