{"id":367,"date":"2012-02-17T00:48:06","date_gmt":"2012-02-17T05:48:06","guid":{"rendered":"http:\/\/littlesvr.ca\/grumble\/?p=367"},"modified":"2012-12-05T00:47:10","modified_gmt":"2012-12-05T05:47:10","slug":"homebrewed-live-server-migration","status":"publish","type":"post","link":"http:\/\/littlesvr.ca\/grumble\/2012\/02\/17\/homebrewed-live-server-migration\/","title":{"rendered":"Homebrewed live server migration"},"content":{"rendered":"

I mentioned<\/a> that I’ll talk about the software migration from the old littlesvr.ca hardware to the new machine. The neat thing is – I accomplished it in less than a minute of downtime while preserving all my data\/metadata.<\/p>\n

Here’s the long story<\/strong> (shorter version at the bottom):<\/p>\n

    \n
  1. First step was to install the OS on the new hardware. This was a full install (just like the old one) of the newest available Slackware version.<\/li>\n
  2. At this point I had two servers running, on different internal IPs, both claiming to be littlesvr.ca but only one (the old one) beeing accessible from the internet.<\/li>\n
  3. Then I had to remember\/relearn how to use rsync (-avx).<\/li>\n
  4. My first sync was from the entire root of the old server into a directory on the home partition on the new one. I’ve used this tree to set up the services the way I wanted them. Most services I reconfigured manually rather than using the old config files – partly because I was expecting the newer versions to have different options (which was sort of true with Apache) and partly because I wanted to make sure I’ve done it right the first time (mostly I have).<\/li>\n
  5. Don’t underestimate the step above, that was a lot of work. Things I have completely forgotten about such as my aliases.db file and the stunnel config had to be accounted for.<\/li>\n
  6. Originally I was going to keep all the keys from the old server, but instead I’ve decided to consolidate the keys and now I have one set for most of the services I use. Yeah, yeah, whatever.<\/li>\n
  7. I also needed to migrate my MySQL databases (of which I have a few). It turned out that just copying \/var\/lib\/mysql isn’t enough, so I had to make an SQL dump of the old database and restore it on the new server. That approach had these problems:\n
      \n
    • The old database wasn’t as secure as I liked, it still had the test db in it, and though I’m sure I went through the users thoroughly, I wasn’t sure enough.<\/li>\n
    • The dump included the “mysql” database, which had some tables that changed slightly in the newer version. So mysql refused to work properly.<\/li>\n<\/ul>\n<\/li>\n
    • So even after doing a dump, and transferring the dump over to the new server, and importing it, I still needed to run a couple of commands to secure the databases and make MySQL happy.<\/li>\n
    • The second rsync was more complex. Here I had to sync my home directories (lots of static\/dynamic data), the SQL, and \/var\/spool\/mail.<\/li>\n
    • And now the magic:<\/li>\n<\/ol>\n

      This is the short version, and the interesting part<\/strong>, here’s what I did:<\/p>\n

        \n
      1. Opened up my router web configuration page in the browser, navigated to the port forwarding page, and changed all the IPs for forwarded services from the old server’s LAN address to the new one’s. But didn’t save the changes yet.<\/li>\n
      2. Stopped all the relevant services on the new server (simple script).<\/li>\n
      3. Ran the second rsync again, this completed much quicker than the first time because most of the data was unchanged.<\/li>\n
      4. Restarted all the relevant services.<\/li>\n
      5. Pressed save on my router config.<\/li>\n<\/ol>\n

        The trick worked so well I amazed myself :) I happend to be tailing my apache logs on both the old and new server while doing the final steps of the migration, and the second I saved my new port forwarding settings I saw the logs stop on the old server and start on the new one. It was an awesome feeling.<\/p>\n

        I’m sure I must have said in the past that rsync is a pain in the ass. I don’t necessarily take it back – but I will say I appreciated having such a powerful tool that day.<\/p>\n","protected":false},"excerpt":{"rendered":"

        I mentioned that I’ll talk about the software migration from the old littlesvr.ca hardware to the new machine. The neat thing is – I accomplished it in less than a minute of downtime while preserving all my data\/metadata. Here’s the long story (shorter version at the bottom): First step was to install the OS on … <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-andrew","4":"post-367","6":"format-standard","7":"category-opensource","8":"category-safeforseneca"},"_links":{"self":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/comments?post=367"}],"version-history":[{"count":2,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/367\/revisions"}],"predecessor-version":[{"id":569,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/367\/revisions\/569"}],"wp:attachment":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/media?parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/categories?post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/tags?post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}