Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Moving to a New Server

  1. #1
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default Moving to a New Server

    Hey All,

    Thought I'd let everyone know, I'm having the site moved to a new server. I think it's going to start sometime tonight (10/9/2105), though it may be tomorrow.

    You shouldn't notice anything while things are being moved, however when I change name servers there will be a time where some people see the site on the current server and some see it on the new one. I'm mentioning this because it's possible if you post something over the weekend you might end up on the current server even though the site is on the new server, in which case it may not be there in a day or two when all the changes have gone through.

    Just wanted to let you know in case you post something over the weekend and don't see it on Monday. It's possible it ended up on the wrong server.

    I apologize in advance if something you write seems to disappear. If that happens let me know. Odds are I'll be able to access things and add them after everything is moved.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

  2. #2
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default

    Still waiting on the server move. I'll update this thread again when I know more.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

  3. #3
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default

    Still waiting. I received an email suggesting the move would go through yesterday and nothing happened and I haven't heard since. Perhaps today. I'll keep everyone updated as I know more.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

  4. #4
    Discount Prodigy
    Array
    Owen's Avatar

    Join Date
    Mar 2014
    Location
    Localhost
    Posts
    769

    Default

    Who did you move to?

  5. #5
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default

    I haven't finished moving yet. The company that will be hosting the forum is Webair. They moved the site and I tested it, but because the forum is updated all the time with new content, I need to move a bunch of tables in the database again. I want to do that over a weekend so there's as little disruption as possible, but I haven't been able to the last few weekends. I'm hoping this weekend I'll have the time.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

  6. #6

    Default

    Will they not let you set up the database as a replication slave? Or put the two databases across hosts in master-master replication? That's how I usually do zero downtime migrations.
    || VMdoh - Drupal development, consulting, and support

  7. #7
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default

    It's possible, but all that went over my head. I was originally going to do everything myself, but I gave them a call and asked them to move everything. Unfortunately they did the work on a Wednesday and by the time I knew everything had moved, I was going to have to move whatever had updated.

    I'm mostly concerned for when he DNS propagates. Depending on where you get your internet you might be on either the new or old site for a day or two. That's why I figured it would be best to finish up over the weekend. My plan is to spend Friday afternoon updating the tables that have changed on the new database and then flip the nameserver switch Friday night. It's usually quiet enough over the weekend that not too much should change while the DNS changes take effect. Then I'll go in to the old database after the weekend and update what might be different between the two servers.

    What's the easiest way to update the tables? I'm sure this isn't the most efficient way, but I was planning on exporting the tables from the old server and then deleting the same table on the new server and importing. The problem with that approach is there are 65 or so tables that I know have updated and by the time I complete the process I'm sure some of them will have changed again. I'm thinking if I started late enough on Friday, there won't be too many changes made after I get started.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

  8. #8
    Registered User
    Array
    Freelancier's Avatar

    Join Date
    Sep 2012
    Location
    Georgia
    Posts
    2,113

    Default

    Have whoever is managing your DNS to reduce the TTL time to an hour.
    Low-Cost Total Compensation Statements - No minimums, no setup costs.
    Going to Disney World for Vacation? Rent One Of Our Vacation Homes

  9. #9
    Registered User
    Array
    MyITGuy's Avatar

    Join Date
    Apr 2011
    Location
    Miami, FL
    Posts
    970

    Default

    Quote Originally Posted by vangogh View Post
    What's the easiest way to update the tables? I'm sure this isn't the most efficient way, but I was planning on exporting the tables from the old server and then deleting the same table on the new server and importing. The problem with that approach is there are 65 or so tables that I know have updated and by the time I complete the process I'm sure some of them will have changed again. I'm thinking if I started late enough on Friday, there won't be too many changes made after I get started.
    If you can't do replication then I would suggest the following:
    1 - Drop the TTL (Time to Live) values down to 1 hour asap.
    2 - When its time to perform the migration - put the board in maintenance mode.
    3 - Export the database on your old host using your favorite tool (Assuming phpMyAdmin?)
    4 - Import the database on your new host using your favorite tool (Again, phpMyAdmin?). I can test, but you may need to drop/delete the database first from your new host.
    5 - Login to the new host (Either via Domain if it replicated, via IP if you have access, or via editing host file as a last resort) and remove the board from maintenance mode.

    During the migration the old host will be in maintenance mode to prevent any new posts (If you can put a message to redirect them to the IP that would be great) that you have to worry about replicating later. We will understand!

  10. #10
    Post Impressionist
    Array
    vangogh's Avatar

    Join Date
    Aug 2008
    Location
    Boulder, Colorado
    Posts
    15,061
    Blog Entries
    1

    Default

    Thanks. Oddly enough my hosting company called this morning asking if I'd tested the site on the new server so they could update the database. I hadn't realized they were going to do that work too. I set things up for Friday evening and as soon as everything has been updated, I'll do a quick test and then change the name servers.

    I thought about putting the site on the current, soon to be old server, in maintenance mode, but I didn't want to shut things down for a couple of days. It's hard to know when all the DNS cache around the web has been changed. I suppose people would only see the maintenance message if they're looking at the old site so maybe that's what I'll end up doing.

    I was thinking we don't have a lot of activity between Friday night and Sunday night and I could leave both sites up and move anything new early next week. I don't expect there will be a lot of activity over the weekend. If I do that I'll leave a message somewhere to let people know what's going on so if they don't see their post a day or two after making it, they'll know why and that it'll show up in another day or two.

    Guess I'll think about it the next couple of days and decide what to do. Setting the site on the old server to maintenance mode is the easiest thing for me, but I didn't want someone to visit hoping to ask a question and not be able to.

    Thanks again for the advice.
    l Join me as I share my creative process and journey as a writer | StevenBradley.me
    l Design, Development, Marketing, and SEO Tutorials | Steven Bradley's Notebook
    l Get my book about Design Fundamentals

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •