Sample Header Ad - 728x90

How to backup a replica Using mysqldump?

0 votes
1 answer
260 views
From MySQL Documents , and This answer they said: > When using mysqldump, you should stop replication on the replica before starting the dump process to ensure that the dump contains a consistent set of data: Since my DBs are big, I thought to use --single-transaction --quick to take a snapshot of my DBs and continue to receive data from the master. My question is, what will happen if I do not stop the replica and receive new data during backup time? **Note**: I know --single-transaction take a snapshot, But I want to know if my approach has any disadvantages.
Asked by N_Z (248 rep)
Feb 20, 2023, 09:56 AM
Last activity: May 20, 2025, 01:01 PM