undefined | Better HN

0 pointsmathnode9y ago0 comments

Is the FB branch version of mysqldump still single threaded? How do you cope with that?

I currently "fake it", using "START TRANSACTION WITH CONSISTENT SNAPSHOT", with multiple mysqldump processes running, where I can't get mydumper deployed.

0 comments

3 comments · 1 top-level

jivid9y ago· 2 in thread

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

mathnodeOP9y ago

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

jivid9y 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.

1 more reply

j / k navigate · click thread line to collapse