top | item 12822233

(no title)

jivid | 9 years ago

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

discuss

order

mathnode|9 years ago

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

jivid|9 years ago

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.