MySQL Forums
Forum List  »  Replication

MySQL Master-Replica incremental backups
Posted by: Bob Stoneman
Date: February 04, 2024 06:31PM

I have a client who had me create a Mysql 8.0.35 row-based (not gtid) replication setup. They want the following:

15 minute transaction logs
Nightly incrementals
Weekly fulls

Should I "cp" replica binary logs or use mysqlbinlog (syntax ?) ?

Currently, I am running mysqldump backups every hour on the Replica.

date=$(date +%Y-%m-%d-%H.%M.%S)
/usr/bin/mysql --vertical -e "SHOW REPLICA STATUS" \
| egrep 'Relay_Source_Log_File|Exec_Source_Log_Pos' > /mnt/sql_backups/all-databases_dumpall_02_replica_status_logfile_pos_$(date +%Y-%m-%d-%H.%M.%S).txt
/usr/bin/mysqladmin stop-replica
/usr/bin/mysqldump --all-databases > /mnt/sql_backups/all-databases_dumpall_02_$(date +%Y-%m-%d-%H.%M.%S).sql
/usr/bin/mysqladmin start-replica

Options: ReplyQuote

Written By
MySQL Master-Replica incremental backups
February 04, 2024 06:31PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.