Continuous MySQL backup validation: Restoring backups

Re:Continuous MySQL backup validation: Restoring backups by jivid on Friday October 28, 2016 @10:03PM (#12822233)

We run a single mysqldump with --single-transaction for each database on the server, nothing special.

[ Parent | on HN ]

Re:Continuous MySQL backup validation: Restoring backups by mathnode on Saturday October 29, 2016 @03:48PM (#12825952)

Thanks, how big is a single instance? All out to a single file?

[ Parent | on HN ]

Re:Continuous MySQL backup validation: Restoring backups by jivid on Sunday October 30, 2016 @12:05PM (#12830512)

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.

[ Parent | on HN ]

Re:Continuous MySQL backup validation: Restoring backups by mathnode on Friday November 04, 2016 @06:06AM (#12871424)

Thanks

[ Parent | on HN ]