Sample Header Ad - 728x90

Replication - replica falling behind while mysqldump is taken

1 vote
1 answer
51 views
I am pretty inexperienced with MariaDB, especially replication. However, being 'on call duty' I have an issue with this today. it looks like my replica is falling behind while I am taking a mysqldump of the replica. Is this to be expected behavior or is there an issue with my backup command below? mysqldump --defaults-file=$MYCNF -A --events --routines --master-data=2 | gzip -9 -c > ${BKPFILE} It looks like we are catching up after the dump is finished.
Asked by vrms (271 rep)
Mar 29, 2025, 09:06 PM
Last activity: Mar 31, 2025, 07:03 AM