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
Last activity: May 20, 2025, 01:01 PM