Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Location
    Western MA, USA
    Posts
    604
    Plugin Contributions
    6

    database error moving server minimal down time w/ consistent database

    Hi there,
    I am going to have to move a few ZC's over the next few days and had an Idea, and was looking for comments on my idea.
    Propagation of a url from DNS to DNS can be painfully slow for some people, I mean who wants to have their site down for up to 48 hours to some people.
    In the past what I have done is set up the new server and worked from the IP or a DNS zoned sub domain, on the new server. I get it all set up and then put the site that is running on the old server into maintenance mode.
    At that point I get a fresh copy of the data base and put it on the new server, take that off of maintenance mode, and change the DNS, and wait for propagating. so only people w/ updated whois servers get a live site.
    What I want to do now is copy all the files over to the new server, but have the config on the new serve pointing to the old mysql server (via IP address). So when I change the DNS either way, during the propagation period if they get either server, they get a live database.
    What I am worried about is session data getting messed up and having some one loose the contents of their cart should they get changed over while browsing.

    Ok it was an Idea, tell me why I am a genius or a total moron who is missing technical details that a 5 year old can grasp.

  2. #2
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: moving server minimal down time w/ consistent database

    I use this method all the time,
    thsw only issue I have ever had is someone not understanding completly and taking the old site OFF of maintenance mode.




    another thing that will help is if you have access to the a and ns records on the old server, if you do point them all to the new server,
    Zen cart PCI compliant Hosting

  3. #3
    Join Date
    May 2005
    Location
    Western MA, USA
    Posts
    604
    Plugin Contributions
    6

    Default Re: moving server minimal down time w/ consistent database

    Quote Originally Posted by Merlinpa1969 View Post
    another thing that will help is if you have access to the a and ns records on the old server, if you do point them all to the new server,
    brilliant thanx tony, if you say it can be done it can be.

    JOsh

 

 

Similar Threads

  1. v154 Error 1044 when moving database to new server
    By Annie_zaz in forum Installing on a Linux/Unix Server
    Replies: 18
    Last Post: 19 Jan 2016, 03:04 PM
  2. v151 Server/database time zone correct in admin wrong in database
    By badarac in forum General Questions
    Replies: 10
    Last Post: 30 Sep 2015, 08:10 PM
  3. Moving from windows server to linux server - how to restore database ?
    By PatF in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 26 Mar 2011, 02:26 PM
  4. Replies: 2
    Last Post: 10 May 2009, 09:56 PM
  5. Moving to new server ... can I upgrade at the same time?
    By wortex in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 21 Jun 2008, 05:36 AM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR