Comments on: A new MySQL backups temperature scale, with showers https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers Blog by Shlomi Noach Fri, 29 Jun 2012 20:19:45 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Sean Hull https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers/comment-page-1#comment-104227 Fri, 29 Jun 2012 20:19:45 +0000 https://shlomi-noach.github.io/blog/?p=4602#comment-104227 Great post Shlomi. I like using analogies, but wouldn’t the perfect backup ie xtrabackup with throttling be a shower with a temperature gauge that always delivered the water the way you like it? LOL

Btw, I wrote a 10 things to remember article about MySQL backups a few weeks back: http://www.iheavy.com/2012/05/03/ten-things-remember-mysql-backups/

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers/comment-page-1#comment-103275 Tue, 26 Jun 2012 16:39:38 +0000 https://shlomi-noach.github.io/blog/?p=4602#comment-103275 @domas,
duely noted on MyDumper. I didn’t know that. My own attempt showed lockdown — apparently wasn’t paying attention.

]]> By: domas https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers/comment-page-1#comment-103237 Tue, 26 Jun 2012 14:31:15 +0000 https://shlomi-noach.github.io/blog/?p=4602#comment-103237 do note, that mydumper releases read lock when it is dumping tables, it uses read lock only to establish multiple consistent snapshots for parallel dump.

also, xtrabackup gets all your family (secondary indexes) into backups, not talking about all other per-page or per-row overhead.

you also get to shower pretty much every internal cavity too, and just washing hands is pain 🙂

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers/comment-page-1#comment-103151 Tue, 26 Jun 2012 09:10:56 +0000 https://shlomi-noach.github.io/blog/?p=4602#comment-103151 😀

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/a-new-mysql-backups-temperature-scale-with-showers/comment-page-1#comment-103127 Tue, 26 Jun 2012 06:41:16 +0000 https://shlomi-noach.github.io/blog/?p=4602#comment-103127 And restore is like taking a bath? (mysqldump without exteded inserts can take ages)

]]>