{"id":6276,"date":"2010-11-17T08:02:10","date_gmt":"2010-11-17T08:02:10","guid":{"rendered":"http:\/\/www.clearbooks.co.uk\/?p=6276"},"modified":"2012-06-28T09:07:33","modified_gmt":"2012-06-28T09:07:33","slug":"steps-to-redundancy-3-snapshots-and-backups","status":"publish","type":"post","link":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/","title":{"rendered":"Steps to redundancy &#8211; 3. SQL backup dumps"},"content":{"rendered":"<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-6429\" style=\"margin: 0 24px 8px 0\" src=\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\" alt=\"Backup Snapshot Logo Icon\" width=\"118\" height=\"65\" \/>We take backups of our Clear Books database and other site files hosted by CatN on a new schedule.<\/p>\n<p style=\"text-align: justify\">All of our backups are stored on <a href=\"http:\/\/aws.amazon.com\/s3\/\" target=\"_new\">Amazon S3<\/a>. We use the EC2 Slave to perform all of our backups to Amazon S3 storage. Using Amazon S3 provides redundancy so that in the case of our local site being damaged we can still recover data from an off site, cloud based storage service.<\/p>\n<p><!--more--><\/p>\n<h3 style=\"margin-top: 40px\">Backups<\/h3>\n<p style=\"text-align: justify\">For Clear Books, a\u00a0backup is an individual customer database dump that is exported (mysqldump), compressed (bz2), encrypted (gpg) before being copied to another location (S3). We take these backups daily, and store each one for 7 days. We also store backups from the 1st of the month for 3 months. This gives us a historic view of individual customer databases.<\/p>\n<h3 style=\"margin-top: 40px\">Schedule<\/h3>\n<p style=\"text-align: justify\">The backup schedule for ClearBooks data is as follows:<\/p>\n<ul style=\"margin-bottom: 30px\">\n<li>Every Clear Books database is dumped on a daily basis.<\/li>\n<li>Snapshots of the entire Clear Books filesystem daily.<\/li>\n<li><a href=\"http:\/\/www.clearbooks.co.uk\/?p=6310\">User generated backups<\/a> as often as required.<\/li>\n<\/ul>\n<p style=\"margin: 30px 0 100px 0\">\n<span style=\"float: left\"><a href=\"http:\/\/www.clearbooks.co.uk\/?p=6231\">Previous post: MySQL replication<\/a><\/span><span style=\"float: right\"><a href=\"http:\/\/www.clearbooks.co.uk\/?p=6310\">Next post: Customer generated backups<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We take backups of our Clear Books database and other site files hosted by CatN on a new schedule. All of our backups are stored on Amazon S3. We use the EC2 Slave to perform all of our backups to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-6276","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Steps to redundancy - 3. SQL backup dumps | Clear Books<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to redundancy - 3. SQL backup dumps | Clear Books\" \/>\n<meta property=\"og:description\" content=\"We take backups of our Clear Books database and other site files hosted by CatN on a new schedule. All of our backups are stored on Amazon S3. We use the EC2 Slave to perform all of our backups to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"Clear Books\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/clearbooks\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-17T08:02:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-06-28T09:07:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\" \/>\n<meta name=\"author\" content=\"Tim Fouracre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@timfouracre\" \/>\n<meta name=\"twitter:site\" content=\"@ClearBooks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim Fouracre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\"},\"author\":{\"name\":\"Tim Fouracre\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/bbee69f33d20633f23e4570772def494\"},\"headline\":\"Steps to redundancy &#8211; 3. SQL backup dumps\",\"datePublished\":\"2010-11-17T08:02:10+00:00\",\"dateModified\":\"2012-06-28T09:07:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\"},\"wordCount\":183,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\",\"name\":\"Steps to redundancy - 3. SQL backup dumps | Clear Books\",\"isPartOf\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\",\"datePublished\":\"2010-11-17T08:02:10+00:00\",\"dateModified\":\"2012-06-28T09:07:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage\",\"url\":\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\",\"contentUrl\":\"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.clearbooks.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Steps to redundancy &#8211; 3. SQL backup dumps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/\",\"name\":\"Clear Books\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.clearbooks.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\",\"name\":\"Clear Books\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png\",\"contentUrl\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png\",\"width\":400,\"height\":400,\"caption\":\"Clear Books\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/clearbooks\/\",\"https:\/\/x.com\/ClearBooks\",\"https:\/\/www.linkedin.com\/company\/clear-books\",\"https:\/\/www.youtube.com\/user\/ClearBooksVideos\",\"https:\/\/en.wikipedia.org\/wiki\/Clear_Books\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/bbee69f33d20633f23e4570772def494\",\"name\":\"Tim Fouracre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0ed40e153a36d6d33c75141cf20ed2b39337965852dc0a40acea7e4a64962f4b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0ed40e153a36d6d33c75141cf20ed2b39337965852dc0a40acea7e4a64962f4b?s=96&d=mm&r=g\",\"caption\":\"Tim Fouracre\"},\"description\":\"Tim founded Clear Books in 2008. Like many small business owners he worked from home for 15 months to get his startup off the ground. Today Tim enjoys helping Clear Books, its customers and its growing team innovate and achieve. Tim did his GCE O Levels in Ghana.\",\"sameAs\":[\"http:\/\/www.clearbooks.co.uk\",\"http:\/\/uk.linkedin.com\/in\/timfouracre\",\"https:\/\/x.com\/timfouracre\"],\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/author\/tim\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to redundancy - 3. SQL backup dumps | Clear Books","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/","og_locale":"en_GB","og_type":"article","og_title":"Steps to redundancy - 3. SQL backup dumps | Clear Books","og_description":"We take backups of our Clear Books database and other site files hosted by CatN on a new schedule. All of our backups are stored on Amazon S3. We use the EC2 Slave to perform all of our backups to [&hellip;]","og_url":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/","og_site_name":"Clear Books","article_publisher":"https:\/\/www.facebook.com\/clearbooks\/","article_published_time":"2010-11-17T08:02:10+00:00","article_modified_time":"2012-06-28T09:07:33+00:00","og_image":[{"url":"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png","type":"","width":"","height":""}],"author":"Tim Fouracre","twitter_card":"summary_large_image","twitter_creator":"@timfouracre","twitter_site":"@ClearBooks","twitter_misc":{"Written by":"Tim Fouracre","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#article","isPartOf":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/"},"author":{"name":"Tim Fouracre","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/bbee69f33d20633f23e4570772def494"},"headline":"Steps to redundancy &#8211; 3. SQL backup dumps","datePublished":"2010-11-17T08:02:10+00:00","dateModified":"2012-06-28T09:07:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/"},"wordCount":183,"commentCount":0,"publisher":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage"},"thumbnailUrl":"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png","inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/","url":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/","name":"Steps to redundancy - 3. SQL backup dumps | Clear Books","isPartOf":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage"},"thumbnailUrl":"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png","datePublished":"2010-11-17T08:02:10+00:00","dateModified":"2012-06-28T09:07:33+00:00","breadcrumb":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#primaryimage","url":"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png","contentUrl":"http:\/\/clearbooks.co.uk\/wp-content\/uploads\/2010\/11\/backup-snapshot-image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.clearbooks.co.uk\/blog\/steps-to-redundancy-3-snapshots-and-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.clearbooks.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Steps to redundancy &#8211; 3. SQL backup dumps"}]},{"@type":"WebSite","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#website","url":"https:\/\/www.clearbooks.co.uk\/blog\/","name":"Clear Books","description":"","publisher":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.clearbooks.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization","name":"Clear Books","url":"https:\/\/www.clearbooks.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png","contentUrl":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png","width":400,"height":400,"caption":"Clear Books"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/clearbooks\/","https:\/\/x.com\/ClearBooks","https:\/\/www.linkedin.com\/company\/clear-books","https:\/\/www.youtube.com\/user\/ClearBooksVideos","https:\/\/en.wikipedia.org\/wiki\/Clear_Books"]},{"@type":"Person","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/bbee69f33d20633f23e4570772def494","name":"Tim Fouracre","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0ed40e153a36d6d33c75141cf20ed2b39337965852dc0a40acea7e4a64962f4b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0ed40e153a36d6d33c75141cf20ed2b39337965852dc0a40acea7e4a64962f4b?s=96&d=mm&r=g","caption":"Tim Fouracre"},"description":"Tim founded Clear Books in 2008. Like many small business owners he worked from home for 15 months to get his startup off the ground. Today Tim enjoys helping Clear Books, its customers and its growing team innovate and achieve. Tim did his GCE O Levels in Ghana.","sameAs":["http:\/\/www.clearbooks.co.uk","http:\/\/uk.linkedin.com\/in\/timfouracre","https:\/\/x.com\/timfouracre"],"url":"https:\/\/www.clearbooks.co.uk\/blog\/author\/tim\/"}]}},"_links":{"self":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/6276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=6276"}],"version-history":[{"count":1,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/6276\/revisions"}],"predecessor-version":[{"id":12529,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/6276\/revisions\/12529"}],"wp:attachment":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=6276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=6276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=6276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}