{"id":841,"date":"2007-06-13T03:07:32","date_gmt":"2007-06-12T17:07:32","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/06\/13\/backups-dont-suck\/"},"modified":"2007-06-13T03:07:32","modified_gmt":"2007-06-12T17:07:32","slug":"backups-dont-suck","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/13\/backups-dont-suck\/","title":{"rendered":"Backups don&#8217;t suck"},"content":{"rendered":"<p>Today, immediately after lunch, I got IO errors from my laptop hard drive (ironically while attempting a file system dump). Words to the affect of &#8220;oh gosh and bother&#8221; exiting my mouth and the decision was made to go get a new drive.<\/p>\n<p>Well&#8230; one &#8220;shortcut&#8221; to the computer store later, have new HD (will travel).<\/p>\n<p>Backup from previous night, xfsrestore here I come. And a good number of hours later&#8230; about 1.5million files restored.<\/p>\n<p>I do wish file systems had REPEATABLE_READ though&#8230; that would be nice.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, immediately after lunch, I got IO errors from my laptop hard drive (ironically while attempting a file system dump). Words to the affect of &#8220;oh gosh and bother&#8221; exiting my mouth and the decision was made to go get &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2007\/06\/13\/backups-dont-suck\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[5,2,14],"tags":[],"class_list":["post-841","post","type-post","status-publish","format-standard","hentry","category-cool-gadgets","category-life-the-universe-and-everything","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-dz","jetpack-related-posts":[{"id":1229,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/10\/14\/mysql-cluster-ndb-on-win32-progress\/","url_meta":{"origin":841,"position":0},"title":"MySQL Cluster (NDB) on Win32 progress","author":"Stewart Smith","date":"2008-10-14","format":false,"excerpt":"Many things have been happenning in the land of NDB on Win32 as of late. I've fixed about 700 compiler warnings (some of which were real bugs) leaving about 161 to go on Win32 (VS2003). We're getting a few more warnings on Win64 (some of which look merely semantic, while\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1302,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/12\/11\/installing-solaris-express-on-a-t1000\/","url_meta":{"origin":841,"position":1},"title":"Installing Solaris Express on a T1000","author":"Stewart Smith","date":"2008-12-11","format":false,"excerpt":"How? Seriously, how do I do this? Following constraints: T1000 has no local DVD drive. No other Solaris hosts on network. (Note that it takes about 15 seconds to find the Debian install instructions. \"Put this file on tftp server, boot.\")","rel":"","context":"In &quot;sun&quot;","block_context":{"text":"sun","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/sun\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1360,"url":"https:\/\/www.flamingspork.com\/blog\/2012\/05\/28\/zfs-could-have-been-the-future-of-unix-filesystems\/","url_meta":{"origin":841,"position":2},"title":"ZFS: could have been the future of UNIX Filesystems","author":"Stewart Smith","date":"2012-05-28","format":false,"excerpt":"There was a point a few years ago where Sun could have had the next generation UNIX filesystem. It was in Solaris (and people were excited), there was a port to MacOS X (that was quite exciting for people) and there was a couple of ways to run it on\u2026","rel":"","context":"In &quot;linux-kernel&quot;","block_context":{"text":"linux-kernel","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-kernel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":761,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/11\/22\/create-insert-select-drop-benchmark\/","url_meta":{"origin":841,"position":3},"title":"CREATE, INSERT, SELECT, DROP benchmark","author":"Stewart Smith","date":"2006-11-22","format":false,"excerpt":"Inspired by PeterZ's Opening Tables scalability post, I decided to try a little benchmark. This benchmark involved the following: Create 50,000 tables CREATE TABLE t{$i} (i int primary key) Insert one row into each table select * from each table drop each table I wanted to test file system impact\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2380,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/05\/21\/xtrabackup-bazaar-repositories-upgraded-to-2a-format\/","url_meta":{"origin":841,"position":4},"title":"xtrabackup bazaar repositories upgraded to 2a format","author":"Stewart Smith","date":"2011-05-21","format":false,"excerpt":"I have just upgraded the xtrabackup bazaar code repositories to the 2a format. This means that bzr 1.16 is required to access the source code repositories now. If you get an error like the one below when working with a local branch, you'll need to run \"bzr upgrade\" in it\u2026","rel":"","context":"In &quot;percona&quot;","block_context":{"text":"percona","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/percona\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1655,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/06\/09\/drizzle-pluggable-metadatastore-or-no-table-definition-file-on-disk\/","url_meta":{"origin":841,"position":5},"title":"Drizzle pluggable MetadataStore (or: no table definition file on disk)","author":"Stewart Smith","date":"2009-06-09","format":false,"excerpt":"My code is shaping up rather nicely (see https:\/\/code.launchpad.net\/~stewart\/drizzle\/discovery) and I'm planning to submit a merge-request for it later today. I'm about to commit code that implements a MetadataStore for the ARCHIVE engine. This means that for ARCHIVE tables, you only have the .ARZ file on disk. The table definition\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"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\/841","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=841"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/841\/revisions"}],"predecessor-version":[{"id":1329,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/841\/revisions\/1329"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}