Comment on Continuous MySQL backup validation: Restoring backupsparentComments−jividOP9yWe run a single mysqldump with --single-transaction for each database on the server, nothing special.−mathnode9yThanks, how big is a single instance? All out to a single file?−jividOP9yInstance size varies a lot because we've got a lot of different MySQL workloads, some with very different configurations.Remember we're backing up each database separately though, not the entire MySQL instance at once. Each database's backup is in a separate file.−mathnode9yThanks
Comments
We run a single mysqldump with --single-transaction for each database on the server, nothing special.
Thanks, how big is a single instance? All out to a single file?
Instance size varies a lot because we've got a lot of different MySQL workloads, some with very different configurations.
Remember we're backing up each database separately though, not the entire MySQL instance at once. Each database's backup is in a separate file.
Thanks