{"id":1643,"date":"2010-06-21T04:30:12","date_gmt":"2010-06-21T11:30:12","guid":{"rendered":"http:\/\/www.todayifoundout.com\/?p=1643"},"modified":"2012-11-27T20:28:24","modified_gmt":"2012-11-28T04:28:24","slug":"site-down-and-back","status":"publish","type":"post","link":"http:\/\/www.todayifoundout.com\/index.php\/2010\/06\/site-down-and-back\/","title":{"rendered":"Site Down and Back"},"content":{"rendered":"<div class=\"pf-content\"><p><a href=\"http:\/\/www.todayifoundout.com\/wp-content\/uploads\/2010\/06\/funny-pictures-kitten-looks-for-bugs-in-your-computer.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-full wp-image-1644\" title=\"Server Bugs\" src=\"http:\/\/www.todayifoundout.com\/wp-content\/uploads\/2010\/06\/funny-pictures-kitten-looks-for-bugs-in-your-computer-e1277209924987.jpg\" alt=\"Server Bugs\" width=\"325\" height=\"223\" \/><\/a><a href='http:\/\/www.todayifoundout.com' title='Interesting Facts'>Today I found out<\/a> to always shut down MySQL instances manually before restarting the operating system. \ud83d\ude42<\/p>\n<p>You may have noticed TodayIFoundout.com has been down for the last 38 or so hours.\u00a0 Long story short, I needed to restart my server and when it came back up, the MySQL instance had been corrupted due to not shutting down all the way before the OS restarted.\u00a0 For those who don&#8217;t know, MySQL is the database software that serves as the back end for my various sites including todayifoundout.com.<\/p>\n<p>In any event, despite my sincerest efforts, focusing my considerable expertise (B.S. and M.S. in Computer Science and several years of real world experience) on the problem\u00a0 for about 23+ straight hours, I could not get any instance of MySQL to start on my server.\u00a0 The issue turned out to be a known bug in MySQL, but this did not help me as none of the work-arounds fixed the issue.<\/p>\n<p>After no luck with fixing the corrupted MySQL instance or getting new instances installed and started, I finally gave up and tried another tact, which is typically a last resort type of option on live server type setups, but I thought it might be a quicker fix and it was.\u00a0 After taking a couple hours rest, I eventually completely re-imaged my system with a clean operating system install and re-configured everything and restored the sites and databases from there.\u00a0 Lesson learned.<\/p>\n<p>Sorry for the down time.\u00a0 New &#8220;<a href='http:\/\/www.todayifoundout.com' title='Interesting Facts'>Today I Found Out<\/a>&#8221; posts will be on the way presently.\u00a0 For now, I need some rest. \ud83d\ude42<\/p>\n<p><span id=\"bonusfacts\">Bonus<\/span> Facts:<\/p>\n<ul>\n<li>The &#8220;My&#8221; in &#8220;MySQL&#8221; was named after co-creator Michael Widenius&#8217; daughter, &#8220;My&#8221;.<\/li>\n<li>MySQL is often mispronounced &#8220;My Sequel&#8221;.\u00a0 It is officially supposed to be pronounced &#8220;My S-Q-L&#8221;.\u00a0 So apparently, even with my B.S. and M.S. in Computer Science, I have always been pronouncing this wrong. \ud83d\ude42<\/li>\n<li>MySQL was first released by Michael Widenius and David Axmark on May 23, 1995.<\/li>\n<li>MySQL was eventually sold to Sun on February 26, 2008.\u00a0 Sun was later acquired by Oracle very recently on January 27, 2010.\u00a0 If you aren&#8217;t familiar, Oracle is one of the larger companies in the world primarily dealing in database software.<\/li>\n<li>Oracle&#8217;s co-founder, Larry Ellison, is currently worth about 28 billion dollars, making him the 6th richest person in the world.\u00a0 At one time, in the early 2000s, he was the richest person in the world.<\/li>\n<li>Ellison is known for his extravagant lifestyle.\u00a0 His home Japanese style estate is estimated to be worth about 200 million dollars.\u00a0 He also co-owns the sixth largest yacht in the world, the Rising Sun,\u00a0 which also cost around 200 million dollars.\u00a0 A licensed pilot, Ellison owns several aircraft, including several fighter jets, which have on occasion gotten him in trouble with the law.\u00a0 Among his many cars, including the Audi R8 and McLaren F1, his favorite is the Acura NSX, which he frequently gives away as gifts.<\/li>\n<li>At Ellison&#8217;s wedding to his fourth wife, Melanie Craft, a romance novelist, Steve Jobs was the wedding photographer.<\/li>\n<li>The Oracle database software was originally created for the CIA in the 1970s.\u00a0 After completing the work for the CIA, Ellison took the Oracle software and created the current Oracle company in 1977 under the name &#8220;Software Development Laboratories&#8221;, which was later named &#8220;Relational Software Inc.&#8221;, and then &#8220;Oracle&#8221;.\u00a0 The database software itself was inspired by a paper Ellison had read by Edgar F. Codd on a &#8220;relational model of data for large shared data banks&#8221;.<\/li>\n<li>MySQL creator Michael Widenius started a movement to try to stop Oracle from getting their hands on MySQL when they acquired Sun, due to his concerns over what they will do with it.\u00a0 MySQL is not only open source but currently is also free, unless you want professional level technical support and other such business &#8220;features&#8221;.\u00a0 There is some thought that Oracle may change this quite soon, though Oracle has denied it.<\/li>\n<li>Michael Widenius never finished college.\u00a0 He studied at Helsinki University of Technology before dropping out, pursuing his own business interests.\u00a0 Besides his daughter My, he also has a wife Anna, a daughter Maria, and a son Max; the latter of which &#8220;MaxDB&#8221; is named after.\u00a0 He&#8217;s also currently working on a branch of MySQL with a &#8220;Maria&#8221;\u00a0 storage engine.<\/li>\n<li>If this server problem I had would have happened just three days later than it did, it wouldn&#8217;t have been a problem.\u00a0 I just bought and shipped off a new server to my host that has backup drives built in for storing full images of the system.\u00a0 It is also configured to be able to re-image the main drives within about 15 minutes or so of something like this occurring, if I ever need it.\u00a0 My current setup only allows me to back up the files themselves, which doesn&#8217;t help too much when the underlying software is the problem.\u00a0 The new server is also much nicer than my old, so will allow for faster sites during peak load times.<\/li>\n<li>Now that I&#8217;m about done re-configuring everything on my current server, I get to do it all again when my new server arrives at my host tomorrow. Timing! \ud83d\ude42<\/li>\n<\/ul>\n<span class=\"collapseomatic \" id=\"id69efb72915713\"  tabindex=\"0\" title=\"Expand for References:\"    >Expand for References:<\/span><div id=\"target-id69efb72915713\" class=\"collapseomatic_content \">\n<ul>\n<li><a title=\"MySQL\" href=\"http:\/\/en.wikipedia.org\/wiki\/MySQL\" target=\"_blank\">MySQL<\/a><\/li>\n<li><a title=\"Michael Widenius\" href=\"http:\/\/en.wikipedia.org\/wiki\/Michael_Widenius\" target=\"_blank\">Michael Widenius<\/a><\/li>\n<li><a title=\"Larry Ellison\" href=\"http:\/\/en.wikipedia.org\/wiki\/Larry_Ellison\" target=\"_blank\">Larry Ellison<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p><a href='http:\/\/www.todayifoundout.com' title='Interesting Facts'>Today I found out<\/a> to always shut down MySQL instances manually before restarting the operating system. \ud83d\ude42 You may have noticed TodayIFoundout.com has been down for the last 38 or so hours.\u00a0 Long story short, I needed to restart my server and when it came back up, the MySQL instance had been corrupted due to not shutting down all the [&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":1644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,3],"tags":[],"class_list":["post-1643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-announcements","category-today-i-found-out"],"_links":{"self":[{"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/posts\/1643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/comments?post=1643"}],"version-history":[{"count":4,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/posts\/1643\/revisions"}],"predecessor-version":[{"id":1655,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/posts\/1643\/revisions\/1655"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/media\/1644"}],"wp:attachment":[{"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/media?parent=1643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/categories?post=1643"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.todayifoundout.com\/index.php\/wp-json\/wp\/v2\/tags?post=1643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}