[Today’s run: 12 miles]<\/p>\n
There is a small job for the office that I need to do this weekend.<\/p>\n
I have a note here in front of me that says\u00a0 something like “move rates this weekend, prod–>test”.\u00a0 That means I need to copy a handful of database tables from the production system to the test system.\u00a0 Another guy will then work on the rate configuration (this is a utility billing system, electric, water, storm water, that kind of thing).\u00a0 When he is done I will have to move the new rates into the production system.<\/p>\n
“Production” means the system that is being used every day to do the real work.\u00a0 “Test” is a different database where we can try things out and generally make a mess but it doesn’t hurt the customers.<\/p>\n
The tricky part with this is that these tables are referenced by other tables in the system.\u00a0 So I have to turn off some of the internal checks and balances when I do it.\u00a0 I can do it pretty fast, 10-15 minutes total, so if I pick a strategic time it is very unlikely to cause any trouble.\u00a0 It is the destination system that has to have these turned off.\u00a0 This weekend’s copy is into “test” and that doesn’t have anyone using it during the weekend.<\/p>\n
The “production” system does have people using it during the weekend.\u00a0 Over the years that I have been working on this system it has slowly evolved into a nearly 24×7 operation.\u00a0 It used to be only the customer service people and some of the metering departments that used the system.\u00a0 But then we got tied in to a telephone payment system (check your balance 24×7 by calling in over the telephone via touch-tone) and we are tied in to an outage management system and to a new real-time metering system.\u00a0 So any time I do something disruptive I have to plan in advance and make announcements and get everything squared away ahead of time.<\/p>\n
As a practical mater, I don’t think there is any way for me to even find out that a customer is using the telephone access system at any given time.\u00a0 And I don’t think there is any way for them to complain when the main office is closed.\u00a0 But we like to have things running when the customers are expecting it to be running.<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
[Today’s run: 12 miles] There is a small job for the office that I need to do this weekend. I have a note here in front of me that says\u00a0 something like “move rates this weekend, prod–>test”.\u00a0 That means I need to copy a handful of database tables from the production system to the test […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-3194","post","type-post","status-publish","format-standard","hentry","category-work"],"_links":{"self":[{"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/posts\/3194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3194"}],"version-history":[{"count":1,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/posts\/3194\/revisions"}],"predecessor-version":[{"id":3195,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=\/wp\/v2\/posts\/3194\/revisions\/3195"}],"wp:attachment":[{"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3194"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w0ep.us\/OM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}