Stop Database Writes during Dump and Move

  • To improve performance on our site we are splitting off the MySQL database so that it is not on the same server as the Apache and other files. To do this we need to dump the very large MySQL database (takes at least 1/2 hour) and then import it into the new SQL server (another 1/2 hour).

    I have looked and found maintenance mode and other maintenance plugins, but all those put up a page that says the site is down.

    My question: Is it possible to just turn off “updates” on the MySQL server so that pages continue to be served, but no changes are made. Then when the new server is ready we can just change the wp-config file and turn on updates again.

    What do y’all think? Would that work? Anything we are missing?

  • The topic ‘Stop Database Writes during Dump and Move’ is closed to new replies.

Tags