MySQL Master-Replica incremental backups
I have a client who had me create a Mysql 8.0.35 row-based (not gtid) replication setup. They want the following:
MySQL -
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
Subject
Views
Written By
Posted
MySQL Master-Replica incremental backups
490
February 04, 2024 06:31PM
235
February 28, 2024 01:32AM
Sorry, you can't reply to this topic. It has been closed.
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.