{"id":6788,"date":"2018-05-24T16:39:21","date_gmt":"2018-05-24T06:39:21","guid":{"rendered":"http:\/\/nsrd.info\/blog\/?p=6788"},"modified":"2018-12-11T07:30:15","modified_gmt":"2018-12-10T21:30:15","slug":"sandpits-in-enterprise-data-protection","status":"publish","type":"post","link":"https:\/\/nsrd.info\/blog\/2018\/05\/24\/sandpits-in-enterprise-data-protection\/","title":{"rendered":"Sandpits in enterprise data protection"},"content":{"rendered":"

“Practice makes perfect” is not just a common saying, it says in three short words how<\/em> humans learn to do things. You could sit and read as many books as you want to on how to play the clarinet, but until you pick one up, hold it and blow into the mouth piece, you won’t have a chance of becoming proficient.<\/p>\n

\"Studying\"<\/a>
Studying<\/figcaption><\/figure>\n

Many businesses have ‘sandpit’ areas for core business functions \u2013 SAP, Oracle, SQL, even sometimes SAN and NAS, but it’s still relatively<\/em> rare to see businesses allocate resources to data protection, and particularly backup\/recovery sandpits.<\/p>\n

My question on this is \u2013 why?<\/p>\n

The reason we see database teams in particular having sandpit areas is that the business functions they support are often mission-critical, or generate significant value to the business. If they make a mistake, or don’t get to test something before it goes into production, the results could be catastrophic for the business.<\/p>\n

Is that very much different from a backup administrator though? Let’s think of a few errors I’ve seen backup administrators make over the years:<\/p>\n

    \n
  • Deleted all backups newer<\/em> than 3 months, rather than older<\/em> than 3 months<\/li>\n
  • Recovered a Linux root filesystem over a Solaris root filesystem (I’ll confess: I did this. And it was the backup server’s root filesystem I did the recovery over.)<\/li>\n
  • Configured notifications to ignore all warnings about open files, generating an unrecoverable backup<\/li>\n
  • Deployed backup on new operating systems or applications without any testing whatsoever<\/li>\n
  • Performed a large-step upgrade on Data Domain leaving NetWorker with incompatible libraries, forcing a rapid upgrade roll-out (e.g., in one day jumped from DDOS 5.4 to DDOS 6, without understanding the Boost library implications)<\/li>\n
  • And more generally, assumed too much<\/em>.<\/li>\n<\/ul>\n

    There’s a simple point I’m trying to make here: if the business believes that a database administrator, for instance, who makes an untested change to production can cause a significant business impact, what’s the risk of a failure when working with backups \u2013 that touches so much of the business \u2013 and doing something untested that goes wrong?<\/p>\n

    Arguments I’ve heard over the years on why we shouldn’t<\/em> have sandpits include:<\/p>\n

      \n
    • You should know our environment well enough to advise if changes will have an impact on us:\n
        \n
      • That’s not only presumptuous, it’s also side-stepping the issue.<\/em><\/li>\n<\/ul>\n<\/li>\n
      • Enterprise systems should not need sandpits:\n
          \n
        • So take the sandpits away from everyone else in the organisation then.<\/em><\/li>\n<\/ul>\n<\/li>\n
        • It’s only backup:\n
            \n
          • That’s like the knight in Monty Python’s The Holy Grail shouting, “It’s only a flesh wound!” Backup isn’t only backup \u2013 it’s critical IT insurance.<\/em><\/li>\n<\/ul>\n<\/li>\n
          • That’s what support services are for:\n
              \n
            • Do you drive without a seatbelt too, because that’s what paramedics are for?<\/em><\/li>\n<\/ul>\n<\/li>\n
            • We can’t afford the licensing:\n
                \n
              • You don’t have to backup the world in a sandpit. A 5 Socket DPS for Virtual Machines license, or a 1TB DPS for Backup license would likely give you more than enough for a sandpit.<\/em><\/li>\n<\/ul>\n<\/li>\n
              • Hardware is expensive:\n
                  \n
                • What’s the cost of a significant failure from not testing adequately before rolling into production? And unless we’re talking tape drives, we can go software-defined on almost everything.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                  I’m not trying to be flippant in the above, but I’ll be honest \u2013 after 22 or so years working in data protection, I’ve heard all the reasons to not<\/em> provide a sandpit to the backup environment, and I’ve never yet been convinced on a single one. Backup is important, and needs to be treated as such<\/strong>.<\/p>\n

                  The same applies to other data protection options that the business uses. If you make use of snapshots and replication, you should have some way of testing them; if you make use of CDP technology (e.g., RecoverPoint for Virtual Machines), you should have test protocols. And so on<\/em>. It’s not rocket science. Or maybe it is \u2013 if you do it wrong, it can be pretty serious, so why not invest in helping to ensure it’s done right?<\/p>\n

                  (And if someone tells you that you don’t need a sandpit, they’re<\/em> being cavalier with your<\/em> data, and encouraging you to take bad risks.)<\/p>\n","protected":false},"excerpt":{"rendered":"

                  “Practice makes perfect” is not just a common saying, it says in three short words how humans learn to do things.…<\/p>\n","protected":false},"author":1,"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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5,1133],"tags":[764,1436,993],"class_list":["post-6788","post","type-post","status-publish","format-standard","hentry","category-backup-theory","category-best-practice","tag-production","tag-sandpit","tag-test"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKpIN-1Lu","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/6788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/comments?post=6788"}],"version-history":[{"count":6,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/6788\/revisions"}],"predecessor-version":[{"id":7355,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/6788\/revisions\/7355"}],"wp:attachment":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media?parent=6788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/categories?post=6788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/tags?post=6788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}