{"id":17091,"date":"2017-02-01T15:54:08","date_gmt":"2017-02-01T20:54:08","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=17091"},"modified":"2017-02-01T15:54:08","modified_gmt":"2017-02-01T20:54:08","slug":"automatically-test-your-database-backups","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2017\/02\/01\/automatically-test-your-database-backups\/","title":{"rendered":"Automatically Test Your Database Backups"},"content":{"rendered":"<p><a href=\"https:\/\/marco.org\/2017\/02\/01\/db-backup-testing\">Marco Arment<\/a>:<\/p>\n<blockquote cite=\"https:\/\/marco.org\/2017\/02\/01\/db-backup-testing\">\n<p>The solution is to frequently and <em>automatically<\/em> test backups by:<\/p>\n<ol>\n<li>Regularly downloading the latest backup from S3 (or wherever) and performing a full restore onto a clean server.<\/li>\n<li>Testing its validity in a way that a human is sure to notice if it stops working properly.<\/li>\n<\/ol>\n<p>The first part sounds hard, but isn&rsquo;t. For <a href=\"https:\/\/overcast.fm\/\">Overcast<\/a>, I run an inexpensive <a href=\"https:\/\/www.linode.com\/?r=0e105fac1868f5f735279daa027833f8f77b6e91\">Linode<\/a> server devoted to automatically fetching, installing, and testing the latest backup every day and emailing me a report.<\/p>\n<\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Marco Arment: The solution is to frequently and automatically test backups by: Regularly downloading the latest backup from S3 (or wherever) and performing a full restore onto a clean server. Testing its validity in a way that a human is sure to notice if it stops working properly. The first part sounds hard, but isn&rsquo;t. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[146,143,647,96],"class_list":["post-17091","post","type-post","status-publish","format-standard","hentry","category-technology","tag-backup","tag-database","tag-overcast","tag-web"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/17091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=17091"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/17091\/revisions"}],"predecessor-version":[{"id":17092,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/17091\/revisions\/17092"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=17091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=17091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=17091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}