{"id":864,"date":"2007-07-13T16:43:50","date_gmt":"2007-07-13T06:43:50","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/07\/13\/backup-and-recovery-the-book\/"},"modified":"2007-07-13T16:43:50","modified_gmt":"2007-07-13T06:43:50","slug":"backup-and-recovery-the-book","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/07\/13\/backup-and-recovery-the-book\/","title":{"rendered":"Backup and Recovery (the book)"},"content":{"rendered":"

A little while ago now, I did some tech reviewing of a book called Backup & Recovery<\/a>… specifically MySQL related things (and MySQL Cluster). Curtis was kind enough to send me a copy of the book as well – and I’ve been reading the rest of it bits at a time since I got it.<\/p>\n

I’m rather impressed… it gives a good mix of overview and digging deeper on just about every way to back up and recover systems. It also discusses several products that I didn’t know about (and have partly investigated now because of it).<\/p>\n

It also has good sections on process: as in how to decide what to backup, encouraging the use of checklists and all that. Heck… recently when doing a restore I realised I never backed up \/boot (annoying, not catastrophic… as I know my way around).<\/p>\n

I recommend getting a copy of it if you need to back up and restore systems and don’t know everything already.<\/p>\n","protected":false},"excerpt":{"rendered":"

A little while ago now, I did some tech reviewing of a book called Backup & Recovery… specifically MySQL related things (and MySQL Cluster). Curtis was kind enough to send me a copy of the book as well – and … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[14],"tags":[],"class_list":["post-864","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-dW","jetpack-related-posts":[{"id":1153,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/18\/mysql-online-backup-with-encryption-preview-release\/","url_meta":{"origin":864,"position":0},"title":"MySQL Online Backup with Encryption Preview Release","author":"Stewart Smith","date":"2008-07-18","format":false,"excerpt":"Head on over to the OnlineBackup - MySQL Forge Wiki and your able to get a built preview release with Encryption support. I welcome and encourage feedback!OnlineBackup - MySQL Forge Wiki","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1131,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/01\/mysql-encrypted-online-backup-preview-1\/","url_meta":{"origin":864,"position":1},"title":"MySQL Encrypted Online Backup Preview 1","author":"Stewart Smith","date":"2008-07-01","format":false,"excerpt":"I've just pushed to launchpad, a set of patches that implement AES encryption support for MySQL Online Backup. You will need to build --with-ssl to get support for encrypted online backup. Encrypted backup files have no recognisable header - they're just a stream of random bytes. Encryption and compression also\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":710,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/06\/06\/call-for-comments-on-mysql-online-backup-api-jay-pipes\/","url_meta":{"origin":864,"position":2},"title":"Call for Comments on MySQL Online Backup API – Jay Pipes","author":"Stewart Smith","date":"2006-06-06","format":false,"excerpt":"Call for Comments on MySQL Online Backup API - Jay Pipes It's been interesting watching the ideas develop for online, consistent Backup for MySQL. I should expand that... consistent across storage engines. Other RDBMS vendors get it easy - they just have one storage engine to back up. We have\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2406,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/10\/03\/speaking-at-percona-live-london-2011-on-drizzle\/","url_meta":{"origin":864,"position":3},"title":"Speaking at Percona Live London 2011 (on Drizzle!)","author":"Stewart Smith","date":"2011-10-03","format":false,"excerpt":"Both Henrik and myself will be at Percona Live London 2011 in late October speaking on the wonderful Drizzle database server. Other speakers at the conference will be talking about a wide range of topics surrounding the MySQL ecosystem including performance monitoring, backup, search, scaling and data recovery. P.S. I\u2026","rel":"","context":"In "drizzle"","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1145,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/10\/wl4271-encrypted-online-backup-preview-3\/","url_meta":{"origin":864,"position":4},"title":"WL4271 Encrypted Online Backup: Preview 3","author":"Stewart Smith","date":"2008-07-10","format":false,"excerpt":"\u00e2\u20ac\u0153WL4271 Encrypted Online Backup: Preview 3\u00e2\u20ac\u009d branch in Launchpad Now with Windows support. Many thanks to Chuck Bell for helping get the code going on Windows. We can however, all sit around dumbfounded as to how Windows has so little of a POSIX like layer and yet doesn't define ENOTSUP.\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":854,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/27\/run-backup-run\/","url_meta":{"origin":864,"position":5},"title":"Run Backup, Run!","author":"Stewart Smith","date":"2007-06-27","format":false,"excerpt":"Over the past N weeks\/couple of months, we've been making a number of improvements to how backups are done in MySQL Cluster. Once you get to large data sets, you start to really care about how long a backup takes. Traditionally, MySQL Cluster has been in-memory only. The way to\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}