Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    36

    Question Unanswered: Migrating your live database

    Hi People,

    I am not too sure if this is the correct section to post this. (Mods pls move this to the appropriate section if not)

    This is a common scenario when you need to move your live website which has a good amount of traffic all the time to a new server. How do you manage to move the db WITHOUT locking the db or putting up a "site under maintenance" page and loosing any data?

    Whats the best approach?

    Thanks in advance

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Avoiding downtime is almost impossible, the thing to think through is to limit the downtime. For example, if the database is large then this implies more data will need to be copied across from one server to another before the database is available. Once all the data is copied then you flip the switch and make the database live.

    Another approach is to enable replication from one database to the other. This way you have the two databases in sync. Then you stop access on the primary databases and change the scripts to point to the other database. This reduces the downtime of the application and impact on your end users.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Mar 2008
    Posts
    36
    Thanks for this idea

Posting Permissions

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