{"id":1976,"date":"2010-02-17T11:52:00","date_gmt":"2010-02-17T09:52:00","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=1976"},"modified":"2010-02-17T11:54:09","modified_gmt":"2010-02-17T09:54:09","slug":"defined-your-mysql-backup-recovery-plan-recently","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/defined-your-mysql-backup-recovery-plan-recently","title":{"rendered":"Defined your MySQL backup &#038; recovery plan recently?"},"content":{"rendered":"<p>Following up on <a href=\"http:\/\/ronaldbradford.com\/\">Ronald Bradford<\/a>&#8216;s <a href=\"http:\/\/ronaldbradford.com\/blog\/checked-your-mysql-recovery-process-recently-2010-02-15\/\">Checked your MySQL recovery process recently?<\/a> post, I wish to add a <em>prequel<\/em>.<\/p>\n<p>To see whether you have a clear definition of your backup requirements, ask yourself these questions:<\/p>\n<ul>\n<li>Is there a backup\/restore plan?<\/li>\n<li>Is there a written backup\/restore plan?<\/li>\n<li>How fast do you need to recover a backup? What&#8217;s the longest downtime you will allow from the point of failure to the point of restored, functional database?<\/li>\n<li>How much data are you willing to lose in case of crash? A second&#8217;s worth of data? An hour&#8217;s worth? A day&#8217;s worth? None?<\/li>\n<li>Are you willing to allow that the database becomes read-only when taking the backup? Or completely down?<\/li>\n<li>Are you willing to take the risk that the backup will not be 100% compatible with the data? (Backing up your slave holds this risk)<\/li>\n<li>Is your manager willing to all that you are willing?<\/li>\n<li>Is the backup plan known to the management team, or do they just know that &#8220;<em>the database has backups<\/em>&#8220;?<\/li>\n<\/ul>\n<p>The above checklist is by no means complete.<\/p>\n<p>I have a vivid memory of a very good sys admin who failed on the last two points. He had some very sour days when recovering a lost file from tape took much longer than was affordable to some contract.<\/p>\n<p>I found that technical people rarely share the same views as marketing\/management. Make sure to consult with the management team; they will have a clearer view on what the company can afford and what it cannot afford.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following up on Ronald Bradford&#8216;s Checked your MySQL recovery process recently? post, I wish to add a prequel. To see whether you have a clear definition of your backup requirements, ask yourself these questions: Is there a backup\/restore plan? Is there a written backup\/restore plan? How fast do you need to recover a backup? What&#8217;s [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_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,"enabled":false},"version":2}},"categories":[5],"tags":[7,8],"class_list":["post-1976","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-backup","tag-replication"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-vS","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=1976"}],"version-history":[{"count":10,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1976\/revisions"}],"predecessor-version":[{"id":1985,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1976\/revisions\/1985"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=1976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=1976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=1976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}